Channel Avatar

Mike Thomas @UCyuLejo29DEA_GV2Mceetxg@youtube.com

6.9K subscribers - no pronouns :c

Need help with Excel and Power BI? You've come to the right


07:44
Chart Templates: Excel’s Time-Saving Hidden Gem
06:33
Excel: Five Tips for Working with Dates (Details in Description)
07:19
Excel: How to Generate Ordinals (1st, 2nd, 3rd etc)
06:15
Excel: How to Convert Numbers to Roman Numerals and Vice Versa
07:37
Excel: Combine Data from Multiple Sheets Across Multiple Files
07:03
Excel: Automatically Highlight Overdue Dates
05:26
Excel: Add a Listbox to a Worksheet (No VBA Required)
07:57
Create an Interactive, Clickable Image Map in Excel
05:05
Create a Dynamic Top N (5,10) Report Using Excel 365 Functions
09:53
Excel: Import File Names, Sizes and other Attributes (No Coding Required)
04:32
Excel: LOOKUP Not Working on Exact Match Dates? Here’s a Simple Fix!
12:56
Excel: The CUBESET Function - What is the Difference Between Children and Members?
09:56
How I Got Excel for Mac and ChatGPT to Talk to Each Other
05:43
Excel: A Simple Hack to use a Slicer with the GROUPBY Function (Requires Excel 365)
04:36
Excel: Add an ALL Option to a Drop-Down List (Requires Excel 365)
09:10
Excel: Simulate a Pivot Table Filter: Combine a Drop Down List with the GROUPBY Function (Excel 365)
04:22
Excel: Count Items in a Single-Cell Comma-Separated String (Requires 365)
09:15
Excel: No More Pivot Chart Hacks: Use This Instead…GROUPBY: The New Function for 365 Users
06:20
Excel: How to Count Unique Values Without Using a Pivot Table
06:40
PowerBI and Power Pivot (in Excel) Don’t Have VLOOKUP. This is what to use Instead
06:25
Excel: Create a Custom Date Format with Power Query
07:29
Excel: Create Calculated Fields in a Pivot Table
06:26
Excel: SOLVED! The Strange Case of Geography Data Type Language SPILL Errors
11:23
Excel: Use a Parameter Query to Automate Monthly Report Generation from SharePoint Subfolders
06:48
Excel: Remove Unwanted Spaces with TRIM (the Cause of Many Common VLOOKUP/XLOOKUP/FILTER Problems)
13:39
Excel: Create a Refreshable Olympic Games Medals Table Using Power Query on Mac
05:04
Excel: Power Query - How to Import the Most Recent File From a SharePoint Folder
10:03
Excel: Create a Custom Pivot Table Style and Copy it to Another File
10:20
Excel for Beginners: Managing Sheets (Insert, Delete, Rename, Move, Duplicate, Hide/Unhide)
05:38
Excel: Create a Visual Interactive Map-Based Tracker for your Dashboards and Reports
07:24
Excel: Highlight the Highest and Lowest Values in a Pivot Table Row
07:09
Excel: Five Chart Tips and Timesavers for Beginners
09:04
Excel How to Create Clickable Hyperlinks in Power Query
04:52
Excel for Mac: How to Create Custom Lists for Sorting
08:35
Excel: How to use Power Query to Combine Data from Multiple Excel Files with Different Sheet Names
05:33
Excel: How to Calculate the First and Last Working Day of a Month
07:20
Excel: VLOOKUP - How to Find the Next Largest Value
06:59
Excel: How to Display the Percentage of Completed Tasks in a Task Tracker Dashboard
03:59
Excel: How To Quickly Convert Text Dates to Real Dates Without Using Formulas (Text-to-Columns)
15:22
Mail Merge Magic: Insert Images and Clickable Email Addresses from Excel into a Word Document
07:27
Excel for Mac: How to Combine Files Stored in SharePoint or Teams
07:35
Excel: What is a #DIV/0! Error and How Do I Fix It?
06:16
Excel Basics: Stacked Column Charts Explained (Including a Demo of How to Create One)
07:59
Excel: Use VSTACK to Combine Lists Stored in Multiple Sheets but Exclude Blank Rows
05:23
Excel: How to Share and Backup Your Macros and VBA UserForms
05:16
Excel: The Format Painter - How to QUICKLY Copy Formatting (including Column Width)
10:58
Excel: Create a Loan Repayment Schedule
05:40
At Last! You Can Now Create Pivot Tables in the Excel for iPad App
07:51
Excel: Conditional Formatting Directional Icon Sets (Compare This Week’s Position to Last Week)
19:58
Excel: Create a Top 10 Singles Chart Tracker
09:08
Excel for Mac: Enhance Your Dashboards with Automatically Updating Symbols and Emojis
04:21
Excel: Learn the Secrets of the Frequency Function: How to Easily Group Numerical Values
08:29
Excel: 5 Essential Must-Know Slicer Tricks
05:35
Excel: Slicer Buttons aren't Clickable. Here's the Fix!
14:09
Excel: How to Calculate the Date of the Last Friday (Or Any Other Day) of Every Month
06:54
Excel: SUMIF is Outdated. Here’s What to Use Instead
06:06
Excel: Create an Auto-Refreshing Dropdown Using Dynamic Arrays (UNIQUE, SORT and the Hash Sign)
10:17
Excel: When Should You Use the Hash Sign (#) in a Formula?
13:27
Excel Tricks: Creating Markdown Links from Multiple Columns Using Power Query on a Mac
10:24
Excel: Splitting Strings, Emoji Quirks & Nested Function Challenges