This is live training, questions are answered in real time.

Course Descriptions

Excel 1 - 1 Hour Class

Tips, Tricks, and Shortcuts

This is the most requested course offered; it is designed to benefit users of all levels.  You use 5% of Excel 95% of the time, this course focuses on countless shortcuts that make the everyday tasks easier.  Students who are new to Excel will walk away with a great understanding of the everyday functions, while experienced users will be thrilled at the multitude of shortcuts that are covered.   Over 90% of the people who “skip” level one come back and take it.

Topics include:

Shortcut versions to:

  • Formatting

  • Creating formulas

  • Printing techniques

  • Working with multiple sheets

  • Creating charts

  • In-depth understanding of the fill feature

  • Protection

Prerequisite:  None

 

Excel 2- 1 Hour Class

Excel 1 focuses on Excel as a calculator, Excel 2 focuses on Excel as a Database.  It is working with lists of information. Note that remotely Pivot Tables are not covered in this class, they are covered in their own session.

Topics include:

  • Sorting

  • Filtering

  • Conditional Formatting

  • Subtotals

  • Absolute reference

  • Sum, Min, Max, Count, Average, Counta Functions

Prerequisite:  Excel 1 or equivalent knowledge

 

Excel 3- 1 Hour Class

Pivot Tables

This class focuses entirely on Pivot Tables.  It is the most important feature of Excel. 

Topics include:

  • Creating pivot tables

  • Pivot table calculations

  • Working with percent’s

  • Customizing pivot tables

  • Slicer

  • Pivot table charts

Prerequisite: Excel 1 and 2 or equivalent knowledge

 

Excel 4 - 1 Hour Class

Excel 4 takes your Excel skills from good to great!  The topics sound complex but they are very easy to master!

Topics include:

  • Macros

  • Creating your own buttons on the toolbar

  • Hyperlinks

  • Auditing

  • Sparklines

  • Advanced protection

  • Validation

  • Macros

Perquisite:  Excel 1, Excel 2 and Excel 3 or equivalent knowledge

 

Excel 5- 1 Hour Class

In this class we do function after function!

Topics include:

  • If (basic, nested, and’s and or’s)

  • Vlookups nested with other functions

  • Xlookup (New in Office 365)

  • Roundup, Rounddown

  • Iferror

  • Concatenate

  • Rank

Prerequisite:  Excel 1, Excel 2 and Excel 3 or equivalent knowledge

 

Charting- 1 Hour Class

This is a course covers the most important aspects of charting from shortcuts to advanced techniques.  It is designed to teach people how to create and interpret various chart types.  Whether you create charts in Excel or PowerPoint this one is for you!

Topics include:

  • Column Charts

  • Pie Charts

  • Line Charts

  • Overlay Charts

  • Multiple Axis Charts

  • Linking Charts into PowerPoint

Prerequisite: None

 

PowerPoint 1- 1 Hour Class

PowerPoint is a fun class that can easily be mastered.  PowerPoint is awesome for both business and personal presentations. No program may be as important as Excel, but nothing impresses like PowerPoint!

Topics include:

  • Layouts

  • Designs

  • Animation

  • Transition

  • Tricks for running shows

  • Shortcuts for presentation design and implementation

Prerequisite:  None

 
PowerPoint 2- 1 Hour Class

The fun goes on!  This takes PowerPoint to the next level. 

Topics include:

  • Incorporating music into presentations

  • Advanced Animation

  • Advanced layout design

  • Advanced transitions

  • Charting from blank slides

  • Speaker Notes

  • Administrative functions

Prerequisite:  PowerPoint 1 or equivalent knowledge

 

Word 1- 1 Hour Class

Every user can benefit from this class regardless of his user level. This class is full of shortcuts and tips for everyday documents. If we could make one course mandatory this would be it for everyone.

Topics Include:

  • Creating letter

  • Formatting shortcuts

  • Tables

  • Page Numbers (including dealing with covers)

  • Grammar Functions

  • Incorporating Excel

Perquisite:  None

 
Word 2- 1 Hour Class

This course covers working with large documents and mastering the Word topics beyond the everyday letter writing.

Topics Include:

  • Styles

  • Templates

  • Forms

  • Mail Merge

Perquisite:  Word One or equivalent knowledge

 

Outlook- 1 Hour Class

This class covers the untapped features of Outlook.  Outlook is so much more than “Send” and “Reply”. This course focuses on countless e-mail features and Tasks Feature.

Topics Include:

  • Email Options including voting buttons and flags

  • Quick Steps

  • Defaults

  • Groups

  • Stationary

  • Incorporating Publisher into Outlook

  • Assigning and tracking Tasks

Perquisite:  None

 

OneNote- 1 Hour Class

OneNote the electronic unbound note pad that is on everyone’s computer!  Gone are the days of binders and notebooks.  In this class you learn how to work the features of OneNote and incorporate your Outlook, Word & Excel files.  This class will bring your organizational skills to a whole new level.  It is a tough topic to teach yourself but extremely easy once you are shown what the features are and how to use them.  It just takes one class to get great at

OneNote!

Prerequisite:  None 

Excel Breakfast Club – (5) 1 Hour Sessions

Over 5 morning coffees you can become proficient in Excel!  This is live training, questions are encouraged!  Each session is 1 hour from 9:30AM-10:30AM Eastern Time on October 5th, 12th, 19th, 26th and November 2nd.  

 Day 1 focuses on countless shortcuts that make the everyday tasks easier.  

Topics include:

Shortcut versions to:

  • Formatting

  • Creating formulas

  • Printing techniques

  • Working with multiple sheets

  • Creating charts

  • In-depth understanding of the fill feature

  • Protection

Day 2 focuses on Excel as a database.

Topics include:

  • Sorting

  • Filtering

  • Conditional Formatting

  • Subtotals

  • Absolute reference

  • Sum, Min, Max, Count, Average, Counta Functions

Day 3 is the most important.  This session focuses entirely on Pivot Tables.  It is the most important feature of Excel. 

Topics include:

  • Creating pivot tables

  • Pivot table calculations

  • Working with percent’s

  • Customizing pivot tables

  • Slicer

  • Pivot table charts

 Day 4 this is the day we take your skills from good to great! The topics sound complex but they

are easy to master!

Topics include:

  • Macros

  • Creating your own buttons on the toolbar

  • Hyperlinks

  • Auditing

  • Sparklines

  • Advanced protection

  • Validation

Day 5 in this last session we unction after function!

Topics include:

  • If

  • Vlookups 

  • Xlookup (New in Office 365)

  • Roundup, Rounddown

  • Iferror

  • Concatenate

  • Rank

Access - 2 hour class

Excel is the biggest, best calculator in the world, but it is a calculator. Access is a database; it is much easier to master then Excel.   The rule of thumb on this is if you are crunching numbers you want to be in Excel, if you are analyzing lists of information you want to be in Access.  This is a 2-hour class.

Topics include:

  • Tables

  • Queries

  • Forms

  • Reports

  • Combo boxes

  • Flat and relational databases

  • Bringing in information from Excel or other programs

Prerequisite:  None