Follow Us :

Advanced Microsoft Excel 2007

Course_Reference: 
REEADE07
Manufacturer: 
0
Training_Provider: 
35
Summary: 

Delegates should have a good grounding in Excel (any version but Excel 2007 is preferable) either from experience or attending training courses. If your job involves manipulating and analysing data in Excel you will find this course very advantageous. Also, if you spend most of your work day in Excel and you would like to fill in gaps in your knowledge you will find this course really useful.

Audience: 

Delegates should have a good grounding in Excel (any version but Excel 2007 is preferable) either from experience or attending training courses. If your job involves manipulating and analysing data in Excel you will find this course very advantageous. Also, if you spend most of your work day in Excel and you would like to fill in gaps in your knowledge you will find this course really useful.

  • Text Functions in Excel 2007
  • Count Functions
  • Advanced ‘If’ statements
  • Auditing Worksheets
  • Trace Cell Precedents & Cell Dependents
  • Locate Errors in Formulas
  • Locate Invalid Data and Formulas
  • Watch and Evaluate Formulas
  • Goal Seek to reverse calculate a formula
  • Creating Single Input Data Tables
  • Dual Input Data Tables
  • Setting up and manipulating scenarios for What-If? Analysis
  • Consolidating Data by position
  • Consolidate by Label
  • Group And Outline Features
  • Create a Pivot Table Reports from new
  • Analysing Data with Pivot Tables
  • Manipulate the Pivot Table
  • Formatting Pivot Tables
  • Creating Pivot Charts
  • Grouping data in Pivot Tables
  • Importing Text Files
  • Setting Up Database Queries
  • Connecting Excel to the Web to Import Data
  • Recording Macros
  • Edit a Macro
  • Creating Buttons to Run the Macros
  • Customize Access to Excel Commands
  • Adding Icons to the Toolbars
  • Creating your own Menu
  • Editing Menus
  • Adding Options to Menus to run Macros

Description: 

Delegates should have a good grounding in Excel (any version but Excel 2007 is preferable) either from experience or attending training courses. If your job involves manipulating and analysing data in Excel you will find this course very advantageous.

Software Vendor

IT Technical

Business Skills