Excel Module 2                                                                         

Objective:

The objective of this session is to provide the existing user with a more comprehensive overview of the capabilities of Excel As the session is primarily hands on it will be restricted to one user per computer system and is suitable for both the novice and the person who has dabbled with the software.

Topics:

Review of the Basics
Excel Navigator
Working with Ranges & Named Ranges / Name Manager
= Functions / Named Ranges in Formula
SUM / AVERAGE / MIN / MAX / COUNT / COUNTIF/ SUMIF
DATE & TIME FUNCTIONS / NOW()
IF STATEMENTS
Conditional Formatting
Adding Password Protection
Protecting the Sheet / Workbook
Working with Comments
Print and Print Options
Changing the Set Up / Print Area
Headers and Footers / Page Break Preview / Orientation Print Preview / Freezing Panes/ New Window
Working with Charts
Creating a Chart / Chart Types
Change Design / Layout / Colours / Format
Data Tables
Sorting and Filtering
Formula in Tables
Linking Worksheets / Files
3D Functions
QUESTIONS AND ANSWERS
Special Features and Facilities:
The course is devoted to practical use of the software and is therefore primarily hands-on. An absolute maximum of 1 student per machine will be maintained.   The session is fully documented, and each person attending will have access to our after training Help Desk

This specification can be tailored for those requiring onsite training