Microsoft Excel : Intermediate

Course details

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 databases.

Course Outline 

Module 1

• 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 2

• Find & Edit with the Data Form;
• AutoFilter;
• Top Ten AutoFilter;
• Custom Filter (And/Or);
• Exercises;
• Advanced Filter;
• Filter Unique Records Only (Duplicates)

Module 3

• Text Functions, Date & Time Functions; 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

Module 4

• 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 5

• 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