Class Schedule for June – September 2021
| Course Name | Course Description | Date/s | Public Live Class | Virtual Live Class |
|---|---|---|---|---|
| Access Level 1 | What is a database/create a simple database? | June 18, July 7, Sept 13 | $325 |
$275 |
| Access Level 2 | Know the basics but want to know more about design and create | June 25, July 21, Sept 30 | $325 |
$275 |
| Access Level 3 | Advanced reports, macros, forms | June 7, Aug 23 | $325 |
$275 |
| Excel Level 1 | Add, subtract, multiply, divide, ribbon, freeze/hide panes | June 9, July 6, Aug 10, Sept 14 | $225 |
$175 |
| Excel Level 2 | Sort/filter, adv formulas functions, IF V lookup | June 16, July 23, Aug 18, Sept 22 | $225 |
$175 |
| Excel Level 3 | Solver, goal seek, macros, simple intro to Pivot Tables | June 23, July 29, Aug 30, Sept 29 | $175 |
|
| Excel Pivot Tables | Full day on just pivot tables and pivot charts | June 21, Aug 26, Sept 16 | $275 |
|
| Excel Dashboard | Track key KPI and metrics for business decisions; This one-day course concentrates on the principals of Dashboards. To create clients own Dashboards, one to one/2nd day training can be arranged. | June 4, July 13, Sept 20 | $175 |
|
| Excel Data list Management | Use Excel as a database (limitation on # of records, if large, suggest Access) | June 15, July 27, Aug 19, Sept 27 | $175 |
|
| Excel Power BI *** |
Business analytics (must have add-on BI product installed) | June 22-23, Aug 13-14, Sept 28-29 | $350/day |
|
| Excel PowerPivot & Power Query | Familiar interface for repetitive data collection and detailed transactions | June 28, July 15, Aug 31, Sept 24 | $275 |
|
| Programming & Data Wrangling with VBA & Excel *** |
Code/automate tasks involving the collection, processing, analysis, and visualization of data | June 16-18, July 28-30, Sept 20-22 | $350/day |
|
| Office 365 | Intro to O365 and online apps | July 20, Sept 1 | $225 |
$175/day |
| OneNote Complete | Create and collect electronic notes | June 29, Aug 17, Sept 9 | $225 |
$175 |
| Outlook | Custom Training (One-to-One); 1/2 Day using Zoom |
$275 |
||
| PowerPoint Complete | From start to automating slides | June 29, July 8, Aug 4 | $225 |
$175 |
| Power of PowerPoint | Public speaking/polished presentations | June 14, July 26, Sept 15 | $275 |
|
| Publisher Complete | Create cards, newsletters, certificates | June 14, Aug 12, Sept 21 | $225 |
$175 |
| Project Level 1 | Casic features/functions Level 2 required for full understanding of program | June 21, Aug 16, Sept 13 | $275 |
|
| Project Level 2 | Advanced functions, constraints, timelines, closing project | June 28, Aug 27, Sept 30 | $275 |
|
| SharePoint Site USER 2016, 2019, 0365 Server or Cloud *** |
Document management, storage, & versioning. How to create lists, views & custom columns | June 8, Aug 24, Sept 10 | $350 |
|
| SharePoint Site OWNER 2016 – 2019 Server *** |
Needs to manage creation of site & all its parts. Create site pages, web parts/apps & handle permissions other users & groups. | June 11, Aug 31, Sept 23 | $350 |
|
| SharePoint Site OWNER O365 Classic or Modern *** |
Tools known as web parts & apps to create/store docs, lists, use content management to control content types & use workflows to enhance processes | June 29-30, Aug 17-18, Sept 15-16 | $350/day |
|
| Teams | Communication app, customize | June 24, July 19, Sept 2 | $225 |
$175 |
| Visio Level 1 | Workflow, charts, diagrams | July 14, Aug 11 | $225 |
$175 |
| Visio Level 2 | Advanced shapes, stencil, diagrams | July 29, Aug 25 | $225 |
$175 |
| Word Level 1 | Intro, format, bullets, paragraphs, print | June 7, July 9, Aug 5, Sept 8 | $225 |
$175 |
| Word Level 2 | Advanced formatting, charts, headers/footers, mail merge | June 17, July 22, Aug 20, Sept 17 | $175 |
|
| Word Level 3 | Large docs, tables of contents, macros, interactive forms | June 30, July 28, Aug 30, Sept 23 | $175 |
Notes:
- Concept Training: Price includes a Quick Reference Card and a Keyboard Shortcuts Card
- *** include electronic manuals
- All virtual training done using Zoom