>

Excel Advanced Training Course

Excel Advancedexcel Advanced 2010 training Training Course – £295 London all Inclusive

Advanced Course in Microsoft Excel

  • 1-day Instructor-led, Courses never canceled, Restaurant lunch

 

 Benefits

  • At the end of this course, you will have a complete understanding of the higher functions of Excel.
  • You will be able to perform the most advanced calculations and functions, manipulate data using pivot tables and ‘advanced’ analysis, record macros and integrate with other office applications.

Who is this course for?

Our Microsoft Excel 2010 Advanced course is suitable for those with a sound working knowledge of Excel who wishes to progress to the most complicated functions and features.

Prerequisites

A working knowledge of Excel or our Excel Intermediate course.

Benefits

  • At the end of this course you will have a complete understanding of the higher functions of Excel.
  • You will be able to perform the most advanced calculations and functions, manipulate data using pivot tables and ‘advanced’ analysis, record macros and integrate with other office applications.

Course Syllabus

Using logical functions

Naming ranges
– Creating named ranges
– Using named ranges in formulas
The IF function (recap)
Creating nested IF functions
AND and OR functions
Combining logical functions

Working with lookups

The VLOOKUP function
The HLOOKUP function

Advanced list management

Using data validation
– Setting criteria for entry of text, values and dates
– Creating a dropdown list
Using database functions
– Setting up criteria
– DSUM
– DAVERAGE
– DCOUNT

PivotTables and PivotCharts

Using the PivotTable Wizard
Rearranging PivotTables
Using the PivotTable toolbar
Creating PivotCharts
Using Slicers to manipulate PivotTables

Using analytical options

Using Goal Seek
Using the Solver add-in
Working with scenarios
– Creating and saving scenarios
– Viewing scenarios

Macros

Creating macros
Using the macro recorder
Viewing and editing macro VBA code

Our Excel Intermediate 2010 Training venues & dates – to book please call or complete an enquiry form

Our Excel Intermediate 2010 Training venues & dates – to book please call or complete an enquiry form

What you get

“What do I get on the day?”

Learning tools

Breaks and TimingsBreaks and timing

Courses start at 9:30am.
Please aim to be with us for 9:15am.
Joining information (how to get to our venues)

In-course handbookIn-course handbook

Contains unit objectives, exercises and space to write notes

RefreshmentsRefreshments

Available throughout the day:

  • Hot beverages
  • Clean, filtered water
  • Biscuits
Reference materialReference material

Available online. 100+ pages with step-by-step instructions

LunchLunch

Lunch is provided at a local restaurant or pub. Browse the sample menus:

24 months forum access24 months access to Microsoft trainers

Your questions answered by Microsoft qualified trainers online.

Contact us now and talk to one of our advisers to ask any question you may have about our training.

Blue Find Out More

Send this to a friend