Live, online, virtual classes taught by Microsoft Certified Trainers (MCT) and Microsoft Office Specialist (MOS) Experts
If you have a group of people that are in need of training, please reach out to us for customized training solutions, designed to fit your needs.
Sample Training Topics
Sample 3-Hour topic combination blocks below
- Excel Worksheet Formatting, Printing and Customizing the Layout
- Working with Advanced Excel Formulas and Functions, Using Data Tables and Charts
- Analyzing Data With Excel PivotTables, Slicers and PivotCharts, Using Graphics, Creating Templates and Protecting Files
- Using Excel Macros, Validating Data, and Auditing Formulas
- Using Excel Sparklines, Scenarios and What-If Analysis, Consolidating & Merging Workbooks, 3D Links to Other Workbooks and Exporting Data
Let us help you customize your class!
Microsoft Excel Basics 2016/2019/365
Microsoft Excel Basics
This class will introduce you to the important basic aspects of Excel. By the end of this course, users will be comfortable creating a new spreadsheet, working with basic formulas, cutting, copying and pasting labels, values and formulas, formatting a spreadsheet to look professional and presentable, and saving and printing a spreadsheet.
Please bring your questions to class. The virtual class will be hosted live by a Microsoft Certified Instructor.
What You’ll Learn:
LESSON 1: GETTING STARTED • Identify the Elements of the Excel Interface • Create a Basic Worksheet • Use the Help System
LESSON 2: PERFORMING CALCULATIONS • Create Formulas in a Worksheet • Insert Functions in a Worksheet • Reuse Formulas
LESSON 3: MODIFYING A WORKSHEET • Manipulate Data • Insert, Manipulate, and Delete Cells, Columns, and Rows • Search for and Replace Data • Spell Check a Worksheet
LESSON 4: FORMATTING A WORKSHEET • Modify Fonts • Add Borders and Color to Cells • Apply Number Formats • Align Cell Contents • Apply Cell Styles
LESSON 5: PRINTING WORKBOOK • Define the Basic Page Layout for a Workbook • Refine the Page Layout and Apply Print Options
LESSON 6: MANAGING LARGE WORKBOOKS • Format Worksheet Tabs • Manage Worksheets • Manage the View of Worksheets and Workbook
Microsoft Excel Intermediate 2016/2019/365
Intermediate Microsoft Excel
This course is intended to help all users get up to speed on the different features of Excel and to become familiar with its more advanced selection of features. We will cover how to create and use advanced formulas, analyze data, organize worksheet data with tables, visualize data with charts, insert graphics, and enhance workbooks.
Please bring your questions to class. The virtual class will be hosted live by a Microsoft Certified Trainer.
What You’ll Learn:
LESSON 1: CREATING ADVANCED FORMULAS • Use Range Names in Formulas, Use Specialized Functions
LESSON 2: ANALYZING DATA WITH FUNCTIONS • Use Text Functions, Use Logical Functions, Use Lookup Functions, Use Date Functions, Use Financial Functions
LESSON 3: ORGANIZING DATA WITH TABLES • Create and Modify Tables, Sort and Filter Data, Use Subtotal and Database Functions to Calculate Data
LESSON 4: VISUALIZING DATA WITH CHARTS • Create Charts, Modify and Format Charts, Create a Trendline, Create Advanced Charts
LESSON 5: ANALYZING DATA WITH PIVOTTABLES, SLICERS, AND PIVOTCHARTS • Create a PivotTable, Filter Data by Using Slicers, Analyze Data with PivotCharts
LESSON 6: INSERTING GRAPHICS • Insert and Modify Graphic Objects, Layer and Group Graphic Objects, Incorporate SmartArt
LESSON 7: ENHANCING WORKBOOKS • Customize Workbooks, Manage Themes, Create and Use Templates, Protect Files, Preparing a Workbook for Multiple Audiences
Advanced Microsoft Excel 2016/2019/365
Advanced Microsoft Excel
This course is intended to help all users get up to speed on the different aspects of Excel, including some of its more advanced features. We will cover how to automate worksheet functionality, audit worksheets, analyze data, work with multiple workbooks, export Excel data, as well as import and export XML data.
Please bring your questions to class. The virtual class will be hosted live by a Microsoft Certified Trainer.
What You’ll Learn:
LESSON 1: AUTOMATING WORKSHEET FUNCTIONALITY • Update Workbook Properties, Create and Edit a Macro, Apply Conditional Formatting, Add Data Validation Criteria
LESSON 2: AUDITING WORKSHEETS • Trace Cells, Troubleshoot Invalid Data and Formula Errors, Watch and Evaluate Formulas, Create a Data List Outline
LESSON 3: ANALYZING AND PRESENTING DATA • Create Sparklines, Create Scenarios, Perform a What-If Analysis, Create Interactive Data with Power View
LESSON 4: WORKING WITH MULTIPLE WORKBOOKS • Consolidate Data, Link Cells in Different Workbooks, Merge Workbooks
LESSON 5: EXPORTING EXCEL DATA • Export Excel Data, Import a Delimited Text File
Microsoft Outlook Basics 2016/2019/365
Microsoft Outlook Basics
This course is intended to help all novice computer users get up to speed with Outlook quickly. By the end of this course, users should be comfortable with using and customizing the Outlook interface, creating and sending messages, managing contacts, using the calendar, managing tasks, and working with notes.
Please bring your questions to class. The virtual class will be hosted live by a Microsoft Certified Trainer.
What You’ll Learn:
LESSON 1: GETTING STARTED WITH OUTLOOK • Navigate the Outlook Interface, Perform Basic E-mail Functions, Use Outlook Help
LESSON 2: COMPOSING MESSAGES TOPIC • Create an E-mail Message, Check Spelling and Grammar, Format Message Content, Attach Files and Items, Enhance an E-mail Message, Manage Automatic Message Content
LESSON 3: READING AND RESPONDING TO MESSAGES • Customize Reading Options, Work with Attachments, Manage Your Message Responses
LESSON 4: MANAGING YOUR MESSAGES • Manage Messages Using Tags, Flags, and Other Commands, Organize Messages Using Folders
LESSON 5: MANAGING YOUR CALENDAR • View the Calendar, Manage Appointments, Manage Meetings, Print Your Calendar
LESSON 6: MANAGING YOUR CONTACTS • Create and Update Contacts, View and Organize Contacts
LESSON 7: WORKING WITH TASKS AND NOTES • Create Tasks, Manage Tasks, Manage Notes
LESSON 8: CUSTOMIZING THE OUTLOOK ENVIRONMENT • Customize the Outlook Interface, Create and Manage Quick Steps
Microsoft PowerPoint Basics 2016/2019/365
Microsoft PowerPoint Basics
This course is intended to help all novice computer users get up to speed with PowerPoint quickly. By the end of this course, users should be comfortable with creating a new presentation, making their presentation look professional and presentable, and saving and presenting their slide show.
Please bring your questions to class. The virtual class will be hosted live by a Microsoft Certified Trainer.
What You’ll Learn:
LESSON 1: GETTING STARTED WITH POWERPOINT • Navigate the PowerPoint, Environment, Create and Save a PowerPoint Presentation, Use Help
LESSON 2: DEVELOPING A POWERPOINT PRESENTATION • Select a Presentation Type, Build a Presentation, Lay Out a Presentation, Edit Text, View and Navigate a Presentation
LESSON 3: PERFORMING ADVANCED TEXT EDITING • Format Characters, Format Paragraphs, Format Text Boxes
LESSON 4: ADDING GRAPHICAL ELEMENTS TO YOUR PRESENTATION • Insert Images, Insert Shapes, Insert WordArt
LESSON 5: MODIFYING OBJECTS IN YOUR PRESENTATION • Edit Objects, Format Objects, Group Objects, Arrange Objects, Animate Objects
LESSON 6: ADDING TABLES TO YOUR PRESENTATION • Create a Table, Format a Table, Insert a Table from Other Microsoft Office Applications
LESSON 7: ADDING CHARTS TO YOUR PRESENTATION • Create a Chart, Format a Chart, Manipulate a Chart, Insert a Chart from Microsoft Excel
LESSON 8: PREPARING TO DELIVER YOUR PRESENTATION • Review Your Presentation, Apply Transitions, Print Your Presentation, Deliver Your Presentation
Advanced Microsoft PowerPoint 2016/2019/365
Advanced Microsoft PowerPoint
This course is intended to help all users get up to speed on many of the different features found in PowerPoint and to become familiar with its more advanced selection of features. By the end of this course users should be comfortable with customizing the PowerPoint user interface, customizing design templates, implementing media and custom animations in a presentation, using collaboration tools, customizing slide shows in a number of different ways, as well as securing and distributing a presentation.
Please bring your questions to class. The virtual class will be hosted live by a Microsoft Certified Trainer.
What You’ll Learn:
LESSON 1: MODIFYING THE POWERPOINT ENVIRONMENT • Customize the User, Interface, Set PowerPoint 2016 Options
LESSON 2: CUSTOMIZING DESIGN TEMPLATES • Create and Manage Sections, Modify Slide Masters and Slide Layouts, Add Headers and Footers, Modify the Notes Master and the Handout Master
LESSON 3: ADDING SMARTART TO A PRESENTATION • Create SmartArt, Modify SmartArt
LESSON 4: WORKING WITH MEDIA AND ANIMATIONS • Add Audio to a Presentation, Add Video to a Presentation, Customize Animations and Transitions
LESSON 5: COLLABORATING ON A PRESENTATION • Add Comments to a Presentation, Review a Presentation, Store and Share Presentations on the Web
LESSON 6: CUSTOMIZING A SLIDE SHOW • Annotate a Presentation, Set Up a Slide Show, Create a Custom Slide Show, Add Hyperlinks and Action Buttons, Record a Presentation
LESSON 7: SECURING AND DISTRIBUTING A PRESENTATION • Secure a Presentation, Present a Slide Show Online, Create a Video or a CD
Microsoft Access Basics 2016/2019/365
Microsoft Access Basics
This class will introduce you to the important basic aspects of Microsoft Access. By the end of this course, users should be comfortable navigating the Access interface, creating a new database from scratch, querying a database, generating reports, sharing data, and much more.
Please bring your questions to class. The virtual class will be hosted live by a Microsoft Certified Trainer.
What You’ll Learn:
LESSON 1: GETTING STARTED WITH ACCESS • Orientation to Microsoft Access, Create a Simple Access Database, Get Help in Microsoft Access
LESSON 2: WORKING WITH TABLE DATA • Modify Table Data, Work with Records, Sort and Filter Records, Create Lookups
LESSON 3: QUERYING A DATABASE • Join Data from Different Tables in a Query, Sort and Filter Data in a Query, Perform Calculations in a Query
LESSON 4: CREATING ADVANCED QUERIES • Create Parameter Queries, Create Action Queries, Create Find Duplicate and Find Unmatched Queries, Summarize Data
LESSON 5: GENERATING REPORTS • Create a Report, Add Controls to a Report, Enhance the Appearance of a Report, Prepare a Report for Print
Microsoft Access Intermediate 2016/2019/365
Intermediate Microsoft Access
This course is intended to help all users get up to speed on the different features of Access and to become familiar with its more advanced features. We will cover how to complete advanced form design tasks, add field and record validation, create and manage macros, conduct advanced database management, distribute and secure a database, and manage switchboards.
Please bring your questions to class. The virtual class will be hosted live by a Microsoft Certified Trainer.
What You’ll Learn:
LESSON 1: IMPLEMENTING ADVANCED FORM DESIGN • Add Controls to Forms, Set Form Controls, Create Subforms, Organize Information with Tab Pages, Enhance Navigation with Forms, Format a Form, Apply Conditional Formatting
LESSON 2: USING DATA VALIDATION • Field Validation, Form and Record Validation
LESSON 3: USING MACROS TO IMPROVE USER INTERFACE DESIGN • Create a Macro, Restrict Records Using a Condition, Validate Data Using a Macro, Automate Data Entry Using a Macro, Convert a Macro to VBA
LESSON 4: USING ADVANCED DATABASE MANAGEMENT • Link Tables to External Data Sources, Manage a Database, Determine Object Dependency, Document a Database, Analyze the Performance of a Database
LESSON 5: DISTRIBUTING & SECURING A DATABASE • Split a Database for Multiple User Access, Implement Security, Set Passwords, Convert an Access Database to an ACCDE File, Package a Database with a Digital Signature
LESSON 6: MANAGING SWITCHBOARDS • Create a Database Switchboard, Modify a Database Switchboard, Set Startup Options
Microsoft OneNote 2016/2019/365
Microsoft OneNote
OneNote is Microsoft’s handy note-taking and organizational application. OneNote incorporates a refined page hierarchy, improved searching options, automatic links to pasted content, task integration with Outlook, and a variety of new sharing options to make working with others easier. By the end of this course, users should be comfortable creating a new OneNote notebook, customizing the interface, entering information into OneNote from a variety of sources, and using OneNote’s collaboration tools.
Please bring your questions to class. The virtual class will be hosted live by a Microsoft Certified Trainer.
What You’ll Learn:
LESSON 1: EXPLORING NOTEBOOK STRUCTURE • Navigate the OneNote 2016 Environment, Create a Notebook, Use Predesigned Templates for OneNote, Customize the User Interface
LESSON 2: ADDING CONTENT AND FORMATS TO A ONENOTE NOTEBOOK • Modify Formatting in a Notebook, Add Images to a Notebook, Add Tables to a Notebook, Add Audio and Video to a Notebook, Add Quick Notes and Links, Use Tags, Symbols, Drawing Tools, and Pen Options
LESSON 3: MANAGING ONENOTE NOTEBOOKS, HISTORY, AND BACKUPS • Save and Export Content and Use Alternate File Types, Manage Notebook Recycle Bins and Backups
LESSON 4: WORKING WITH EMBEDDED FILES • Work with Excel Spreadsheets and Visio Diagrams, Work with Embedded Files
LESSON 5: SHARING AND COLLABORATING WITH NOTEBOOKS • Send a Notebook and Use Outlook Integration, Share and Collaborate on Notebooks
LESSON 6: FINALIZING A NOTEBOOK • Finalize a Notebook Using Proofing and Print Settings, Configure Notebook Properties and Security, Search Notebooks
Microsoft Word Basics 2016/2019/365
Microsoft Word Basics
This course is intended to help all novice computer users get up to speed with Word quickly. We will cover different features of the interface, show users how to create a basic document, and introduce users to Word’s most important tools. By the end of this course, students should be comfortable with creating a new document, making it look professional and presentable, and saving their document. Students will also become familiar with using and customizing the Microsoft Word interface.
Please bring your questions to class. The virtual class will be hosted live by a Microsoft Certified Trainer.
What You’ll Learn:
LESSON 1: GETTING STARTED WITH WORD • Identify the Components of the Word Interface, Create a Word Document, Help
LESSON 2: EDITING A DOCUMENT • Navigate and Select Text, Modify Text, Find and Replace Text
LESSON 3: FORMATTING TEXT AND PARAGRAPHS • Apply Character Formatting, Align Text Using Tabs, Display Text as List Items, Control Paragraph Layout, Apply Borders and Shading, Apply Styles, Manage Formatting
LESSON 4: ADDING TABLES • Insert a Table, Modify a Table, Format a Table, Convert Text to a Table
LESSON 5: MANAGING LISTS • Sort a List, Renumber a List, Customize a List
LESSON 6: INSERTING GRAPHIC OBJECTS • Insert Symbols and Special Characters, Add Images to a Document
LESSON 7: CONTROLLING PAGE APPEARANCE • Apply a Page Border and Color, Add a Watermark, Add Headers and Footers, Control Page Layout
LESSON 8: PROOFING A DOCUMENT • Check Spelling and Grammar, Other Proofing Tools, Check Accessibility
LESSON 9: CUSTOMIZING THE WORD ENVIRONMENT • Customize the Word Interface, Additional Save Options, Manage Additional File Types
Microsoft Publisher Basics 2016/2019/365
Microsoft Publisher Basics
Publisher 2016 is Microsoft’s user friendly desktop publishing program that is designed to give individuals and small to medium-sized businesses the ability to quickly and easily create publications for both print and the web. This course is intended to help all novice computer users get up to speed with Publisher quickly. We will cover different features of the interface, show users how to create a publication, cover some basic publication tasks, discuss how to manage graphics in Publisher, and show how to prepare a publication for printing and electronic sharing. By the end of this course, users should be comfortable with creating a basic publication, adding content to a publication, formatting text, editing text, adding and formatting graphics, and preparing a publication for printing and/or sharing.
Please bring your questions to class. The virtual class will be hosted live by a Microsoft Certified Trainer.
What You’ll Learn:
LESSON 1: GETTING STARTED WITH MICROSOFT PUBLISHER 2016 • Explore the Interface, Customize the Publisher Interface, Create a Publication
LESSON 2: ADDING CONTENT TO A PUBLICATION • Add Text to a Publication, Organize Text Boxes and Picture Placeholders in a Layout, Control the Display of Content in Text Boxes, Use Building Blocks
LESSON 3: FORMATTING TEXT IN A PUBLICATION • Format Text and Paragraphs, Apply Paragraph Styles,
Paragraph Formatting, Apply Schemes
LESSON 4: EDITING TEXT IN A PUBLICATION • Edit Text in a Publication, Present Content in Tables, Insert Symbols and Special Characters
LESSON 5: ADDING AND FORMATTING GRAPHICS IN A PUBLICATION • Add Graphical Objects to a Publication, Manipulate the Appearance of Pictures
LESSON 6: PREPARING A PUBLICATION FOR PRINTING AND SHARING • Save a Publication, Run the Design Checker, Preview and Print a Publication, Share a Publication
Microsoft Visio 2016
Microsoft Visio Basics
Microsoft Visio, Microsoft’s diagramming application, has a set of pre-crafted starter diagrams that allow you to quickly create diagrams in 15 of the most popular categories. Other features include built-in Tell Me support, an expanded selection of shapes, quick import capability, and a suite of collaboration features. This course is intended to help all novice computer users get up to speed quickly with Microsoft Visio. We will cover different features of the interface, show users how to find help, explore some simple scenarios, and cover the basics of how to create diagrams. By the end of this course, users should be comfortable using Visio to create simple diagrams on a day-to-day basis and capable of creating organization charts, floor plans, cross-functional flowcharts, and network diagrams.
What You’ll Learn:
LESSON 1: GETTING STARTED WITH VISIO 2016 • Navigate the Visio Environment, Create a Basic Drawing, Use the Help System
LESSON 2: CREATING A WORKFLOW DIAGRAM • Use Drawing Components, Modify a Drawing, Work with Callouts and Groups
LESSON 3: CREATING AN ORGANIZATION CHART • Create a Basic Organization Chart, Do More with Organization Charts
LESSON 4: MAKING A FLOOR PLAN • Make a Basic Floor Plan, Model a Room Layout
LESSON 5: CREATING A CROSS-FUNCTIONAL FLOWCHART • Create a Cross-Functional Flowchart, Modify a Cross-functional Flowchart
LESSON 6: CREATING A NETWORK DIAGRAM • Create Network Diagrams, Use Shape Data, Use Layers
LESSON 7: STYLING A DIAGRAM• Work with Shape and Connector Styles, Work with Themes and Variants, Work with Containers
Instructor Bio
Leza Bissell Wood, Microsoft Certified Trainer (MCT), Microsoft Office Specialist (MOS) Expert
Leza Wood is a Microsoft Certified Trainer who specializes in using adult learning techniques to elevate the student experience. She is an accomplished professional capable of understanding business needs and addressing those needs with training solutions.
Leza is extremely skilled at quickly acquiring technical knowledge and transferring that knowledge in an effective manner, according to the student’s learning style and proficiency level. She can interpret complicated technical concepts and translate in an understandable fashion.
Leza’s area of expertise is in Microsoft 365 (Office 365) products. She teaches any level Word, Excel, Access, PowerPoint, Outlook, OneNote, Publisher, etc. and Introductory level Power BI.
Certifications
Microsoft Certified Trainer (MCT) since 2009
Modern Classroom Certified Trainer (MCCT) since 2020
Microsoft Office Specialist (MOS) Expert Excel 2013/2016/2019/365
Education
B.S. Business, Management and Economics, Concentration in Training and Development
Graduation: December 2014 • SUNY Empire State College, GPA 3.9
Compuhelp Online 