Microsoft
Data Models, PivotTables, and Power Query in Excel – Recorded Webinar
This month’s webinar teaches you how to transform and analyze data using Data Models, PivotTables, and Power Query in Excel. Join David Casuto, your expert instructor, as he discusses PivotTables, Data Models, and Power Query. He will also cover the advantages and uses of these functions to work on your datasets, Power Pivot, and much…
Conditional Formatting in Excel – Recorded Webinar
In this month’s webinar, you will learn how to use conditional formatting in Excel to help you highlight important data visually and identify patterns and trends within your spreadsheets. Join your Excel expert, David Casuto, as he walks you through various conditional formatting preset rules and how to manage rules. He will also teach you…
Business Charts in Excel – Recorded Webinar
This month’s webinar teaches you the ins and outs of building business charts in Excel, helping you elevate your spreadsheet and Excel skills. Your Excel expert, Deborah Ashby, will walk you through standard and modern Excel charts and discuss chart best practices. You will also learn various chart types and more. This webinar covers the…
Add Interactivity with Form Controls in Excel – Recorded Webinar
In this month’s webinar, you’ll learn how to add interactivity to your spreadsheets using Form Controls and elevate your Excel game. Your Excel MVP, Deb Ashby, will discuss what Form Controls are. She’ll walk you through the types of Form Controls, such as combo boxes, checkboxes, and more, and how to create them. Deb will…
Create Formulas with LAMBDA in Excel – Recorded Webinar
In this month’s webinar, learn how to create your own formulas using LAMBDA in Excel, a powerful function that can help improve your spreadsheet efficiency. Your Excel expert, Deborah Ashby, will walk you through the concept of variables and how to use the LET function within formulas. Then, she’ll go through creating your own formulas…
Troubleshooting Errors in Excel Spreadsheets – Recorded Webinar
In this month’s webinar, you’ll learn some amazing tips and tricks for troubleshooting errors in Excel that can help improve your spreadsheet efficiency. Your Excel MVP, Deb Ashby, will walk you through some of the most common errors you will encounter when working with Microsoft Excel and help you understand what causes them. Learn how…
Introduction to Microsoft Forms – Recorded Webinar
In this recorded webinar, we dive into Microsoft Forms, where you can gain valuable insights on utilizing this powerful tool for creating surveys, quizzes, and feedback forms easily. Your expert host, Deb Ashby, will walk you through accessing Microsoft Forms and exploring the interface. Learn how to create your first form, add and edit questions,…
How to Do Hanging Indent on Word?- 2 Easy Methods
Note: (This guide on how to do Hanging Indent on Word is suitable for all Microsoft Word versions, including Office 365) Tired of hitting the Tab button every time you want to adjust the starting of a paragraph or while breaking it down? Microsoft provides the perfect solution in the form of Indents and Spacing….
How to Insert a Calendar in Word? 3 Easy Methods
Note: (This guide on how to insert calendar in Word is suitable for all Microsoft Word versions, including Office 365) A calendar is a document that helps you organize your time. It can also be used to remind yourself of upcoming events or deadlines. When you are curating a Word document for official purposes containing…
How to Lock a Row in Excel? 4 Useful Ways
(Note: This guide on how to lock a row in Excel is suitable for all Excel versions including Office 365) When working with data, Excel can be an invaluable tool to help you organize, analyze, and visualize data. But imagine if you’re working on a large spreadsheet and you don’t want certain rows to move when…
How to Create Table of Contents in Word- 2 Easy Methods
Note: (This guide on how to create Table of Contents is suitable for all Microsoft Word versions, including Office 365) Using a table of contents (TOC) enhances the quality and readability of your document. A table of contents guiding readers through your document keeps them on track. When writing an article or a blog post,…
How to Add a Column in Excel? 3 Effective Ways
(Note: This guide on how to add a column in Excel is suitable for all Excel versions including Office 365) Excel, as we know it, is widely used for organizing and maintaining a set of personal and professional information. Assume the scenario where you are asked to insert a row or column as added information at…
