72 тысяч подписчиков
56 видео
Sorting months chronologically and not alphabetically in Power Pivot based Pivot Tables in Excel
Excel Test for Job Interview 2021
Filtering a Table to a Dynamic List of Values using Power Query and Power BI
Pivot Table vs a Power Pivot based Pivot Table
Extracting Start and End of Week Dates in Excel or Power BI
Magic of Lists in Power Query
Excel Sequence Function
What is a Date Table and how to create one in Excel - The Date Table (Calendar) Series - Part 1
Ctrl and Enter in Excel - YOU NEED TO KNOW THIS! - Hit the ground running in Excel Series - Part 1
Handling two header rows with Power Query - also applies to Power BI
Join Types in Power Query
5 Excel Shortcuts using the ALT key
Interview with Oz du Soleil, author of Guerrilla Data Analysis Using Microsoft Excel
Create a Date Table in Power Pivot or Power BI - part 2 of the Date Table Series
Dynamic Arrays Introduction
Selecting Ranges with the F8 key in Excel - Excel Shortcuts Series
AI in Excel - Part 1 - Flash Fill
Why each and every Excel user should use Power Query
Consolidate Data from All Excel Worksheets in Multiple Excel Workbooks
Justify Text In Excel
Learn a Foreign Language with Excel
Extending the Date Table for your Data Model - Part 5 of the Date Table Series
Description to Attributes with Power Query - Advanced Power Query tutorial
GoTo Special Command in Excel - Part 3 of the Hit The Ground Running in Excel Series
New Data Types in Excel - Creating Your own - Most influential change for Organizations in Excel
Scroll Trouble In Excel
The Essential Cell Format in Excel - Hit the Ground Running in Excel Series
The Name Box in Excel - Excel A to Z Series
NETWORKDAYS and NETWORKDAYS.INTL functions in Excel
Year To Date on Fiscal Years in Power Query - Your Questions Answered Series
XLOOKUP vs Power Query Joins
Interview with Ken Puls - Author of Master Your Data with Power Query for Excel and Power BI
Interview with George Mount - The Author of Advancing into Analytics
RANDARRAY Function in Excel
The New Filter Function in Excel
Interview with Alan Murray from Computergaga - Talking about his book Advanced Excel Success
R Academy - ggplot2 basics in 15 minutes
7 Tips and Tricks in Excel - Level 300 (Expert Level)
Create a Date Table with Power Query - Part 3 of the Date Table Series
