Category: Excel

MS 365 Excel Basics #3: Number Formatting as Façade & when you MUST use ROUND Function

Posted on by Annie D

Download Excel File: https://people.highline.edu/mgirvin/AllClasses/218M365/Content/ExcelBasics03.xlsx
Read (download right-click): pdf notes: https://people.highline.edu/mgirvin/AllClasses/218M365/Content/ExcelBasics03.pdf
In this video learn about how to not be tricked by Number Formatting, and how to use the ROUND function rather than number formatting to calculate accurate payroll, invoicing and income tax calculations. Lean about difference between Currency and Accounting Number Formatting.
Topics:
1. (00:00) Introduction
2. (01:04) What does Number Formatting do?
3. (02:38) Formulas do not see Number Formatting
4. (04:10) Keyboard to apply General Number Formatting (Eraser): Ctrl + Shift + ~ / `
5. (04:40) Number Formatting can save time entering data.
6. (07:40) Currency and Accounting Number Formatting
7. Continue reading “MS 365 Excel Basics #3: Number Formatting as Façade & when you MUST use ROUND Function” →

Excel Which Products Contain Both Of These Items – Episode 2661

Posted on by Annie D

Microsoft Excel Tutorial: Which Products Contain Both Of These Items?

Today, an odd data problem. I have a solution, but I suspect there are much easier ways to do this. I have a list of songs in workouts from Supernatural VR. Over 500 workouts are Quick Hits with just two songs. Each Quick Hits workout should be a subset of a longer workout. Given the two lists, how can you use Excel to find the parent workout?

My solution involves an XLOOKUP with a concatenated key and a concatenated lookup vector. This gives me a list of the Workout IDs that contain Continue reading “Excel Which Products Contain Both Of These Items – Episode 2661” →

MS 365 Excel Basics #2: Add & Count Formulas with COUNT, COUNTA, ROWS, SUM, SUMIFS, COUNTIFS & IF

Posted on by Annie D

Download Excel File: https://excelisfun.net/files/ExcelBasics02.xlsx
pdf notes: https://excelisfun.net/files/ExcelBasics02.pdf
In this video learn every trick there is for Excel formula counting and adding with 10 different Excel Built-in Functions, including how to add and count with a single condition, two or more conditions, an AND Logical Test, and even the elusive OR Logical Test. See many use business examples.
This video is taught by Mike “excelisfun” Girvin, Highline College Profession since 2002 years and excelisfun YouTuber since 2008. This video is #2 in a class of 10 free videos and Excel files! This is a free YouTube class that Continue reading “MS 365 Excel Basics #2: Add & Count Formulas with COUNT, COUNTA, ROWS, SUM, SUMIFS, COUNTIFS & IF” →

MS 365 Excel Basics #1 What is Excel?, Formulas, Functions, Formatting, Cell References & Page Setup

Posted on by Annie D

Download Excel File: https://excelisfun.net/files/ExcelBasics01.xlsx
pdf notes: https://excelisfun.net/files/ExcelBasics01.pdf
In this video learn about the different types of formulas and functions in MS 365 Excel, as well as how to so style and number formatting. Learn about all the shortcuts that will allow you to create an Excel solution with lightening speed and accuracy.
In this video get a complete introduction to Excel basics taught by Mike “excelisfun” Girvin, Highline College Profession since 2002 years and excelisfun YouTuber since 2008. This is video is first in a class of 10 free videos and Excel files!
This is a free YouTube Continue reading “MS 365 Excel Basics #1 What is Excel?, Formulas, Functions, Formatting, Cell References & Page Setup” →

Excel Easy Fake Data From Python In Excel – Episode 2660

Posted on by Annie D

Microsoft Excel Tutorial: Excel Fake Data From Python In Excel

Creating fake data with Python in Excel has never been easier! In this video, I walk you through generating random data directly in Excel using Python’s powerful capabilities. We start from a completely blank workbook, search for Python, and dive into some exciting new options like the QR code generator and random data generator. This process is amazing for anyone who needs quick, randomized data sets without leaving Excel. Just a few clicks, and you can have it all right at your fingertips!

We’ll start by setting up Python to generate a Continue reading “Excel Easy Fake Data From Python In Excel – Episode 2660” →

Excel Draw Perfect Shapes With Draw And Hold Gesture – Episode 2659

Posted on by Annie D

Microsoft Excel Tutorial: Draw Perfect Shapes With Draw And Hold Gesture
In this video, I’m diving into a new feature in Microsoft Excel: the Draw and Hold Gesture!
If you’ve ever wanted to create shapes in Excel without struggling with awkward mouse drawing, this update is for you. While the feature has been available in OneNote for a while, it’s finally made its way to Excel and PowerPoint—at least for those on the Insider’s channel. I’ll walk you through how to activate this new tool and show you what it can do!

First, if you don’t see the Draw tab in Continue reading “Excel Draw Perfect Shapes With Draw And Hold Gesture – Episode 2659” →

Excel Introduces TRANSLATE and DETECTLANGUAGE Functions – Episode 2645

Posted on by Annie D

Microsoft Excel Tutorial: Excel Introduces TRANSLATE and DETECTLANGUAGE Functions.

Unlock the Power of Excel’s New Functions: TRANSLATE and DETECTLANGUAGE

To download the workbook from today: https://www.mrexcel.com/youtube/rOQraANkokQ/

Hey Excel enthusiasts! If you found this video helpful, don’t forget to click Like down below. It helps more people discover this content. In this video, we’re diving into two amazing new Excel functions: TRANSLATE and DETECTLANGUAGE. These functions are game-changers, making it easier than ever to work with different languages in Excel.

First up, the TRANSLATE function. This powerful tool allows you to translate any text from one language to another effortlessly. Just enter Continue reading “Excel Introduces TRANSLATE and DETECTLANGUAGE Functions – Episode 2645” →

UNIQUE-SORT, not SORT-UNIQUE: Killer Array Formula Trick That Everyone Should Know. EMT 1861

Posted on by Annie D

Download Excel File: https://excelisfun.net/files/EMT1861.xlsx
Download Timing Test file: https://excelisfun.net/files/EMT1861TestResults.xlsx
When extracting a sorted unique list with a formula, it is more efficient to use UNIQUE-SORT, rather than SORT-UNIQUE.
Topics:
1. (00:00) Introduction
2. SORT-UNIQUE combination tends to calculate slowly.
3. UNIQUE-SORT tends to calculate quickly.
4. () Summary
5. (02:32) Closing, Video Links

#excel #excelisfun #analytics #analysis #dataanalysis #dataanalytics #excelmvp #freeclass #freecourse #freeclasses #excelclasses #microsoftexcel #microsoftmvp #sort #unique #arrayformulas #excelarrys #dynamicspilled arrays

Amazing XLOOKUP Formula with Lookup Value From Within Description: Excel Magic Trick 1860

Posted on by Annie D

Download Excel File: https://excelisfun.net/files/EMT1860.xlsx
Learn how to extract a lookup value from a description and use it to lookup a value without getting an error.
Topics:
1. (00:00) Introduction
2. () Use lookup value from description to lookup a value. MID function and XLOOKUP with Plus Zero.
3. () Summary
4. (02:32) Closing, Video Links

#excel #excelisfun #analytics #analysis #dataanalysis #dataanalytics #excelmvp #freeclass #freecourse #freeclasses #excelclasses #microsoftexcel #microsoftmvp #xlookup #exceltips

Microsoft Revokes excelisfun MVP Status!

Posted on by Annie D

Today, July 10, 2024, I got a letter from Microsoft that says I am no longer an Excel MVP. I posted about the same number of videos, files and free classes as the year before. I just passed 1,00,000 subscribers. I give everything away for free. But Microsoft says: NO MVP for excelisfun. So be it. I will keep making Excel and Power BI videos because it is fun!!!

Excel Adds Support For RegEx In XLOOKUP And XMATCH – Episode 2647

Posted on by Annie D

Microsoft Excel Tutorial: Using a RegEx match in Excel XLOOKUP
To download the workbook from today: https://www.mrexcel.com/youtube/NZybVpM_dI4/

Welcome to another exciting update from MrExcel! In today’s video, we’re diving into a major breakthrough: RegEx support in XLOOKUP and XMATCH, which was just rolled out on August 14th, 2024. This new feature has been made available to 50% of insiders and promises to revolutionize how you work with data in Excel. If you enjoy the content, don’t forget to hit that Like button below to help more people discover this video!

We’ll start by exploring the new RegEx functionality in XLOOKUP Continue reading “Excel Adds Support For RegEx In XLOOKUP And XMATCH – Episode 2647” →