29/06/2012 Manchester City Centre-64 Bridge Street,M3 3BN £167*+VAT
Or Call 0161 408 0435

* Prices discounted until 30/07/2012. Normal price £195+VAT

This Excel Advanced course is for individuals who have the knowledge and experience to create complex spreadsheets and want to become familiar with more advanced tools & techniques as well as automating repetitive tasks.

On this Microsoft Excel 2010 Advanced training course you will work with advanced formulas. You will create lookups with VLOOKUP, MATCH, and INDEX. In addition, you will learn about database functions such as DSUM and data validation & protection.

You will learn how to work with PivotTables and PivotCharts, use the analytical features of Excel and how to record & run Macros to automate repetitive tasks

Course Contents
Review Introduction & Intermediate Topics

Advanced List Management
Database Functions
Data Forms and Validation
Group and Outline Listed Data

Analytical Options
Goal Seek And Scenario Manager
Data Tables
Scenarios


Exporting And Importing
Notation and Auditing
Comments and Text Boxes
Auditing Features
Workgroup Collaboration
Pivot Tables
Creating A Pivot Table
Rearranging Pivot Tables
Formatting Pivot Tables
Pivot Charts
Group and Outline Pivots
Apply Table Options
Slicers
Sparklines

Macros
Recording And Running A Macro
Editing VBA Code


Last Updated (Friday, 18 May 2012 04:42)