This is live training, questions are answered in real time

Each class is 1 hour

Course Descriptions

Excel 1 

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

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

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

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

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

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

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

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

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 Mail and Calendar

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

Topics Include:

  • Email Options including voting buttons and flags

  • Quick Steps

  • Defaults

  • Groups

  • Stationary

  • Incorporating Publisher into Outlook

  • Assigning and tracking Tasks

  • Scheduling meets and appointments

  • Tracking attendance

  • Categories

  • Recurring Meetings

  • Scheduling Teams Meetings

  • Prerequisite:  None

 

OneNote

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