Microsoft Excel 2007 - Advanced

Short course

Inhouse

Price on request

Description

  • Type

    Short course

  • Level

    Advanced

  • Methodology

    Inhouse

  • Duration

    1 Day

About this course

Course delegates would be expected to be able to create spreadsheets with a variety of formulas, functions and charts and have completed our Microsoft Excel Intermediate course.

Questions & Answers

Add your question

Our advisors and other users will be able to reply to you

Who would you like to address this question to?

Fill in your details to get a reply

We will only publish your name and question

Reviews

Course programme

Course Content

Our one day Advanced course in Microsoft Excel, covers the following topics:

  • Naming Cells & Ranges
  • Automatic & conditional Formatting
  • Custom Number Formats
  • Paste & Select Special
  • Importing Data from Other Applications
  • Cell & Sheet Protection
  • Data Handling Queries & Functions
  • Linking & Consolidation
  • Templates
  • Advanced Charting
  • Complex Functions
  • Text Manipulation
  • Lookup & Reference
  • Conditional Formatting
  • Error Checking
  • Pivot Tables
  • Scenarios
  • Data Analysis
  • Goal Seek, Solver & Data Tables
  • Auditing Worksheets
  • Macros, Toolbars & Menus

Microsoft Excel 2007 - Advanced

Price on request