Microsoft Excel Training Programme

Overview 

Microsoft Excel is by far one of the most familiar application for most white collar workers in the world today.

It has become the de-facto calculator and ‘database’ in the work place, but most users are only vaguely familiar with the embedded power in the application.

DAY ONE

Module 1 - Working with Data
Handling different data types
Data Consistency
Building Datasheets
Sorting (Columns, Formatting), Rows, Conditional
Filtering
Data Cleaning & Removing duplicates & Multiples
Text-to-column
Grouping & Sub-totals
Data Validation

Module 2 - Formatting
Converting to Tables
Standard printing
Standard emailing
Review
Naming & Name Ranges

DAY TWO

Module 3 - Working with Charts
Line Charts/Graphs
Column Charts and uses
Bar Charts and uses
Pie Charts and uses/pitfalls
Charts combinations
Dynamic Charts, Using filters
Standard practices and Sparkline
Power-mapping & View

Module 4 - Pivot Table, Pivot Charts, PowerPoint
Default Pivot Table
Tabular Pivot Table
Pivot Table Filtering
Making Tables from Pivot Table
Pivot Chart and its Limitations
Pivot Chart

 
DAY THREE

Module 5 - Business Data Analysis
Linking Sheets
Duplicating Sheets
Inserting Sheets, Labeling & Coloring professionally
Freezing panes and Splitting Windows
Conditional formatting
Lookup functions
Some Keyboard Shortcuts

Module 6 - Excel to PowerPoint, and Ms Word
Linking PowerPoint Charts to Excel