Summer Classroom Training Schedule
(all courses taught ONLINE using Microsoft Teams or Zoom)
All training courses are 1-day long (9am – approx 4pm)
| Click on the headings below for course topics | JUNE | JULY | AUG | SEPT |
| Microsoft Word 2016/2019/365 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) |
Fri
22 |
Wed
7 |
||
| Microsoft Word 2016/2019/365 course – Level 2 Section breaks (imperative in larger documents), using styles efficiently, columns, effective use of graphics, artistic effects options, advanced Quick Parts, watermarks, header/footer tips & tricks and template use. |
Fri
9 |
|||
| Microsoft Word 2016/2019/365 course – Level 3 Merges (letters, labels, email merges, troubleshooting), creating & editing basic and interactive macros. Feel the power! |
Wait list or group requests only | |||
| Microsoft Word 2016/2019/365 course – Level 4 Advanced Styles, Outline View, Templates (including input fields), Table of Contents, Index, Cross References, and amazing shortcuts. |
Wait list or group requests only | |||
| Microsoft Excel 2016/2019/365 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
13 |
Wed
13 |
Mon
15 |
Mon
12 |
| Microsoft Excel 2016/2019/365 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
15 |
Thurs
14 |
Thurs
18 |
Wed
14 |
| Excel 2016/2019/365 training – Level 3
Feel the power: pivot tables, vLookups, Data Validation, date and time calculations and an intro to macros |
Thurs
16 |
Thurs
15 |
||
| Excel 2016/2019/365 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! |
Thurs
21 |
Fri
23 |
||
| Microsoft Powerpoint 2016/2019/365
Slide types, effective slide shows, graphic tricks, slide transitions, custom animation options, tips & tricks. |
Mon
20 |
Thurs
8 |
||
| Microsoft Outlook 2016/2019/365
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
18 |
Thurs
29 |
||
| NEW! Microsoft Teams – HALF-DAY course Microsoft Teams is a collaboration app that helps your teams stay organized and have conversations – all in one place. It’s a hub for teamwork in Office 365. Keep all your team’s chats, meetings, files, and apps together in one place. It allows you to connect with colleagues, attend meetings and collaborate on projects. |
Upon Request for Private Group Training only | |||
| NEW! Microsoft FORMS – HALF-DAY course Forms allows you to create surveys, quizzes, and polls, and easily see results as they come in. With Microsoft Office 365, a user can create up to 200 forms – each containing up to 200 questions. Create Choice, Text, Rating, Date, Ranking, Likert and Net Promoter Score questions. Export results to Excel for fast and efficient analysis of results. |
Upon Request for Private Group Training only | |||
| NEW! Microsoft ONENOTE – HALF-DAY course This handy note-taking program helps you gather and reference your important notes – wherever you are. Multi-user collaboration – notes can be shared with other OneNote users over the Internet or a network. Divided into tabs and pages, this program helps keep you organized. Never misplace vital information again. |
Upon Request for Private Group Training only | |||
