Class Types
One-on-One Training
Our primary focus is on person-to-person training – one student, one instructor. Classes can run for a full day or a half day as required.Classroom Training
We also do training for groups, at a price that's cheaper per
person than getting one-on-one training. Call us for more
details and a breakdown of pricing at 289-838-8096.Software we teach
We offer training to people looking to learn more about any of the major Microsoft Office components: Word, Excel, PowerPoint, and Access. Outlook, Project, and general internet training are also available. Our instructors know all versions of these programs from 2000 to 2007.What we cover
When you sign up for a course, we always discuss with you the topics that you can cover, and you'll be able to customize the agenda to your heart's content. However, we've often found that peoples' needs fall into several common categories:Word
Creating Longer Word Documents: Anyone can create a one-page letter in Word, but the simple techniques you use there don't work in anything more than two pages long. Does Word suddenly change the font on you when you add new lines to the bottom of the document? Do you find adding page numbers or creating numbered lists to be a complete nightmare? If so, it's because you're missing the longer document techniques. We can teach them to you, including how to set up page headers and footers, make tables of contents and indexes, and create long sets of form letters using the dreaded mail merge feature.Designing in Word: The documents you make aren't that long, but the page layouts are really complex. You need tables, charts, two columns of text on the same page, pictures, the word "CONFIDENTIAL" stamped in the background of each page...you name it. If by the time you're finished, you want something that looks like a professional brochure or magazine article, we have the topics for you.
Excel
Getting Up To Speed on Excel: This set of topics is aimed at beginner and self-taught Excel users and shows them how to make basic spreadsheets correctly: not only will they be able to do their work more quickly, they'll have the foundations to move on to all of Excel's more advanced features, such as data analysis and function formulas.Formulas in Excel: This group of topics is aimed at students who are comfortable making simple spreadsheets, and are now looking to move into the more sophisticated formulas and calculations they've seen in other peoples' work – either because they want to make some of their own, or they've been given spreadsheets created by other people who've since left the company and no-one can figure out how the formulas work. At the end of this training session not only will you have learned many of the most commonly used calculations, you'll have the skills to decipher any formula that someone throws at you no matter how strange.
Data Analysis in Excel: If you use Excel to track long lists of items – customer lists, product lists, or transactions and invoices, among others – this set of topics is for you. Excel provides a number of tools for working with these, from as simple as sorting the list without scrambling it to creating pivot tables. Students who learn these features can make large numbers of reports in just a few minutes, including ones based on all the information and others based on a quickly selected subset of it.
Making Spreadsheets for Others: You're getting pretty good at Excel now, and your co-workers and bosses are coming to rely on you to make Excel forms for them to fill in. This course focuses on techniques that reduce the amount of work you need to put in to these, both when creating the form and the inevitable "I have a quick question about how to..." factor once you've made it available for everyone to use.
Excel Macros (2-Day Course): Sometimes the kind of work you want to do is fairly simple, but your spreadsheets are so large that it takes forever for you to do it – you find yourself repeating the same actions over and over again. Or maybe you make spreadsheets for people to use and you find they have a hard time performing the correct actions because they don't know Excel nearly as well as you do. In both cases, a macro is probably the right solution: explain to Excel what you want done using its special VBA language, and it will do the work, either picking up the pace for you so it doesn't take so long to crunch through the list, or getting the computer to help the rookie Excel user through the trickier parts of the spreadsheet.
Access
Working with Access Databases: This course is for the beginner user, or someone who's not quite a beginner but has only been using Access a bit with a database someone else made. Even if you're not a full-fledged database designer, it's nice to be able to ask questions and make printouts beyond what was supplied to you. This course gets you familiar with the underlying concepts of any database, then walks you through the basics of making your own queries, forms, and reports. NOTE: This set of topics does not give you the information you need to make any but the simplest database from scratch. It is assumed that you already have a functioning database and that you want to know how to work with it more effectively.
Creating Access Databases (2-Day Course): "We need someone to make a database." Those could be the scariest words in the English language, and your boss just said them to you. In this course, you will learn how to map the real-world objects you want to track onto database tables, then create the input forms, reports for printing out, and queries that you need to manage all the information flowing in and out of the database. NOTE: This course assumes that you're already comfortable working with Access databases if they've already been created for you. The topics covered in the previous level, "Working with Access Databases" are a pre-requisite, though it's all right if you've taught them to yourself rather than being formally trained.