Winter 2019/2020 Classroom Training Schedule
All training courses are 1-day long (9am – approx 4pm)
| Click on the headings below for course topics | NOV | DEC | JAN | FEB | MARCH |
| Microsoft Word 2016 course – Level 1 (CORE) Do NOT skip this level. Even pros learn tons here! Tricks & shortcuts that you should have already been using (but haven’t). Custom tabs, indenting, file management, tables, spacing issues. Click here to see if you have the skills to skip this level (quiz) |
THURS
21 |
THURS
6 |
|||
| Microsoft Word 2016 course – Level 2 Section breaks (imperative in larger documents), using styles efficiently, columns, dealing effectively with graphics, artistic effects options, advanced Quick Parts, watermarks, header/footer tips & tricks, template use. |
MON
2 |
FRI
7 |
|||
| Microsoft Word 2016 course – Level 3 Merges (letters, labels, email merges, troubleshooting), creating & editing basic and interactive macros. Feel the power! |
TUES
17 |
||||
| Microsoft Word 2016 course – Level 4 Advanced Styles, Outline View, Templates (including input fields), Table of Contents, Index, Cross References, amazing shortcuts. |
WED
26 |
||||
| Microsoft Excel 2016 training – Level 1 (CORE) Our most popular course. Skip it – regret it! Have a solid foundation is key to producing efficient, well-though out spreadsheets. Tons of tricks & shortcuts that you should have already been using (but haven’t). Equations, FILL options & tricks, headers/footers, conditional formatting, printing tricks. Don’t skip this course – it’s got all the shortcuts and tricks in it! Click here to see if you have the skills to skip this level (quiz) |
MON
11 |
FULL
MON 9 |
MON
13 |
MON
10 |
WED
18 |
| Microsoft Excel 2016 course – Level 2 A busy day: all three levels of intermediate IF functions, saving time & energy with Range Names, data analysis (CountIF, SumIF, AverageIF, SubTotals), Text-to-Columns and more. Click here to see if you have the skills to skip Level 2 (quiz) |
TUES
12 |
FULL
TUES 10 |
TUES
14 |
TUES
11 |
THURS
19 |
| Excel 2016 training – Level 3
Feel the power: pivot tables, vLookups, Data Validation, date and time calculations, intro to macros |
FRI
15 |
THURS
16 |
WED
12 |
FRI
20 |
|
| Excel 2016 training – Level 4
Intermediate macros (variables, looping (via user input and conditions), do while), MATCH, RANK, Data Validation – Dependent List, Dynamic Dependent Lists. Geeky fun! |
MON
24 |
||||
| Microsoft Powerpoint 2016
Slide types, effective slide shows, graphic tricks, slide transitions, custom animation options, tips & tricks. |
FRI
6 |
FRI
17 |
THURS
27 |
MON
16 |
|
| Microsoft Outlook 2016
New & Improved! Are you getting the most out of this amazing information management program? Tips and tricks for E-mail, attachments, sharing calendars, delegating, scheduling, rules, sub folders and so much more. |
TUES
3 |
THURS
13 |
