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.
Microsoft Access
Microsoft Access 2013, 2016 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.
Microsoft Access 2013, 2016 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.
Microsoft Excel
Microsoft Excel 2013, 2016 Essentials Part 1
Are you new to Excel 2013 or 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.
Microsoft Excel 2013, 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 2013 but 2016 users could take it too.
Microsoft Excel 2013, 2016 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.
Microsoft Excel 2013, 2016 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.
Microsoft Excel 2013, 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.
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.
Microsoft Excel 2013, 2016 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.
Microsoft Excel 2016, 2013 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.
Microsoft Excel 2016, 2013 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.
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.
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.
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. Learn to use only 5 folders for ALL your emails.
Microsoft PowerPoint
Microsoft PowerPoint 2013/2016: Essentials
Are you new to PowerPoint? This is a great class to brush up on basics or learn the nuts and bolts of PowerPoint. Lean to create new presentations, print presentations, use themes and best practices for formatting!
Secrets to Microsoft PowerPoint 2013/2016
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 secrets. This class is for you!
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.
Microsoft Visio
Microsoft Visio 2013: Intro
This is a great class for new users to Visio. It would also be good for users that have recently been upgraded to a newer version or maybe haven’t used it for a while. We will cover the basics of Microsoft Viso so you can get started creating an org chart or a workflow.
Microsoft Word
Microsoft Word 2013/2016 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.
Microsoft Word 2013/2016 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.
Microsoft Word 2013/2016 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?
Microsoft Word 2013/2016 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.