Microsoft Training Courses

Analyzing data to find issues, insights, and opportunities is now a critical part of many job roles. Beyond the analysis, data analysts in all job roles must be able to effectively present and communicate their findings in visually compelling ways. Microsoft Excel is designed for this purpose. These capabilities enable people who use Excel for data analysis to turn data into thoughtful action. In this Excel Data Analysis and Visualization Training course, students will learn how to connect to a wide range of data sources, perform data analysis, create diverse and robust data-based visualizations to show insights and trends, and create reports.

In this Microsoft Access Advanced Training Course, students will learn advanced Microsoft Access skills such as how to secure and manage a database, how to design advanced forms and how to split an Access database for a multi-user environment, utilizing a front-end and back-end database. Students will also see how to use Macros in Microsoft Access to automate common tasks and will get an introduction to using VBA (Visual Basic for Applications) to take their automation skills to the next level. This class also covers how to secure an Access Database and prepares Access Power Users to be able to develop full-scale applications.

In this Microsoft Access Introduction Training course, you'll see how to use Access to create databases to store and manage data. This course assumes little to no previous experience with Microsoft Access, so you'll start with creating a database from scratch. You'll see how to properly plan and design your database so that it runs efficiently and can be easily modified in the future. You'll learn about all of the main Microsoft Access Objects: Tables, Forms, Queries and Reports and will see how to create basic and advanced versions of each. Throughout this course you will perform hands-on exercises to create and extend a database with multiple Tables, Queries, Forms and Reports and you'll come away with an understanding of the role of each of these objects in a full-blown Microsoft Access database application. If you've inherited a database from a former co-worker or are just struggling to create a database of your own, this course is essential in understanding how Microsoft Access works and how you can use it to create applications to automate your business in just a matter of hours or days.

In this Microsoft Access VBA Training course, students will learn how to use the VBA (Visual Basic for Applications) programming language to automate their database applications. They will learn about creating Sub Procedures and Functions and see how to call these blocks of code from an event occurring in Microsoft Access, such as a button being clicked or a user saving a record. Students will be introduced to the Microsoft Access Object Model, which will allow them to control all aspects of the application, including things like closing or opening forms, printing reports or validating user data entry. Students will also be introduced to accessing data in the database through code by using Data Access Objects (DAO,) allowing the manipulation of data behind the scenes - with no user action needed. Finally, students will see how to debug their code and add error handling to ensure that unexpected errors don't force an application shutdown. Although a programming environment, VBA is fun and easy to learn - even for students who have no programming experience!

In this Microsoft Excel Advanced training course, students will learn how to use features in Excel to collaborate with colleagues, automate complex or repetitive tasks, and use conditional logic to construct and apply complex formulas and functions. Students will see how to create Links and External References to Worksheets and Workbooks, use Lookup functions like VLOOKUP and HLOOKUP, and watch and evaluate formulas to find and fix logic errors. Students will also learn how to protect worksheets and workbooks from inadvertent changes being made, apply data validation to ensure correct data is entered in the worksheet and will see how to use Macros to automate common tasks in Excel. Finally, students will learn about visualizing data using Sparklines and Maps and how to forecast data trends in Excel.

In this Microsoft Excel Intermediate Training class, students will learn how to build on their Excel skills by using named ranges in Excel, inserting Excel Functions such as IF and SUMIF, using comparison operators such as AND, OR and NOT and using Date Functions such as DATE and NOW. In addition, students will see how to manipulate text using Text Functions like UPPER, LOWER and CONCATENATE. Students will also learn about using Lists in Excel and sorting and filtering data in lists. Students will be exposed to Database functions such as DSUM and how to work with and format tables in Excel. Modifying and formatting Charts in Excel will also be explored in this course. And, finally, students will learn how to analyze date using PivotTables, PivotCharts, Timelines and Slicers.

In this Microsoft Excel Introduction Training course, students will learn how to create worksheets in Microsoft Excel, how to use formulas and perform calculations, how to format cells and worksheets, how to setup worksheets for printing and how to export data from Excel to various other formats, including PDF. This course assumes no prior experience with Excel and is a great starting point for those who are new to the program or for those who may have some familiarity but want to take their knowledge further.

Power Pivot is a powerful data exploration tool based on in-memory computing technologies that provides unmatched analytical performance to process billions of rows almost instantaneously. In this Microsoft Excel Power Pivot Training course, students will learn how to use Power Pivot to import and manipulate data, create Power Pivot reports, use DAX functions, create key performance indicators (KPI) and use slicers to enhance the visualization of data.

In this Microsoft Excel VBA Training course, students will learn to use VBA in Excel to create interactive worksheets and automate common worksheet tasks. Students will see how to generate VBA code from existing macros, gain an understanding of the different parts of the Visual Basic Editor, learn how code is organized in Projects, Modules and Procedures and become familiar using Objects, Properties and Methods in their code. In addition, this course teaches students how to debug their VBA code to find and fix logic errors, interact with the user using dialog boxes, control formatting of the worksheet using VBA code and how to automate the addition and deletion of workbooks. Finally, students will see how to perform calculations in code and use built-in functions in Excel in VBA to quickly calculate large amounts of data.

In this Microsoft Outlook Advanced Training course, you will use Outlooks advanced features to customize and manage your email communications, including using advanced features to organize emails, managing calendar settings and options, managing contact information, scheduling tasks, and managing Outlook archives and data file settings. You will: Insert objects in messages, and modify properties and global options. Organize, search, and manage messages. Protect your mailbox and manage its size. Use rules and Quick Steps to automate message management. Work with advanced calendar settings. Import and forward contacts. Assign delegate permissions and share Outlook items with others. Archive and back up Outlook items using data files.

In this Microsoft Outlook Introduction Training course, students will use Outlook to compose and manage their email communications, calendar, contacts, and tasks. Students will learn to navigate Outlook to read and respond to email. Use the Address Book and format and spell check new messages. Attach files and insert illustrations to messages. Customize read and response options. Use flags, categories, and folders to organize messages. Create and work with Contacts. Create appointments and schedule meetings in Calendar and create and work with Tasks and Notes.

In this Microsoft PowerPoint Advanced Training course, students will take their existing PowerPoint skills, and presentations, to the next level. They'll learn how to customize design templates, add tables and charts to their presentations, work with multimedia, build advanced slide transitions and animations, collaborate with others on a presentation, and secure and distribute a presentation.

In this Microsoft PowerPoint Introduction Training course, you will learn how to create and deliver an engaging PowerPoint presentation. You will: Identify the basic features and functions of PowerPoint. Develop a PowerPoint presentation. Perform text formatting. Add and arrange graphical elements. Modify graphical elements and prepare to deliver your presentation.

This Microsoft Project training course is designed to show students how to use Microsoft Project to effectively manage projects. The course covers the critical knowledge and skills a project manager, or other individual tasked with managing projects, needs to create a project plan with Microsoft Project and shows students how to utilize Microsoft Project to oversee the planning, execution, monitoring, and controlling phases of their projects. This course will enable students to utilize Microsoft Project to manage projects so that they are completed on time, within budget, and according to scope.

Students will learn how Microsoft Project calculates their project schedule using a project start or end date, task relationships, resource availability and project calendars. Students will also see how to use various views in Microsoft Project, including the Gantt chart view, to analyze the project progress. This course also shows students how to share the project plan with others who may not have Microsoft Project installed and how to create a Project template to speed the creation of future projects.

Microsoft SharePoint, together with the Microsoft 365 suite, provides a robust platform for building and managing a corporate intranet. It enables organizations to centralize content, streamline collaboration, and maintain consistent information governance. This course is designed for experienced SharePoint site owners who are ready to advance into deeper site‑building and administrative capabilities. You will learn how to create custom site templates, configure managed metadata, build and apply content types, manage permissions, and strengthen site‑level and tenant‑level security. By the end of the course, you will be equipped to extend SharePoint’s capabilities, improve information structure and discoverability, and support governance and compliance across your environment.

This course gives SharePoint site owners the practical skills needed to confidently manage and customize modern SharePoint Online sites. Participants learn how to configure site settings, manage lists and libraries, control access, build pages, and support team collaboration using Microsoft 365 tools. Through hands‑on activities, learners practice creating and organizing content, applying modern site features, and ensuring their sites are structured, secure, and easy for users to navigate. By the end of the course, students will be able to maintain a functional, well‑organized SharePoint site that supports their team’s daily work.

This course introduces everyday SharePoint users to the essential skills needed to work confidently within modern SharePoint Online sites. Participants learn how to navigate sites, access and manage content, collaborate with team members, and use core features such as lists, libraries, views, sharing, and search. Through hands‑on practice, learners gain the ability to upload, organize, edit, and share information while understanding how SharePoint fits into the broader Microsoft 365 ecosystem. By the end of the course, students will be able to use SharePoint effectively as a central hub for team communication and content management.

In this Microsoft Word Advanced Training course, students will learn how to use images in a document, create custom graphic elements for use in their documents, collaborate with others in creating and editing documents, add reference marks and notes to documents, secure sensitive documents, create forms in Microsoft Word documents and use macros to automate common tasks. This course also helps prepare students interested in the Microsoft Office Specialist Program for the Word Associate (Office 365 and Office 2019): Exam MO-100 and Word Expert (Office 365 and Office 2019): Exam MO-101 certification exams.

In this Microsoft Word Intermediate Training course, students will learn how to organize content using tables and charts, customize formats using styles and themes, insert content using Quick Parts, use templates to automate document formatting, manage long documents and use mail merge to create letters, envelopes and labels. This course also helps prepare students interested in the Microsoft Office Specialist Program for the Word Associate (Office 365 and Office 2019): Exam MO-100 and Word Expert (Office 365 and Office 2019): Exam MO-101 certification exams.

In this Microsoft Word Introduction Training course, you'll learn how to use Word on the desktop to create and edit simple documents, format documents, add tables and lists, add design elements and layout options, and proof documents. This course also helps prepare students interested in the Microsoft Office Specialist Program for the Word Associate (Office 365 and Office 2019): Exam MO-100 and Word Expert (Office 365 and Office 2019): Exam MO-101 certification exams.

SharePoint Online is a powerful platform used by organizations to manage content, support collaboration, and create centralized hubs for communication. Without the right training, however, it can feel overwhelming. This course gives you the practical skills needed to confidently build, organize, and manage SharePoint Online sites. Through hands‑on labs, real‑world scenarios, and guided instruction, you’ll learn how to create site structures, manage lists and libraries, build pages, automate processes, and configure permissions. By the end of the course, you’ll be able to turn SharePoint into a productive, user‑friendly workspace for your team or department.

Using AI with Excel is a hands‑on, scenario‑driven course that teaches professionals how to use freely available generative AI tools—such as ChatGPT, Gemini, and Microsoft Copilot—to enhance productivity, solve spreadsheet‑related problems, and accelerate data‑driven decision‑making. Learners discover how to generate spreadsheet content, automate tasks, troubleshoot formulas, clean and structure data, and strategically apply AI to real business challenges. The course blends conceptual understanding with practical exercises using Microsoft Excel.

Note: Students in this class will create ChatGPT, Gemini and/or Copilot accounts if they don't already have one. Access to a valid email and cell phone in order to complete authentication during setup will be needed to participate in hands-on exercises.

Generative AI tools such as Copilot, Gemini, and ChatGPT make it faster and easier to plan, write, and enhance business presentations. This course shows professionals how to use AI to brainstorm topics, generate slide text, create images, and develop presenter notes and handouts. Learners practice prompting techniques, refine AI‑generated content for clarity and professionalism, and import structured outlines directly into PowerPoint. They also explore how to use AI‑assisted web search to strengthen presentations with supporting facts and examples. By the end of the course, participants will have a streamlined workflow for using free AI tools to create polished, engaging presentations with greater speed and confidence.

Note: Students in this class will create ChatGPT, Gemini and/or Copilot accounts if they don't already have one. Access to a valid email and cell phone in order to complete authentication during setup will be needed to participate in hands-on exercises.