Excel Intermediate

Oak Tree Management & Training Ltd.
Birmingham, Bristol, Cambridge, Edinburgh, London, Manchester, Newcastle, Nottingham, United Kingdom

Course Format: Classroom | E-learning | Virtual Class | Online/Live | On-site/In-house | Blended | Self-paced

Course Description:

'' This course is aimed at delegates who are using Excel to maintain lists of data and carry out some form of analysis on them. It is designed for people who need to know how to fully understand and manipulate lists to maximum effect. This will be done by covering data manipulation and filters, the more advanced mathematical and statistical analysis of data and ultimately the use of Pivot Tables within Excel.

For delegates who use Excel to store and analyse data instead of Microsoft Access.
To create and maintain a list of data that makes lists work for you.
Use Filters to quickly select sets of data within lists.
Manipulate data into useful elements e.g. separate data from a single cell.
See the magic of Pivot Tables and the speed of which they analyse and present statistical information.
Course Objectives
By the end of the course the delegate will be able to:

Be able to create lists that Excel recognises
Print large lists of data with repeating titles
Create, manage and organise information within lists
Manipulate information using various functions
Use Pivot Tables to analyse information within the list
Course Contents
(Course Topics may vary at the Trainer’s Discretion)

List Management
Excel Data List Rules
Use Data Forms
Custom Lists
Print Options
Set print titles and options
Headers & Footers
Page Breaks
Freeze & Split
Freeze and unfreeze rows and columns
Arrange windows of one or more workbooks
Worksheet management
Inserting, moving, naming, hiding, deleting worksheets
Copying Sheets to Other Workbooks
Working with Named Ranges
What are named ranges
Create, Define & Delete Named Ranges
Sorting & Filtering
Perform single and multilevel sorts
AutoFilter & Custom Filters
Outlining
Use grouping and outlines
Subtotalling
Use subtotalling
Data Subtotals versus =subtotal function
Data Validation
Applying Data Validation Criteria
Conditional Formatting
Apply Conditional Formatting
Cell Value
Formula Is
Pivot Tables
Creating a Pivot Table with the Wizard
Adding & Removing items from the Row & Column areas
Adding Filters with Pages
Summarising numbers in the Data Area
Pivot the Row & Column Headings
Refreshing the Pivot Table
Reducing disk space
Selecting different functions
Format with Autoformat
Display Grand Totals
Drill down in to the Data behind a number
Beyond Basic Functions �Optional if time
Standard Date Functions
If Functions
Example Text Function (Left, Right, Mid and Concatenate - &)
VLookup and HLookup ...''

Elements of this syllabus are subject to change.

Phone:(01284) 763040

School Address/Venue(s):

Park Farm Business Centre
Fornham St Genevieve
Bury St Edmunds
Suffolk
United Kingdom
IP28 6TS

Jobs & Resumes: Birmingham, Bristol, Cambridge, Edinburgh, London, Manchester, Newcastle, Nottingham
Houses & Roommates: Birmingham, Bristol, Cambridge, Edinburgh, London, Manchester, Newcastle, Nottingham
Travel Agencies: Birmingham, Bristol, Cambridge, Edinburgh, London, Manchester, Nottingham

Search other schools for Excel Intermediate training resources.

Illustrator CS
InDesign CS
PageMaker 7
Photoshop CS2
Crystal Reports - Advanced
Crystal Reports
Excel - Formulae and Functions
Excel Advanced
Excel Foundation
Excel VBA
FrontPage Advanced
FrontPage
MapPoint
Outlook
Powerpoint - Advanced
Powerpoint
Project

Notice: The course description on this page was captured from the Internet as historical reference or submitted by visitors. It was archived statically and not updated from day to day.
 

Tips: You do not need to register before you can use most of our services. You will get a code for each posting ever made on this website. It is the key for you to remove the posting anytime by yourself.