>

Excel 2003 Advanced

What will I learn

This Excel 2003 advanced course will teach the participants to:

  • Use named ranges in formulas
  • Use LookUp functions
  • Link multiple workbooks
  • Import data
  • Use Pivot Tables and charts
  • Use Templates and styles
  • Analyse data
  • Create and use macros
  • Protect an Excel spreadsheet
  • Consolidate a workbook

Course Outline

Microsoft Excel Advanced Course Content

  • Naming Ranges
  • Define named ranges
  • Use named ranges in formulas
  • VLookUp and HLookUp Functions
  • Using VLookUp
  • Using HLookUp
  • Linking Multiple Workbooks
  • Use formulas to link workbooks
  • Create a workspace
  • Importing Data
  • Import from external sources
  • Using Microsoft Excel Query
  • Pivot Tables and Charts
  • Creating a PivotTable
  • Changing field settings
  • Creating a chart
  • Templates and Styles
  • Working with templates
  • Working with styles
  • Macros
  • Creating macros
  • Adding custom controls
  • Analysing Data
  • Using GoalSeek
  • Using Solver
  • Using Data Tables
  • Scenario Manager
  • Security and Proofing
  • Protecting Excel files
  • Worksheet protection
  • Using data validation
  • Using text to speech
  • Customising Excel 2003
  • Customising toolbars
  • Customising the environment
  • Collaboration and Consolidation
  • Sharing workbooks
  • Sending workbooks
  • Consolidating data

Testimonials

To follow

Run In House In-house Courses – £749 per day

Duration: This course is delivered over: 1 day

*All prices are excluding travel charged at 45 pence per mile.

 

 

Send this to a friend