80
% of MS Office users, only know how to use 20% of the features!
MS Office
77
% of all jobs next year will require computer skills. Employees with advanced skills will be higher paid with more advancement opportunities.
Productivity Increase
11
% increase in open data base administartor positions by 2026
Database Administrators

Try One Of Our New Productivity “Crash Course” Training Classes 

Time is money as the old adage says and it is even more true today. Employers need productive employees and employees need honed skills to be competitive the marketplace.  This new series of productivity crash courses fit the bill.  There are plenty of online training options but lets be honest, it is much easier to have an instructor by your side to answer questions when you get stuck on a topic or just don’t understand it. Don’t take weeks to learn how to use the software – get results in 3 hours at an affordable price.

Code Vapor’s training classes are all scenario based. Learn the top features and apply them to real life situations.  These 3 hour classes get you up and running with step by step take home notes. Each situation starts with basic instructions, then a practice problem. Then another similar problem is given with a twist to see if you have learned the concept.  Each solution is outlined step-by-step for future reference.

The reason these classes are popular is because they make learning fun and rewarding

  • No boring lectures – a fun interactive, classroom setting with no more than 10 -12 students.
  • Hands on experience with everyone learning on a provided laptop.
  • Solution Based Learning – We teach you how use and understand the top features of the software.
  • Interactive learning utilizing demonstrations, online polling and short interactive quizzes.
  • Take home problem solutions handbook.

Find the Class That Fits You

We offer two productivity classes: Excel spreadsheets and Access databases. Both are extremely powerful software tools that if understood and utilized correctly, can really enhance productivity.

There are two levels of classes: Core and Intermediate.  It is important to be placed in the correct class so you will not be bored or overwhelmed.  Simply take the appropriate quiz below and the quiz will recommend what class to take (or not to take!)

 Take the Excel quiz to assess your spreadsheet knowledge!

Take the Access quiz to assess your database knowledge!

 Course: Excel 101- Core Concepts Crash Course

What You Will Learn In Our Hands On Training Lab:

We will create three projects that will teach all the fundamentals you need to build your own spreadsheets. You will learn the following concepts:

    • How spreadsheets works and why they are extremely useful. What not to use them for.
    • Creating calculations – understanding the math
    • Formatting and printing
    • Sorting and drop down selections
    • Exporting to Word and other applications

You will learn how to build three spreadsheets: Budget, Check Register and a To Do List.  You will confidently know how to build these spreadsheets through demonstrations, simple quizzes and repetition, proving that you can create them without assistance.

 Course: Excel 201- Intermediate Concepts Crash Course

What You Will Learn In Our Hands On Training Lab:

We will create three advanced projects that will add to your basic understanding of Excel. You will learn the following concepts:

    • Tables
    • Graphs and charts
    • Advanced formatting and printing
    • Advanced functions such as Lookup(), Index, Match , etc.
    • Data manipulation

You will learn how to build three spreadsheets: Calorie Counter, Store Inventory and a Mailing List.  You will confidently know how to build these spreadsheets through demonstrations, simple quizzes and repetition, proving that you can create them without assistance.

 Course: Access 101- Core Concepts Crash Course

What You Will Learn In Our Hands On Training Lab:

We will create one multi-form database using Microsoft Access. You will learn the following concepts:

    • What are tables and records – how to add, delete and edit
    • How to build a form
    • Formatting and input validation
    • Reporting

You will learn how to build a customer multi-page form.  You will confidently know how to build these spreadsheets through demonstrations, simple quizzes and testing that you can create them without asistance.

 Course: Access 201- Core Concepts Crash Course

What You Will Learn In Our Hands On Training Lab:

We will create one advanced multi-form database using Microsoft Access. You will learn the following concepts:

    • Linking multiple tables and understanding relationships
    • Error checking
    • Exporting data to other applications
    • Advanced Reporting

You will learn how to build an employee tracking database.  You will confidently know how to build these spreadsheets through demonstrations, simple quizzes and testing that you can create them without asistance.

Your Instructor For This Class

Allan Smith
Chief Technology Strategist, Code Vapor LLC

Mr. Smith has over 35 years experience in managing large IT departments across many business lines including healthcare, manufacturing and education. He has managed desktop and support center teams serving tens of thousands of PCs and users.

With his engineering degree and love for all things technology based, he loves to work with robotics, design smart homes and teach computer science classes.

Mr. Smith has a passion to help business’ and individuals to maximize their productivity by using popular software tools.  He has written complex Access databases and forms to manage many business functions and uses Excel daily to solve many business challenges.

Check out our other crash courses!

Knowledge is power!

Protect yourself against security hackers or learn to code.

Click on this link for more information