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