Microsoft Excel
Excel Formulas: Basics and Beyond – Recorded Webinar
This free recorded webinar walks you through getting started with Excel formulas. This session is perfect if you are new to Excel formulas or just want to brush up on the basics and some intermediate functions. Dave Casuto, your expert trainer, kicks off the session by looking at the basic formulas like SUM, COUNT, and…
Mastering Excel Lookups: VLOOKUP, HLOOKUP and XLOOKUP – Recorded Webinar
This month’s webinar introduces you to some essential lookup functions in Excel such as VLOOKUP, HLOOKUP, and XLOOKUP. Join David Casuto, your expert instructor, as he discusses Excel lookup functions, a handy tool for validating and analyzing data. This webinar covers the following: Watch the session here, and download the instructor demo file to follow…
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…
How to Merge Excel Files
Merging Multiple Files Managing and analyzing large volumes of information is crucial in today’s data-driven world. Microsoft Excel, a powerful tool for data manipulation, offers several methods to merge files from multiple worksheets or workbooks into a single, cohesive document. Whether you are a business analyst consolidating financial reports, a researcher combining datasets, or a…
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…
Converting Excel to Word: A Step-by-Step Guide
Embarking on the journey of converting Excel data into Word documents opens a realm of possibilities, offering a seamless blend of numerical precision and document presentation finesse. In this tutorial, we unravel two user-friendly methods. The Copy-Paste method and the Insert method. The Copy-Paste method, marked by its simplicity and speed, is perfect for quick…
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…
Mastering Excel: Convert Text to Numbers
In data manipulation, the ability to convert text into numbers is a fundamental skill that can significantly enhance your proficiency in Excel. This tutorial unravels the intricacies of three distinct methods—VALUE function, Number Format option, and Text to Columns wizard—each designed to transition textual data into numeric formats within your spreadsheets seamlessly. Navigating through these…
Extract Part of Text String from a Cell: Unleashing the Power of Excel Text Functions
Unlocking the potential of Excel’s text functions is a gateway to enhanced data manipulation and extraction capabilities. This comprehensive guide explores fundamental and advanced techniques, providing users with the tools needed to navigate and extract valuable information from their datasets seamlessly. This tutorial caters to users of all levels, from the simplicity of LEFT, MID,…
