This Microsoft Excel 2007 training course will show you how to use multiple worksheets and workbooks efficiently, working with more advanced formatting options including styles, themes, backgrounds, and watermarks. You will also learn how to create outlines and subtotals, how to create and apply cell names, and how to work with lists and tables.

 

You will save workbooks as Web pages, insert and edit hyperlinks, and save a workbook as a PDF file. This course also covers advanced charting techniques, worksheet auditing and protection, file sharing and merging, and workbook templates.

Next Microsoft Excel 2007/10 Intermediate Open Training Course
26/01/2012

Limited Places-Book Now -
Call 0161 408 0435
Or
Book Online

 

Course contents

Using multiple worksheets & workbooks
Using multiple workbooks
Linking worksheets with 3-D formulas
Linking workbooks
Managing workbooks 

Advanced 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 data
Creating subtotals 

Cell and range names
Creating and using names
Managing names 

Lists and tables
Examining lists
Sorting and filtering lists
Advanced filtering
Working with tables 

Web and Internet features
Saving workbooks as Web pages
Using hyperlinks
 

Advanced charting
Chart formatting options
Combination charts
Graphic elements 
 

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

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