Excel Module 1
Objective:
The objective of this session is to provide the new user with a short overview of the capabilities of Excel as well as presenting the knowledge required to begin using the program effectively. 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:
Overview of Microsoft Excel
The Screen /The Ribbon / File Tab / Quick Access Toolbar
Excel Options Menu
Screen Tips / Using HELP /Excel Shortcuts
Overview of the Spreadsheet / Cell Addresses
Cursor Movement / GoTo / Excel Navigator
Selecting Methods
Data Types / Data Entry / Editing
Text / Numbers
Cut / Copy / Paste / Paste Special Functions /Quick Functions etc
Relative / Absolute Cell Addresses
Copying between Sheets / Files
Creating / Importing / Using Customs Lists
= Functions
SUM / AVERAGE / MIN / MAX / COUNT
Formatting Cells / Worksheet
Text / Numeric / Dates etc / Special / Alignment Options / Fonts / Borders / Patterns
Using Conditional Formatting / Using the Format Painter
File Handling
Using Save / Save As – Directories / Drives / File Type.
Print and Print Options
Changing the Set Up / Print Area
Headers and Footers / Page Break Preview / Orientation Print Preview /
QUESTIONS AND ANSWERS
Special Features and Facilities:
The course is devoted to