Excel Advanced

Excel / Advanced


Objective: To give users an extended knowledge of Excel’s advanced features and functions. Delegates will learn how to manage, automate and customise workbooks.

Delegates: Maximum 8

This course is suitable for existing users of Excel who want to gain further in-depth knowledge in a short space of time. Participants on this course should have a good working knowledge of Excel, gained from prior attendance on an “Excel Intermediate” course or from a user environment.

Delegate numbers are restricted to 8, to ensure personal attention from the trainer.

Structure: PC for every delegate

All pass training courses involve extensive hands-on activity including exercises that give participants practical experience of using Excel’s tools.

Duration: 1 day 9.30 am – 4.30 pm
Further Training: Excel Expert

Course Outline:

Excel Advanced
· Review Exercise

Custom Formatting
· Formatting Numbers; Using Custom Formats

· Custom Number Format Sections

· Custom Number Format Codes

· Custom Date Format Codes

· Formatting SpeedKeys; Using Conditional Formats

Importing and Exporting Data
· Using Paste Special

· Object Linking and Embedding

· Opening Text Files in Excel

· Importing a Text File into Excel

· Importing Data from Web Pages

Templates and Add-Ins
· Creating Workbook Templates

· Custom Templates; Storing Templates

· The Default Template

· Loading Add-In Programs

Working with Multiple Workbooks
· Creating Custom Views

· Creating a Workspace File

· Using Workspace Files

· Linking Workbooks

· Creating Formulae to Link Data

Printing Workbooks
· Printing Multiple Worksheets

· Printing Multiple Workbooks

Lookup and Reference Functions
· Using the LOOKUP Function

· Using the VLOOKUP Function

· Using the HLOOKUP Function

· Preventing LOOKUP Errors

Working with Named Ranges
· Creating Range Names

· Using the Go To Command

· Range Names in Calculations

Working with Toolbars
· Displaying Different Toolbars

· Creating a New Toolbar

Using Macros
· Understanding Macros

· Recording a Basic Macro

· Relative References

· Running a Macro

· Assigning a Macro to a Toolbar

· Button Image Editor

· Editing a Macro

· Macro Virus Protection

Fee : £220 + VAT