There are currently no MX2003-3 classes scheduled. Please call for the next scheduled class.

If you have a group of four or more students, we can schedule this class for you.

MX2003-3 - Microsoft Excel 2003 Advanced

Categories	MOUS Certification Training, Microsoft Office Training, Microsoft Excel Training, Applications Training
Duration	1 day (7 hours)
Pre-requisites	MX2003-1 - Microsoft Excel 2003 Introduction and MX2003-2 - Microsoft Excel 2003 Intermediate, or equivalent knowledge and experience.
Courseware	MX20033-TL (120 pages)
Price	$195
Notes

Our advanced Microsoft Excel 2003 training course covers data entry and formatting techniques, number formats, conditional formatting, ranges, lookups, templates, auditing, linking multiple workbooks, integration with databases, pivot tables, data analysis, importing and exporting data, workgroup features, Internet integration, working with XML and more.

---

Working with advanced formulas
      Using names
      Using decision-making functions
      Creating nested functions
      Using financial functions
Lookups and data tables
      Working with lookup functions
      Using MATCH and
      Creating data tables
Advanced list management
      Creating subtotals
      Validating cell entries
      Exploring database functions
      Working with data forms
Working with PivotTables and PivotCharts
      Working with PivotTables
      Rearranging PivotTables
      Formatting PivotTables
      Working with PivotCharts
Exporting and importing
      Exporting and importing text files
      Exporting and importing XML data
      Querying external databases
Using analytical options
      Working with Goal Seek and Solver
      Working with the Analysis ToolPak
      Working with scenarios
      Working with views
Working with macros
      Running and recording a macro
      Working with VBA code
      Function procedures
Interactive Web pages
      Creating interactive Web spreadsheets
      Publishing PivotTables on the Web
Using SharePoint services
      Document Workspaces
Smart documents
      Discussing smart documents
Microsoft Office Specialist exam objectives maps
      Specialist exam objectives
      Expert exam objectives