We provide training on your everyday tools to help you be more efficient and productive.
Conquering MS Excel: Basic to Intermediate
(16 hours)
Getting to know the MS Excel interface
- How to format spreadsheets
- How to print and modify spreadsheets
- How to create, copy and correct formulas
- Functions (samples, not limited to):
- Time and Date (Today, Now, ...)
- Math (Round, Product, Sumif, ...)
- Statistical (Count, Max, Min, ...
- Lookup (Vlookup, Hlookup,...)
- Logical (And, Or, If,...)
- Text (Left, Right, Upper, ...)
- Bonus:
- PivotTable & PivotCharts
Conquering MS Excel: Intermediate to Advanced
(16 hours, this is a separate program)
Pre-requisite: working knowledge of creating/using/formatting spreadsheets, functions, and formulas; or our Basic to Intermediate course.
(16 hours, this is a separate program)
Pre-requisite: working knowledge of creating/using/formatting spreadsheets, functions, and formulas; or our Basic to Intermediate course.
- Sorting and Filtering
- Advanced Filtering
- Data Tools
- Text to columns
- Flash Fill
- Remove Duplicates
- Data Validation
- Consolidate
- Additional Functions
- Creating multiple drop-down dependent lists
- Outline group
- Subtotals
- PivotTables and PivotCharts
- Excel Dashboard (sample output: https://youtu.be/gE9bViv6yCA)
Rediscovering MS Word: Basic to Intermediate
(12 hours)
(12 hours)
- Getting to know the MS Word interface
- Formatting texts and paragraphs
- Formatting pages
- Using Styles
- Tables and Illustrations / Graphics
- Headers and Footers
- Text Objects
- Collaborate using Track Changes
- Mail Merge
Exploring MS PowerPoint: Basic to Intermediate
(16 hours)
(16 hours)
- Getting to know the MS PowerPoint interface
- Editing Texts & Objects in Slides
- Notes and Guides
- Time to Present!
- Slide Designs
- Slide Animation
- Slide, Handout & Notes Masters
- Using elements to embellish slides
- Design Tips
Training sessions and rates
* With additional premium rate for exclusive classes with less than 10 pax.*
* For onsite training facilitation, please send us a message through any of our contact details below *
* For onsite training facilitation, please send us a message through any of our contact details below *
Let's THAWC w/ Karen Keeler
