Microsoft Excel Advanced 2007

Microsoft Excel Advanced 2007

This course outline shows topics covered during a typical one-day training course. However, ICS offer a flexible approach - if preferred, courses can be tailored to suit delegates’ needs: select those areas where specific training is required.

w Working with Advanced Filters w Working with Multiple Worksheets and Workbooks

w Creating and using a criteria range

w Using comparison criteria w Using multiple workbooks w Using advanced And/Or conditions w Linking worksheets with 3-D formulae w Lookup and Reference Functions w Consolidating data w Using the LOOKUP function w Linking workbooks

w Using the VLOOKUP function

w Managing workbooks w Using the HLOOKUP function w Using Analysis Tools

w Importing Data

w Goal Seek

w Using Paste Special

w Using Solver

w Object linking and embedding

w The Scenario Manager

w Importing a text file

w Macros

w Working with Outline View

w What is a macro?

w Applying an outline

w Recording and running a macro

w Expanding/collapsing an outline

w Editing a macro w Auditing a Workbook

w Assigning a macro to a toolbar

w Auditing tools

w Protecting your Data

w Locating errors in formulae

w Hiding data and worksheets

w Data entry validation

w Password protecting sheets, formulae and workbooks

w Auditing data dependency

w Pivot Tables

w Creating and editing pivot tables

w Creating a pivot chart