On Demand Classes

Be more effective, efficient, and have more fun working with computers with our software training classes. Sign up for our virtual classes, access our on demand classes, or get your team setup for onsite training courses from KJ Consulting & Training.

 View All Training

Microsoft Access

Microsoft Access 2013, 2010 Basics

Are you new to Access 2013? Want a review? This class is for you! This class gives you a thorough & practical overview of Access. We will review tables, queries, forms and reports. We will create tables and discuss relationships. We will learn the basics of queries and much more! The class will be done in 2013 but 2010 users could take it too.

Watch Now

 Time: 60 Minutes

 Manual Included

Microsoft Access 2013, 2010 Queries

This is a great follow up class to the basics class. We learn the basics of creating and understanding queries, single table and multiple table. We work with criteria and other features of a query. We also introduce Action Queries.

Watch Now

 Time: 60 Minutes

 Manual Included

Microsoft Excel

Microsoft Excel 2016 Essentials Part 1

Are you new to Excel 2016? Do you need a class that start at the VERY beginning of Excel. This class is for you! This class gives you a thorough & practical starting point for Excel. You will review the ribbons, menus, edit and enter data, printing, headers and footers, sort & filter, copy & paste and more. The class will be done in 2016 but 2013 users would benefit too.

Watch Now

 Time: 60 Minutes

 Manual Included

Microsoft Excel 2016 Essentials Part 2

This class picks up where Essentials 1 leaves off. You will create simple formulas, learn the SUM function, learn to format text and numbers, work with column and row formatting, format rows and columns and more. The class will be done in 2016 but 2013 users could take it too.

Watch Now

 Time: 60 Minutes

 Manual Included

Microsoft Excel 2016/2013 Setting Up a Spreadsheet 101

Do you ever have problems trying to setup a spreadsheet from scratch? Learn from a pro, someone who has setup thousands of files. What’s the best way to setup a new spreadsheet. You’ve been asked to setup a file or track some new data. Where do you start? Take this class and learn some quick, surefire techniques for setting up a GREAT spreadsheet.

Watch Now

 Time: 60 Minutes

 Manual Included

Microsoft Excel 2016/2013 Functions and Formulas

Learn how to create the most common types of formulas. Learn tricks for using common functions like the SUM function. Learn easy, quick ways to create VLOOKUP, IF, AVERAGE, COUNT and many more. Great as a review class or for users new to functions and formulas.

Watch Now

 Time: 60 Minutes

 Manual Included

Microsoft Excel 2016: Comparing and Referencing Data with VLOOKUP and INDEX/MATCH Functions

Learn how and when to use the VLOOKUP Function, learn how and when to use the INDEX/MATCH Function. Learn the pros and cons of both. Use our simple methods for easily using these functions with our proprietary steps and tips.

Watch Now

 Time: 60 Minutes

 Manual Included

Microsoft Excel 2016, 2013 Pivot Tables Made Simple

Do you ever have problems trying to setup a spreadsheet from scratch? Learn from a pro, someone who has setup thousands of files. What’s the best way to setup a new spreadsheet. You’ve been asked to setup a file or track some new data. Where do you start? Take this class and learn some quick, surefire techniques for setting up a GREAT spreadsheet.

Watch Now

 Time: 60 Minutes

 Manual Included

Microsoft Excel 2016, 2013 Working with CSV & TXT Files

Ever wonder what Excel features are best for working with data you get from other programs? There are some great, little known features that will save you tons of time working with TXT and CSV files. Join us and learn some great formulas and shortcuts.

Watch Now

 Time: 60 Minutes

 Manual Included

Microsoft Excel 2016, 2013, 2010 How to Create AWESOME Charts

Have you seen awesome charts and wondered how to create them without spending all day? This class is for you! Learn to create simple, yet captivating charts in a matter of minutes. What makes a chart easy to read. Use Chart Styles. Learn tricks for preparing your data for a chart.

Watch Now

 Time: 60 Minutes

 Manual Included

Microsoft Excel 2016, 2013, 2010 Macros Made Easy

Have you always wanted to create a macro in Excel? Take this 1 hour class to see how to easily create a macro in Excel to save you time. This class is for users that have never created a macro or have very minimal exposure. It will cover when to create macros. It will also cover how to create simple macros.

Watch Now

 Time: 60 Minutes

 Manual Included

Microsoft OneNote

Why YOU NEED to Start Using Microsoft OneNote 2013

Have you wondered about OneNote? It’s a great digital note taking application most people don’t know how to use. Learn how to use this program to save you time. See why others can’t live without it in this 1 hour class.

Watch Now

 Time: 60 Minutes

 Manual Included

Use Microsoft OneNote 2013 Like a Pro!

If you already use OneNote but want to know more, this class is for you! We will explore tips and tricks in OneNote 2013. We will dig into the more advanced features of OneNote. We will explore audio/video notes, links, sharing, screen captures and more. Take 60 minutes and improve your productivity and go beyond the basics of OneNote.

Watch Now

 Time: 60 Minutes

 Manual Included

Microsoft Outlook

Discover the Secrets to Microsoft Outlook 2013

Want to tame your inbox? Automate formatting? Learn best practices for filing. Best ways to work with multiple calendars. Shortcuts and tricks to save you time? Sign up for this great class which is guaranteed to improve productivity.

Watch Now

 Time: 60 Minutes

 Manual Included

Microsoft PowerPoint

Secrets to Microsoft PowerPoint 2013

Do you create PowerPoint presentations? Need tips and tricks for saving time? Ever have problems inserting YOUTUBE movies? Want to learn how to use the Slide Master. Better ways to send presentations? Save time editing presentations? Find out our Top 15 secrets. This class is for you!

Watch Now

 Time: 60 Minutes

 Manual Included

Microsoft Sway

Microsoft Sway 2013: Why You Need It

Discover the program Sway 2013 – a Fun, Fresh, New Way to share information. Get ideas on how you can use it to prepare interactive reports, newsletters, presentations and work projects. In this 1 hour class, learn what SWAY is and how you can use it. Learn how to get started creating a new, basic SWAY. See some samples.

Watch Now

 Time: 60 Minutes

 Manual Included

Microsoft Word

Microsoft Word 2013, 2010 Formatting Like a Pro

Take this class to learn to format like a pro. Learn tricks for quick and easy formatting. Learn tricks for working with styles, images, tables and much more.

Watch Now

 Time: 60 Minutes

 Manual Included

Microsoft Word 2016, 2013, 2010 Secrets from a Help Desk Pro

Learn the best features in Word you wish you had known. These features save you tons of time. Let a Help Desk professional tell you all the things you wish you would have known. It doesn’t matter if you have used Word for 1 year or 20 years. These are tips and tricks we’ve discovered over our years of helping users that MOST users don’t know.

Watch Now

 Time: 60 Minutes

 Manual Included

Microsoft Word 2016, 2013, 2010 Secrets to Using Track Changes and Reviewer Features

Take this class to uncover the secrets to utilize and master the Track Changes, Comments and Reviewer features. Wonder when to accept changes? What the document looks like to other users? How to finalize the document?

Watch Now

 Time: 60 Minutes

 Manual Included

Microsoft Word 2016, 2013, 2010 Secrets to Using Mail Merge

Mail merge is feature most Word users have used in some capacity but did you know you could create an EMAIL merge? Send mass emails individually addressed with unique content. Also – did you know you could format the numbers in a mail merge differently than the data source? Learn some of the options for customizing your mail merge.Mail merge is feature most Word users have used in some capacity but did you know you could create an EMAIL merge? Send mass emails individually addressed with unique content. Also – did you know you could format the numbers in a mail merge differently than the data source? Learn some of the options for customizing your mail merge.

Watch Now

 Time: 60 Minutes

 Manual Included