1 2 3 4

Excel Intermediate

Loading Map....

Date/Time
Date(s) - Enquire Now


All Day

Location
The Quill Consultancy

Categories


This one-day course is appropriate if you have used Excel before and are reasonably confident with Excel basics such as simple formula creation, cell formatting, naming of cells, and saving and printing of workbooks.

Prerequisite skills/knowledge:
It is assumed you have good general computing skills, are familiar with the Windows environment and have attended an introductory course in Excel or have equivalent experience.

Topics include:

  • review of spreadsheet basics
  • text boxes and drawing objects
  • charting review
  • worksheet comments
  • worksheet and workbook protection
  • naming cells
  • linking worksheets and workbooks
  • conditional formatting
  • data list management (sorting, filtering, creating subtotals)
  • PivotTables
  • using lookup functions
  • adding form control to worksheets
  • data validation
  • creating simple macros using Visual Basic for Applications

At the completion of the course you should be familiar with a number of techniques that enable the creation of more sophisticated workbooks. You should be able to create a protected workbook that incorporates embedded charts and use a range of data list management tools.

You will also be able to create well documented and consistently formatted workbooks and automate simple tasks.

Notes:
This course covers Excel versions 2007, 2010 and 2013, and 2011 on the Mac.