Microsoft (MCAS) Excel 2007 Taining Course Midlands | Birmingham | Telford | Stafford | Wolverhampton

This course assumes no prior knowledge, introduces candidates to Excel 2007 and moves onto advanced topics within the two training days. The syllabus is mapped against the Microsoft Application Specialist qualification and gives a detailed overview of the Excel 2007 application.

Topics include

Getting started in Excel 2007
Excel 2007 Spreadsheet terminology
Exploring the Excel 2007 window
Getting help
Navigating Excel workbooks

Entering and editing data in Excel 2007
Entering and editing text and values
Entering and editing formulas
Working with pictures
Saving and updating workbooks

Modifying a Excel 2007 worksheet
Moving and copying data
Moving and copying formulas
Absolute and relative references
Inserting and deleting ranges, rows, and columns

Using Excel 2007 functions
Entering functions
AutoSum
Other useful functions

Formatting Excel 2007 worksheets
Formatting text
Formatting rows and columns
Formatting numbers
Conditional formatting
Copying formats and applying table formats

Printing Excel documents
Preparing to print
Page Setup options
Printing worksheets

Creating Excel 2007 charts
Chart basics
Modifying charts
Printing charts

Managing large Excel workbooks
Viewing large worksheets
Printing large worksheets
Using multiple worksheets

Using multiple worksheets and workbooks
Using multiple workbooks
Linking worksheets with 3-D formulas
Linking Excel 2007 workbooks
Managing workbooks

Advanced Excel 2007 formatting
Using special number formats
Using functions to format text
Working with styles
Working with themes
Other advanced formatting

Outlining and subtotals
Outlining and consolidating Excel data
Creating subtotals

Excel 2007 cell and range names
Creating and using names
Managing names

Excel 2007 lists and tables
Examining lists
Sorting and filtering lists
Advanced filtering
Working with tables

Excel 2007 Web and Internet features
Saving workbooks as Web pages
Using hyperlinks
Distributing workbooks

Advanced Excel charting
Chart formatting options
Combination charts
Graphic elements

Documenting and auditing
Auditing features
Comments in cells and workbooks
Excel 2007 Protection
Workgroup collaboration

Templates and settings
Excel 2007 Application settings
Built-in templates
Creating and managing templates

Advanced Excel 2007 functions
Logical functions
Math and statistical functions
Financial functions
Displaying and printing formulas

Lookups and data tables
Using lookup functions
Using MATCH and INDEX
Creating data tables

Advanced list management
Validating cell entries
Exploring database functions
Excel 2007 PivotTables and PivotCharts
Working with PivotTables
Rearranging PivotTables
Formatting PivotTables
PivotCharts

Exporting and importing Excel
Exporting and importing text files
Exporting and importing XML data
Querying external databases

Excel 2007 Analytical options
Goal Seek and Solver
The Analysis ToolPak
Scenarios
Views

Macros and custom functions
Running and recording a Excel macro
Working with VBA 2007 code
Creating functions

Conditional formatting and SmartArt
Conditional formatting with graphics
Excel 2007 SmartArt graphics