Microsoft Office Classes

Click class titles to see dates and details

Microsoft Excel combines powerful spreadsheet, chart and list-management capabilities to form the industry-standard spreadsheet application. Here are the Excel 2016 for Windows classes we offer:

Excel Beginning 1: Your First Worksheets

Three hours, $119
- Introduction to Excel
- Making and Editing Entries
- Managing Cells and Worksheets
- Printing Worksheets

Excel Beginning 2: Simple Formulas

Three hours, $149
- Using Simple Functions
- Arithmetic Formulas
- Math with Dates
- Copying Formulas
- Relative vs Absolute Referencing

Excel Intermediate 1: Cell Formatting and Charting

Three hours, $149
- Formatting Cells
- Using Cell Styles
- Creating Charts
- Enhancing Charts

Excel Intermediate 2: Queries, Subtotals & Tables

Three hours, $149
- Writing Queries to Import Data
- Summarizing Data with Subtotals
- Using Data in Tables

Excel PivotTables: Data Analysis with PivotTables

Three hours, $179
- Creating PivotTables
- Analyzing data using PivotTables
- Working with PivotTable options
- Creating PivotCharts

Excel Advanced 1: Automating Tasks

Three hours, $195
- Working on Multiple Sheets Simultaneously
- Performing "What If" Analysis
- Conditional Formatting
- Recording Macros

Excel Advanced 2: Advanced Formulas

Three hours, $195
- Advanced Formulas using Functions
- Array Formulas
- Troubleshooting Formulas

Excel VBA Macros: Write Custom Excel Macros in VBA

Two days, $895
- VBA Concepts
- Accessing VBA Functionality
- Editing Macros
- Debugging Macros
- Assigning Macros
- Using Variables
- Loop Structures
- Code to Move the Cell Pointer and Select Ranges
- User-Interactive Worksheets
- VBA Decision Structures
- Methods to Manipulate Worksheets
- Using Built-in VBA Functions
- Performing Calculations

Microsoft Excel combines powerful spreadsheet, chart and list-management capabilities to form the industry-standard spreadsheet application. Here are the Excel 2016 for Mac classes we offer:

Excel (Mac) Basics: Your First Worksheets

Three hours, $119
- Introduction to Excel
- Making and Editing Entries
- Managing Cells and Worksheets
- Printing Worksheets

Excel (Mac) Intermediate: Cell Formatting and Charts

Three hours, $149
- Formatting Cells
- Using Cell Styles
- Creating Charts
- Enhancing Charts

Microsoft Word is the industry-standard word processing application for people in every field. Its text editing capabilities, which facilitate strong writing, combined with its first-rate formatting features, create a powerful document creation tool. Here are the Word 2016 for Windows classes we offer:

Word Beginning: Your First Document

Three hours, $119
- Getting Around in Word
- Typing and Editing Text
- Formatting Characters
- Preparing to Print a Document

Word Intermediate 1: Tabs, Indents, Graphics and Proofing

Three hours, $149
- Formatting Paragraphs
- Proofing and Improving Text
- Adding Graphics to Documents

Word Intermediate 2: Format with Style Sheets

Three hours, $149
- Using Style Sheets
- Section Formatting
- Automating Text Entry

Word Advanced 1: Track Changes, Tables & Mail Merge

Three hours, $195
- Tracking Changes
- Creating and Using Tables
- Mail Merge

Word Advanced 2: Produce Long Documents

Three hours, $195
- Assembling a Long Document
- Footnotes and Cross-References
- Cover Pages and Reference Tables
- Index and Bibliography

Microsoft PowerPoint makes it quick and easy to create, update and present attention-grabbing slide shows. Use professionally designed templates, powerful slide masters and easy-to-use SmartArt graphics and charts to build compelling presentations. Here are the PowerPoint 2016 for Windows classes we offer:

PowerPoint Beginning: Create Presentations Efficiently

Three hours, $119
- Getting Around
- Creating Slides
- Introduction to Masters
- Running a Slide Show

PowerPoint Intermediate: Illustrate Your Presentations

Three hours, $149
- Using Slide Masters
- Adding Graphics to Slides
- Building SmartArt Graphics and Charts
- Advanced Slide Show Settings

PowerPoint Advanced: Animate Your Presentations

Three hours, $195
- Animating Bullet Text
- Animating Graphics and Charts
- Creating Motion Path Animation

Microsoft PowerPoint makes it quick and easy to create, update and present attention-grabbing slide shows. Use professionally designed templates, powerful slide masters and easy-to-use SmartArt graphics and charts to build compelling presentations. Here are the PowerPoint 2016 for Mac classes we offer:

PowerPoint (Mac) Beginning: Create Effective Presentations

Three hours, $119
- Getting Around
- Creating Presentations
- Customizing Slide Masters
- Running a Slide Show

PowerPoint (Mac) Intermediate: Illustrate Your Presentations

Three hours, $149
- Adding Graphics to Slides
- SmartArt Graphics
- Drawing AutoShapes
- Creating charts
- Advanced Slide Show Techniques

PowerPoint (Mac) Advanced: Animate Your Presentations

Three hours, $195
- Animating Bullet Text
- Animating Graphics and Charts
- Creating Motion Path Animation
- Applying Slide Transitions

Microsoft Outlook combines tools for managing e-mail, contacts, calendar and to-do lists into a well-integrated personal information manager. Here are the Outlook 2016 for Windows classes we offer:

Outlook: Organize Your Mail, Schedule, Contacts and Tasks

Three hours, $119
- Managing E-Mails
- Managing Your Schedule
- Storing Contacts
- Tracking Tasks

Microsoft Access is a sophisticated, multi-user database development tool for building databases to share over the network or publish on the Web. Here are the Access 2016 for Windows classes we offer:

Access Beginning: Create Your First Database

Three hours, $149
- Getting Started with Access
- Creating a Simple Access Database
- Working with Table Data

Access Intermediate: Filter, Sort and Query Data

Three hours, $149
- Filtering Records
- Querying Records
- Creating Simple Forms and Reports

Access Advanced: Formulas, Forms and Reports

One day, $349
- Writing Formulas
- Building Forms
- Designing Reports

Microsoft Project is an essential tool for project managers or people who organize and orchestrate the many tasks and resources involved in a project. Here are the Project 2013 classes we offer:

Project Session 1: Create a Project Plan

Three hours, $149
- Getting Started with Microsoft Project
- Managing Tasks in a Project
- Managing Resources

Project Session 2: Fine-tune a Project Plan

Three hours, $149
- Assigning Resources to Tasks
- Adjusting Tasks
- Tracking Progress

Project Session 3: Manage and Customize Project Plans

Three hours, $179
- Exchanging Project Plan Data with Other Applications
- Updating a Project Plan
- Managing Project Costs

Project Session 4: Report and Reuse Project Plans

Three hours, $179
- Reporting Project Data Visually
- Reusing Project Plan Information
- Advanced Lab/Workshop

Visio Professional takes diagramming to a new level with dynamic, data-driven visualization tools and templates and advanced sharing through the Web. Bring the big-picture and real-time data from multiple sources, including Excel, Microsoft SQL Server, and SharePoint lists, together in one powerful diagram. Then see real-time changes to data right within your diagram, displayed through vibrant graphics such as icons, colors and data bars. Using SharePoint integration, you can now easily share your diagrams in real time with anyone, even those who don't own Visio. Here are the Visio 2013 classes we offer:

Visio Pro Session 1: Design and Manage Basic Diagrams

Three hours, $195
- Getting Started with Visio
- Creating a Simple Diagram
- Modifying Diagram Shapes

Visio Pro Session 2: Create Process Diagrams and Org Charts

Three hours, $195
- Creating Process Diagrams
- Representing an Organization Hierarchy
- Background and Foreground Pages