Microsoft Excel
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,…
How to Split Cells in Excel
In the realm of Excel proficiency, the ability to efficiently manipulate and organize data is a skill that can significantly enhance productivity. In this tutorial, we unravel the intricacies of splitting cells in Excel, focusing on the practical scenario of disentangling customer names into first and last names. This guide introduces three user-friendly methods to…
How to Use VLOOKUP to Compare Two Lists
Welcome to this tutorial on leveraging Excel’s VLOOKUP function to effectively compare two lists – a skill crucial for anyone navigating extensive datasets. In this comprehensive guide, we’ll delve into the intricacies of VLOOKUP through two practical examples: comparing employee lists and scrutinizing invoice numbers. In today’s data-driven world, professionals often encounter scenarios where aligning…
Custom Formatting in Excel – Recorded Webinar
In this month’s webinar, you’ll learn some amazing tips and tricks on custom formatting in Excel that can help improve your spreadsheet efficiency. Your Excel MVP, Deb Ashby, will explain what custom formatting is and walk you through some basic formatting examples. Learn about conditional formatting, how to copy custom formats, how to use emojis…
Cleaning Data in Power Query – Recorded Webinar
In this recorded live webinar, we’ll teach you the best tips and tricks for cleaning data in Power Query in Microsoft Excel. Your expert Excel trainer and Microsoft MVP, Deb Ashby, discusses what Power Query is and provides an example of what a messy Excel dataset looks like. She will walk you through importing a…
Practical Uses of Lookup Functions in Excel – Recorded Webinar
This recorded live webinar walks you through the practical uses of lookup functions in Excel. Deb Ashby, your Excel expert and Microsoft MVP, will teach you the different lookup functions that are available in Microsoft Excel and how to use them, including basic examples. Learn about the popular VLOOKUP, how to perform flexible lookups using…
Best Excel Formulas: Part 2 (11-20): Essential Excel Formulas to change how you work FOREVER!
Top Excel Functions Microsoft Excel is a versatile tool that goes beyond simple data entry and calculations. With the right formulas, you can transform Excel into a powerhouse for data analysis, decision-making, and automation. In today’s data-driven world, proficiency in Microsoft Excel is more than just a valuable skill—it’s a necessity. Welcome to the second…
PivotTable Tips and Tricks – Recorded Webinar
This recorded live webinar will teach you some of the best Excel PivotTable tips and tricks. Your expert Excel trainer, Deb Ashby, will walk you through the importance of cleaning data, working with both Excel tables and PivotTables, formatting tables, filtering and sorting data, creating a PivotChart, and so much more! In this month’s webinar,…
Practical Uses of Logical Formulas in Excel – Recorded Webinar
This recorded live webinar walks you through the practical uses of logical formulas in Excel. Deb Ashby, your expert Excel trainer, teaches you the different logical functions that are available in Excel and how to use them, including basic examples. This webinar covers the following: Watch the session here, and download the instructor demo files…
Best Excel Formulas: Part 1(1-10): Essential Excel Formulas to change how you work FOREVER!
Top Excel Functions In today’s data-driven world, proficiency in Excel is a highly sought-after skill across many professions. With its vast array of functions, Excel can help you manipulate and analyze data efficiently, making it an indispensable tool for decision-making processes. This tutorial provides a comprehensive guide to ten essential Excel functions: SUM, COUNT, COUNTIF,…
