Microsoft Excel - Advanced

Microsoft Excel Advanced 2003, 2007 or 2010

This one day Excel training course will provide you with an understanding of the advanced features of Excel. This course will also de-mystify newer versions of Excel by showing you the main differences from earlier versions, and will also introduce some of Excel`s new and improved features.

Prior Knowledge: Delegates should have a good working knowledge of Excel or have attended the introduction to Excel course.

Aims and Objectives:

By the end of the course participants will be able to 

  • Recap any Problems
  • Whats New in Excel
  • Create Pivot Tables to Summarise Data
  • Using the Pivot Table &
  • PivotChart Wizard
  • Adding a field to a PivotTable
  • Updating data in a PivotTable
  • Sorting data in a PivotTable
  • Setting the Pivot Table options
  • Hiding and showing subtotals
  • Collapsing and expanding levels
  • Extracting data from a Pivot Table
  • Grouping and ungrouping data
  • Grouping dates automatically
  • Record/Playback macros
  • Scenarios
  • What are scenarios?
  • Adding scenarios
  • Scenario summary report
  • Editing & deleting scenarios
  • Use Goal Seek
  • What is Goal Seek?
  • Using Goal Seek Advanced Functions
  • Date functions
  • Typing dates
  • The Today function
  • Using dates in formulae
  • The Sumif and Round functions
  • Statistical
  • The Counta and Countif functions
  • Text Functions 
  • The Concatenate function  

By booking your training with us you will be helping to support and develop a sustainable, not for profit IT resource within the Communities First area, encouraging more community engagement and raising awareness of other development opportunities and leisure time activities locally.


  Follow ByteBack on Twitter»  

Share |