You can view this course outline as a PDF for printing

Unit 1: Using multiple worksheets and workbooks

Topic A: Using multiple workbooks

Topic B: Linking worksheets with 3-D formulas

Topic C: Linking workbooks

Topic D: Managing workbooks

Unit 2: Advanced formatting

Topic A: Using special number formats

Topic B: Using functions to format text

Topic C: Working with styles

Topic D: Working with themes

Topic E: Other advanced formatting

Unit 3: Outlining and subtotals

Topic A: Outlining and consolidating data

Topic B: Creating subtotals

Unit 4: Cell and range names

Topic A: Creating and using names

Topic B: Managing names

Unit 5: Lists and tables

Topic A: Examining lists

Topic B: Sorting and filtering lists

Topic C: Advanced filtering

Topic D: Working with tables

Unit 6: Web and Internet features

Topic A: Saving workbooks as Web pages

Topic B: Using hyperlinks

Topic C: Distributing workbooks

Unit 7: Advanced charting

Topic A: Chart formatting options

Topic B: Combination charts

Topic C: Graphic elements

Unit 8: Documenting and auditing

Topic A: Auditing features

Topic B: Comments in cells and workbooks

Topic C: Protection

Topic D: Workgroup collaboration

Unit 9: Templates and settings

Topic A: Application settings

Topic B: Built-in templates

Topic C: Creating and managing templates

If you would like to make an enquiry about our Training, fill in the form below, or call us on 0800 019 6882, or email us at sales@computertrainingsolutions.co.uk

First Name
Surname
Company Name
Phone
Email
City
Main Course Area of Interest	AccessDreamweaver ExcelGoogle AdWords IllustratorIndesign Not Listed/OtherOutlook PhotoshopPowerPoint ProjectPublisher Word
Query
Image Verification Please enter the text from the image [ Refresh Image ] [ What's This? ]