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!

If you're already fluent in Excel's day-to-day features, this course is where you start making Excel do the heavy lifting instead of you. It's built for experienced users who are ready to move past single-worksheet thinking: linking and consolidating data across multiple worksheets and workbooks, building lookup formulas that pull the right value out of a large dataset automatically, recording macros to eliminate repetitive manual work, and running what-if analysis and forecasts instead of guessing at trends by eye.

Professionals who are comfortable with Excel fundamentals often reach a plateau: they can enter data and build simple formulas, but still sort data manually, rebuild the same calculations from scratch each month, or struggle to identify a trend within a large dataset without scrolling through hundreds of rows. This course closes that gap, moving beyond basic data entry toward the intermediate functions and tools experienced Excel users rely on daily, applied to realistic business scenarios rather than abstract exercises.

This course is appropriate for professionals in any role who regularly work with data in Excel — including finance, operations, HR, marketing, and administrative professionals — who have completed introductory Excel training or have equivalent working experience.

If you've never opened Excel, or you've poked around in it without ever really learning it, this course is where that changes. The course moves in a deliberate sequence: get comfortable in the interface first, then build formulas and calculations, then format and organize a worksheet so it's actually readable, and finish with printing and exporting a finished file. Each stage builds directly on the one before it, so by the end of the day you're not just familiar with individual features — you can put together a complete, usable worksheet from a blank file.

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.

Many organizations collect data across multiple systems — spreadsheets, databases, CRMs, and cloud services — but lack an efficient way to bring it together into a single, clear view, resulting in disconnected reports and dashboards that are already outdated by the time they are presented. Microsoft Power BI is built specifically to solve this problem, and this course teaches professionals how to use it effectively, from first data connection to finished, shareable report.

This course is intended for professionals responsible for reporting, analysis, or business intelligence, including analysts, finance and operations professionals, and anyone currently relying on static spreadsheets for recurring reporting. No prior experience with Power BI is required.

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.

Managing a project with Microsoft Project only pays off if the plan behind it actually holds up once real work starts. This course covers both sides of that: building a solid project plan from scratch — tasks, task relationships, resources, and a realistic schedule — and then keeping that plan accurate once execution begins, tracking real progress, adjusting for delays, and reporting status without the whole schedule falling out of sync.

Students learn how Microsoft Project calculates a schedule from a start or end date, task relationships, resource availability, and project calendars, and how to use views like the Gantt chart to read that schedule at a glance. The course also covers sharing a plan with people who don't have Microsoft Project installed, and building a reusable template to speed up 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.