We offer private, on-site training for your organization and can customize the content for your specific needs.
Suggested class time for each level:
Two 3-1/2 hour sessions, with a week between classes for practice
Microsoft Excel™ for Business Professionals
Excel Basics & Refresher
This is a great class for beginners and folks who are self-taught and could use a refresher. You will begin by exploring the Excel program window. Then you will enter and edit data, select cells and ranges, print worksheets, create formulas and functions, format cell contents, change the appearance of spreadsheets, use Find/Replace, Autocorrect and chart worksheet data. Please email us if you'd like a copy of the syllabus.
Excel Intermediate: Formulas, Functions & Worksheet Management
Level 2 is for users who are proficient with the basics of Excel. Learn how to use conditional formatting, name cells and ranges and use them in formulas, manage multiple worksheets, sort data, link cells and formulas, move and copy between workbooks, use advanced functions, perform data analysis, create templates and insert pictures. Please email us if you'd like a copy of the syllabus.
Excel Advanced Functions, Analysis Tools, Pivot Tables & Macros
In this advanced Excel class, you will work with PivotTables & PivotCharts, create basic macros to automate routine tasks, group and consolidate data, use data validation and error checking, protect your data, use comments, and explore options for sharing data and integrating Excel with other programs. Please email us if you'd like a copy of the syllabus.
Microsoft PowerPoint™ for Business Professionals
PowerPoint™ - Quick-Start
In this class you will learn to navigate through the PowerPoint interface. You'll create your own slide show, add bulleted lists and use document themes. By the end of the first lesson, you will deliver a presentation! Next, you will work with design concepts: copying text and objects, setting character spacing and rearranging slides. Finally you'll link to Excel data, create a chart, add graphics, insert transitions, animation and sound to give your presentations more punch and excitement. Basic Microsoft Office experience will be required. Please email us if you'd like a copy of the syllabus.
PowerPoint™ - Beyond the Basics
Take PowerPoint to the next level and create high-impact visual aids. You'll discover time-saving tips, work with tables and slide masters, customize document themes, color schemes and handouts, and use advanced techniques for adding multimedia content and running your slide shows. "Before & After" examples show how good design and motion can highlight your key points and increase the success of your business presentations. Microsoft PowerPoint QuickStart or equivalent experience will be required. Please email us if you'd like a copy of the syllabus.