Virtual Class Topics

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

Top


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

Top


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

Top


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

Top


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

Top


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

Top


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

Top


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

Top


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

Top


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

Top


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

Top

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

Top


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

Top

search previous next tag category expand menu location phone mail time cart zoom edit close