Fall 2020 Classroom Training Schedule (all courses taught ONLINE)

All training courses are 1-day long (9am – approx 4pm)

Click on the headings below for course topics SEPT OCT NOV DEC
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, and custom tabs, indenting, file management, tables, spacing issues.
Click here to see if you have the skills to skip this level (quiz)
Mon

16

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 and template use.
Tues

24

Microsoft Word 2016 course – Level 3
Merges (letters, labels, email merges, troubleshooting), creating & editing basic and interactive macros. Feel the power!
Wed

25

Microsoft Word 2016 course – Level 4
Advanced Styles, Outline View, Templates (including input fields), Table of Contents, Index, Cross References, and amazing shortcuts.
Mon

30

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. This course is full of tons of tricks & shortcuts that you should have already been using, but haven’t. Equations, FILL options & tricks, headers/footers, conditional formatting and 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

14

Mon

19

Wed

18

Mon

14

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)
Wed

16

Tues

20

Thurs

19

Excel 2016 training – Level 3

Feel the power: pivot tables, vLookups, Data Validation, date and time calculations and an intro to macros

Thurs

17

Wed

21

Fri

20

Excel 2016 training – Level 4

Intermediate macros (variables, looping (via user input and conditions), do while), MATCH, RANK, Data Validation – Dependent List and Dynamic Dependent Lists. Geeky fun!

Tues

15

Microsoft Powerpoint 2016

Slide types, effective slide shows, graphic tricks, slide transitions, custom animation options, tips & tricks.

Wed

28

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.

  Mon

23