Microsoft Excel Intermediate (Level 2) 2003 2007 2010

Sponsored links

INTERMEDIATE MICROSOFT EXCEL – from Base2
– 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.

Delivery:
  • Classroom
Regions:
  • North East England
Category:

Further Details

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

This Training Course is taught in classrooms in the following locations:
Newcastle
Sunderland

Guide Price: £150