Learn how to use tables, pivot tables, and pivot charts to organize and analyze data more effectively. Explore ways to sort and filter data, create subtotals, and use VLOOKUP to find information within a table.

Take your Microsoft Copilot skills to the next level in this hands-on intermediate course. Build on the basics of prompting and explore more effective ways to use Copilot for communication, productivity, research, and everyday workplace tasks. Learn how to provide context and detailed instructions, refine and customize responses, analyze and organize information, and use Copilot to support more complex, multi-step tasks. Through demonstrations and guided activities, you’ll practice techniques for getting more accurate, useful, and tailored results while exploring how Copilot can work alongside Microsoft 365 tools. Prior experience with Copilot or completion of an introductory AI course is recommended.

Learn how to streamline repetitive document creation with Microsoft Word's Mail Merge feature. This course introduces the fundamentals of creating personalized letters, labels, envelopes, emails, and other documents by combining a Word document with data from sources such as Excel spreadsheets or contact lists. Through hands-on practice, participants will learn how to set up, customize, and complete mail merge projects efficiently and accurately.

Gain confidence in creating basic formulas and functions with relative and absolute references. Understand operator precedence and how it affects formulas. Learn about the different parts of a function and how to create arguments to calculate values and cell references. Excel includes common functions that can be used to quickly find the sum, average, count, maximum and minimum value for a range of cells

Develop your understanding of how Excel uses logic with functions like AND, OR, COUNTIF, IF, and Nested IF. Perform calculations with SUMIF, AVERAGEIF, OR COUNTIF when a specific condition is met. Use VLOOKUP and XLOOKUP to search for specific information in a table. Find out how to name cells and ranges, and then use them in formulas. Learn how to link cells within worksheets and workbooks, and how to create 3D formulas across worksheets and workbooks. Locate errors by utilizing Auditing to find precedents and dependents related to a function. Enable the Watch Window to view out of sight cells. Use Data Validation to limit the type of data that can be entered into a cell and to create a drop-down list.