Microsoft Office
What is Microsoft Power Automate?
What is Microsoft Power Automate? Explanation for Beginners Power Automate is a versatile tool designed to help users automate tasks and business processes, whether simple or complex, without needing any coding experience. Using Power Automate, you can create workflows for tasks as varied as sending an email notification or approving a document request. Power Automate…
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…
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…
Microsoft Copilot in Excel, Word, and PowerPoint- Recorded Webinar
Explore the innovative capabilities of Microsoft Copilot across Excel, Word, and PowerPoint in this recorded webinar, unlocking new levels of productivity and collaboration. 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…
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…
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…
