Microsoft Excel : Intermediate
Overview and objectives
This one-day course is designed to help a delegate to develop skills in using Microsoft Excel as a spreadsheet tool. A delegate will learn to manage and link together multiple worksheets, create charts (graphs), apply more advanced formatting & work with databasis.
Course Prerequisite
Microsoft Excel : Introduction
Course Outline
| This course consists of 5 modules |
| Module One |
Charting
Creating Charts — Wizard
Sizing & Moving Charts
Modifying Charts
Chart Types
Adding & Deleting Data
Rearrange Chart Data
Inserting Text (Titles)
Data Labels & Legend
Gridlines
3D View
Line Charts
Transferring Chart Formats
Complex Charts
Creating Picture Charts |
| Module Two |
Databases
Creating a Database
Using a Data Form
Naming a Database
Format & Edit a Database
Sorting a Database
Numbers & Alphanumerics
Sorting in a Special Order
Multiple Sorts |
| Module Three |
Find & Edit with the Data Form
AutoFilter
Top Ten AutoFilter
Custom Filter (And/Or)
Exercises
Advanced Filter
Filter Unique Records Only (Duplicates) |
| Module Four |
Controlling Worksheet Display
Splitting of Panes
Freezing Panes
Validating Data
Separate / Parse
Transposing a Range
Copy a Sheet within a Workbook
Copy a Sheet between Workbooks
Moving Sheets
Documenting Workbooks (Notes / Comments)
Password Protection (Entire Workbook)
Password Protection (Cells)
Drawing / ClipArt |
| Module Five |
Linking
Linking — Copy / Paste Special
Linking — Pointing Method
Edit Links — Open Source
Edit Links — Change Source
Freezing Links
Linking Cell Pictures
Linking between Excel and Word
Consolidating
Reports & Subtotals
Nested Subtotals
Worksheet Outlining |
| Duration |
1 day |
| Cost |
R915,00 (excl. VAT) |
| Includes |
Comprehensive Manual
Lunch & Refreshments
Electronic Certificate (on successful completion of the course) Electronic Trainer Feedback Report
Electronic Delegate Feedback Questionnaire |
|
