Microsoft Excel Advanced 2007


Course Enquiry Form
*Email:

*First name:

*Last name:

*Telephone:

*Comments:

To view detailed information for this workshop view the pdf below:

Download File Microsoft Excel Advanced 2007Microsoft Excel Advanced 2007

The duration of this course is one day. The aim of the course is to enable the delegate to work at an Advanced level gaining an insight into more complex formulas and data manipulation adding more comprehensiveness to spreadsheet integrity.  Using In-Cell Charts and Conditional Formatting will enhance data graphically. Pivot Tables and Advanced Filters enable the user to manipulate and summarise data for comprehensive data analysis.

Delegates wishing to attend this course need to have attended the Excel Essentials and Intermediate courses or be fully conversant with the topics that are covered in these courses.

Course Content:

  • Working with comments
  • Using lookup functions
  • Using logical functions
  • Using maths functions
  • Using statistical functions
  • Understanding formula auditing
  • Working with custom views
  • Working with conditional formatting
  • Using advanced filtering
  • Working with pivot tables
  • Working with pivot charts

For further enquiries, contact us using the Course Enquiry Form on the right of the screen.

 

Part of the Microsoft Word Training | Microsoft Word Courses | Bedfordshire | Buckinghamshire | Hertfordshire range of courses