Back to Search Results

Training Course Summary:

This 1 day course will extend delegates’ knowledge of Excel to gain a finer appreciation of its functionality. Delegates will be introduced to the power of functions, charting and techniques that make more efficient use of Excel. The course is suitable for anyone wishing to use the program more effectively and wanting to discover further capabilities of Excel.

Pre-Requisites:

Delegates should be familiar with Microsoft Windows and have a good understanding of Microsoft Excel; alternatively they may have attended The Basics course. Any delegate attending this course must be able to create formulae.

Training Course Overview/Content:

Revision Exercises:
Setting defaults, selecting data/text more effectively, moving around a worksheet, shortcuts, formulae creation, function – Min, Max, Average, Count, Counta

Functions:
LOWER, UPPER, PROPER, SUMIF, COUNTIF, CONCATENTATE, TRIM, RIGHT, LEFT, LEN

Formulas:
Absolute and relative cell referencing

Grouping:
Input data into grouped worksheets

Linking:
Linking multiple sheets, workbooks. Use workspace feature. Edit external links.

Templates:
Using templates as a base design of a workbook

Conditional Processing:
Using AND / OR Logic, Nesting IF Functions

Conditional Formatting:
Changing formatting according to results

Custom Lists:
Create Lists to save on repetitive typing

Analysing Data:
Sorting, custom sorting, filtering and reporting on the data using the subtotal feature

Printing Problems:
Using page setup, page break preview, row and column titles

Security:
Protecting data in cells, worksheets and workbooks. Password protection

Charting:
Charting concepts, formatting, adding or modifying data, legends, charting options, saving and printing, chart location