Microsoft Excel Advanced

MICROSOFT EXCEL ADVANCED

MS Excel the popular spreadsheet from Microsoft, designed specifically for the office environment. This 2 day course is designed to give users an understanding of some of the more advanced features and functions within Excel and the advantages of using a powerful electronic spreadsheet. The course is entirely 'hands on', so those attending will get practice in using advanced features of Excel to manage, automate and customise workbooks.

Custom Formatting

Formatting Numbers; Using Custom Formats

Custom Number/Date Format Codes

Using Conditional Formats

Working with Named Ranges

Creating Range Names

Using the Go To Command

Range Names in Calculations

Importing and Exporting Data

Using Paste Special

Object Linking and Embedding

Sharing Data with Other Applications

Importing a Text File into Excel

Templates and Add-Ins

Creating Workbook Templates

Custom Templates; Storing Templates

The Default Template

Working with Multiple Workbooks

Creating Custom Views; Creating a Workspace File

Using Workspace Files; Linking Workbooks

Creating Formulae to Link Data

Hyperlinks

Creating Hyperlinks

Data Validation

Setting-up Data Validation

Printing Workbooks

Printing Multiple Worksheets

Printing Multiple Workbooks

Lookup and Reference Functions

Using the VLOOKUP Function

Using the HLOOKUP Function

Preventing LOOKUP Errors

Using Macros

Recording a Basic Macro

Running a Macro

Editing a Macro

Pivot Table & Charts

Creating/ Editing/ Printing Pivot Tables & Charts

Tracing errors

Tramlines

Return to menu