Microsoft Excel Intermediate (Level 2) 2003 2007 2010

1 day

After the course, delegates will be able to navigate an excel spreadsheet, create/manipulate simple formulae and create charts

A basic understanding of MS Windows is recommended.
Attendance of our Introduction to Microsoft Excel is recommended.

1 More about Calculations
Absolute References
Using Functions
Examples of Functions

2 More Features
Using Comments
Splitting and Freezing
Using Zoom
The Paste Special Command

3 More about Printing
Adding Headers & Footers
Setting the Print Area
Using Print Titles
Controlling Page Breaks

4 More about Charts
The Chart Menu
Revising a Chart
Further Formatting
Drag and Plot

5 Working with Multiple Worksheets
Selecting Multiple Worksheets
Navigating Multiple Worksheets
Calculations between Worksheets

6 Data Commands
Working with Lists
Sorting Lists
Filtering a List

Guide Price: 150

Delivery: Classroom
Category: Intermediate Microsoft Excel »

Search for intermediate microsoft excel courses in