Intermediate Microsoft Excel

Course Objectives

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

Prerequisites

A basic understanding of Windows and all topics covered in the Introduction level course for this application is recommended.

Course Duration

1 day

Course Content

  • Revision
    • Review of Introduction day
    • Revision Exercise
  • More about Calculations
    • Absolute References
    • Using Functions
    • Simple Statistical Functions
    • The IF Function
  • More Features
    • Using Comments
    • Using Zoom
    • Splitting and Freezing
  • Printing Worksheets
    • Fitting a Spreadsheet on a Page
    • Altering Page Margins
    • Adding Headers & Footers
    • Setting the Print Area
    • Using Print Titles
    • Controlling Page Breaks
  • Charting Features
    • Creating Charts
    • Revising a Chart
    • Formatting Chart Elements
    • Adding Data to an Existing Chart
  • Working with Multiple Worksheets
    • Selecting Multiple Worksheets
    • The Worksheets Context Menu
    • Navigating Multiple Worksheets
    • Calculations between Worksheets
  • Data Commands
    • Working with Lists
    • Sorting a List
    • Sub-Totalling a List
    • Filtering a List

Download Course Content PDF

Acrobat-PDF

Download Full Course Schedule PDF

Acrobat-PDF

Ask a question

Please contact us to make a booking or book now on-line.

All courses are available for both scheduled (open) and dedicated (bespoke) delivery. Please contact us for details and pricing.

If you can’t see the course you are looking for – contact info@base2.co.uk