AIM

To broaden participant's skills and knowledge of the more advanced features of Microsoft Excel.

WHO SHOULD ATTEND ?

Delegates who need to create complex spreadsheets & who have a basic understanding of Excel or have attended the Introductory course.

OBJECTIVES

By the end of the course, participants will be able to ;

 ·         Create complex spreadsheets using functions and formulae.

·         Summarise data using sub-totals & pivot tables.

·         Control entry in a spreadsheet (data validation).

·         Automate procedures using macros.

CONTENT

 During the course, delegates will cover the following topics:-

 -          Create / Use Formulae & Functions.

-          Understand IF / SUMIF / LOOKUP & Nested functions.

-          Use Scenario & View Managers.

-          Sorting Data & Calculating Sub-Totals.

-          Filtering Data – Creating Custom Filters.

-          Analyse / Summarise Data Using Pivot Tables.

-          Create & Format Charts.

-          Protect Worksheets / Workbooks.

-          Data Validation Functionality.

-          Create / Use & Modify Macros.

DURATION

1 Day