Intermediate - Microsoft Excel Training Course:  

 

 

Synopsis:

 By the end of this Microsoft Excel course you will know how to:

  • Use multiple excel workbooks
  • Use advanced formatting
  • Outline and subtotal
  • Create and use names
  • Use filters and lists
  • Work with tables
  • Work with the web
  • Use advanced charting
  • Use group features such as auditing
  • Create and manage excel document templates

Pre-Requisites:

No pre course work is required for this Powerpoint training course

Course Outline:

This intermediate course is designed for users who are already confident in the basic features of Microsoft Excel (any version but preferably Office 2007) and wish to further their knowledge and understanding.  In this course we will focus on working with large amounts of data.

In addition to a complete new user interface Microsoft have added new features and enhanced others in Office Excel 2007. This course follows on from our Office Excel 2007 introduction course with more complex formulas and functions. There is a recap session at the start for delegates who may have completed the introduction in a previous version.

Course Content:

Microsoft Excel course content:

Using multiple excel worksheets and workbooks

  • Using multiple excel workbooks
  • Linking worksheets with 3-D formulas
  • Linking excel workbooks
  • Managing excel workbooks

Advanced formatting

  • Using special number formats
  • Using functions to format text
  • Working with styles
  • Working with themes
  • Other advanced formatting

Outlining and subtotals

  • Outlining and consolidating data
  • Creating subtotals

Cell and range names

  • Creating and using names
  • Managing names

Lists and tables

  • Examining lists
  • Sorting and filtering lists
  • Advanced filtering
  • Working with tables

Web and Internet features

  • Saving workbooks as Web pages
  • Using hyperlinks
  • Distributing workbooks

Advanced charting

  • Chart formatting options
  • Combination charts
  • Graphic elements

Documenting and auditing

  • Auditing features
  • Comments in excel cells and workbooks
  • Protection
  • Workgroup collaboration

Templates and settings

  • Application settings
  • Built-in templates
  • Creating and managing excel templates

Learning Outcomes;

  • The skills to utilise database functionality
  • How to create look-ups to obtain range and precise data
  • An understanding of how to add 'IF' statements and using validation to restrict access to cells, rows and columns
  • Knowledge to use the new an improved conditional formatting
  • Useful practical exercises
  • The confidence and knowledge to move on to the next level - Advanced  Microsoft Excel 2007

Duration:

1 Day

No of Delegates – The Total Number of delegates that can sit this is course is a maximum of 12 to uphold the quality of our training and to ensure the course is properly embedded to achieve the companies/individual goals.

Prices – £849 (ex VAT)  Per day for up to 12 delegates trained onsite

(An additional charge for travel will be applied at 40p per mile from Sequence HQ to your premises)