New Logo White mail

Microsoft Excel

Advanced

This course is for experienced users of Excel who wish to explore some of the more specialist formula, list and formatting tools Excel has to offer.

Objectives

Formulas and Functions

  • Revision of the If function

  • Nested Ifs

  • Using the And & Or functions

  • Naming ranges for use in formulas

  • Retrieving data using vLookup

 

Advanced Formatting

  • Creating new cell styles

  • Conditional formatting

 

Lists

  • Revision of sort & AutoFilter

  • Advanced filtering

 

Pivot Tables

  • Creating & manipulating a pivot table

  • Refreshing a pivot table

  • Formatting a pivot table

 

Data Validation

  • Controlling data input & drop-down lists

  • Creating data input alerts & prompts

  • Checking validity of existing data

  • Circling invalid data

  • Clearing data validation

  • Protecting worksheets & workbooks

 

Data Tools

  • Grouping & outlining

  • Subtotals

  • Data consolidation

 

Macros

  • Recording a macro

  • Running a macro

  • Assigning the macro to a button

  • Editing a macro

  • Deleting a macro (& the button)

Previous knowledge of Excel is essential including the ability to construct formulas and basic functions.

Prerequisities

Content