Christopher Duncan

The WOW! Factor in PowerPoint

Our second PowerPoint class starts with using images in your slideshow and includes professional graphic design techniques to be certain your images support your presentation, not distract from it. In addition to photographs and clipart, this course covers animations and transitions as well as sound and video. All of the Read more…

Building a Presentation in PowerPoint

You can tell if a presenter has strong PowerPoint training. Their slideshow will capture your attention, support their information, and add value to your time spent during the presentation. This class is great for beginners as well as old hands who want to brush up on the basics of creating Read more…

Beyond Email in Outlook

Microsoft Outlook subdivides its functions into Mail, Calendar, Tasks, Contacts, and Journal. Many attendees are unaware of how simple the program makes it to juggle a hectic schedule, assign work and keep up with what people are doing.  Organizing the Calendar Working with other People’s Calendars Scheduling Meetings To-Dos and Read more…

Electronic Notebooks in OneNote

Offices are swiftly moving to the electronic notebook, as a replacement for hand written legal pads and post-it notes. The ability to collect your thoughts on one device, review them on another, and then share them with colleagues is invaluable. Building Notebooks Juggling Multiple Notebooks Sharing features of OneNote Content Read more…

Macros in Excel

Long thought to be the province of supergeeks, macros will come alive in this exciting class. You will learn how to record macros, be introduced to the Visual Basic programming language, and write simple code statements The Developer tab on the Ribbon Recording Macros Playing back Macros with Keystrokes Adding Read more…

Data Analysis in Excel

Now that you’ve got all of that information, what are you going to do with it? Senior managers and entry-level personnel all benefit from taking this class, where you’ll learn the ins and outs of Pivot Tables and Charts, as well as how to import data from databases.  Creating Pivot Read more…

Visual Communication in Excel

Collecting data and storing it is just one part of the Microsoft Excel toolkit. In fact, all those columns of numbers wouldn’t be worth much if we couldn’t communicate them to other people. This class will explore the impressive array of tools built in to the program that will help Read more…

Formulas and Functions in Excel

Formulas and Functions are the meat and potatoes of Microsoft Excel. They are the tools that give the program power to achieve our goals. We’ll review the basics of Formulas and Functions in this class before diving headlong into more advanced Functions. This class also takes a look at special Read more…

Behind the Spreadsheet in Excel

Peek behind the spreadsheet and learn Microsoft Excel the right way. Because so many adult learners are self-taught, there are often basic skills that we fail to pick up. This class assumes you have opened the program but aren’t secure that you know all the basics.   Keyboard Shortcuts Creating Read more…

Modules and Macros in Access

Every good database designer needs a tool belt with lots of tricks, and Macros are the 5-star tool you need to automate repetitive tasks. You will be introduced to writing Macros using the Visual Basic Editor and learn how to use Temporary variables and constants, as well as how to Read more…

Reports in Access

Reports give you the ability to aggregate the data you are interested in and print it out in creative and professional looking documents. You will start with form letters, but quickly move to adding charts and graphs based on your data. You will also learn the tips and tricks to Read more…

Forms in Access

Access 2016 uses a special object type called Forms to represent data visually on screen. Forms are a great method to add exciting front-end user functionality to boring databases and offer ways to protect your data from well-intentioned mistakes. Starting with simple forms and the Forms Wizard, you will quickly Read more…

Queries in Access

Understanding Queries in Access 2016 begins with learning how to ask simple questions about your data, like “how many?” and “which ones?” As you explore topics like relationships and referential integrity, however, you’ll learn how to select, update and delete records using queries. This class will also introduce you to Read more…

Data and Tables in Access

Get started with Access 2016 by learning the fundamentals of database features. This class will explore how to use Access efficiently and introduce you to the concepts of good Relational Database design. It’s a maxim that all data is stored in Tables in Access, but not all Tables are equal. Read more…

Fillable Forms, Org Charts and Links

Tackling the “hard” topics of accessibility, this final class will put any employee over the goal line when it comes to creating accessible documents. No stone is left un-turned in problem solving involved documents. Form Prep Tools Fillable Forms and Screen Readers Creating Fillable PDFs Working with Links Converting Organization Read more…

In-Depth Look at Complex Tables

Tables are one of the most challenging aspects of making complex PDFs accessible to all audiences. This class will look in-depth at the methods of converting table heavy documents into easily accessible formats. Working with Tables in PDFs Simple Table Errors and How to Fix Complex Table Errors and How Read more…

Document Structure in Office and Acrobat

Moving published Word documents to PDF and addressing common issues that crop up. Published PDF -Accessibility Check Intro to Tags Panel Common Errors in and How to Fix Manual Checks Accessibility Report

Tables and Scanned Documents

Adding Tables and Structure an accessible Microsoft Word document using Office 365; plus reviewing the methods of creating a PDF from the Word document. This is part two of a two-part class on creating accessible Word documents. Table Formatting & Usage Table Content & Structure Moving to PDF Tools for Read more…

Simple Accessible Documents

Introduction to how to create an accessible Microsoft Word document using Office 365. This is part one of a two-part class on creating accessible Word documents. Document Properties Alt Text for Objects Null Alt Text What kinds of objects are repetitive? Content

Overview of Accessible Documents

Primarily a presentation meant to explain what accessibility is, what the rules are, and how the parts play together. Useful for newcomers and managers who need to understand what their staff are up against when making documents accessible. Accessibility in a Nutshell Who is Accessibility For? Accessibility Checkers File Formats Read more…