33 тысяч подписчиков
209 видео
Solving Real-World Problems with GCD and LCM: Apples, Oranges, and Buses
Navigating the Power BI Desktop interface - Microsoft Power BI
Excel Hacks - Mastering Advanced Filtering Techniques
Master SUMIF & SUMIFS to generate YTD and MTD Sales in Minutes: Supercharge Your Excel Skills
How to Consolidate Multiple Microsoft Excel Sheets using Power Query - Step by Step Tutorial
📊 Master Pivot Tables in Excel: A Beginner’s Guide! 🔥
Introduction to Python for Microsoft Excel
The VLOOKUP and XLOOKUP Functions - Reference and Lookup Functions
Using SUMIF & SUMIFS to analyze sales Data - A Master Class
Accessing Live Salesforce Objects data from Excel using Power Query
How to Calculate Pay Parity (Pay Gap)
How to create a Pie of Pie and Bar of Pie in Excel
How to Create a Gantt Chart with Excel IF AND Functions
How to create maps using Excel Geo Tool
Three Functions, Same Job - The IFS, IF and VLOOKUP Function
Filtering Data with Multiple Criteria using Excel Filter function
Importing data from folder with multiple files using Power Query
How to fetch live Google Sheet Data to Microsoft Excel
Get More from YouTube Data - Analyze Live Data from YouTube Studio to Excel
How to Calculate Sales Commissions using Excel IF AND Functions
Load a drop down list based on selection of another list in a cell
The DATESMTD, DATESQTD and DATESYTD DAX Expressions in analyzing sales data
The 5 COUNT Group functions in Excel - COUNT, COUNTA, COUNTBLANK, COUNTIF, COUNTIFS
Get and Transform Data from a PDF File to Excel using Power Query
Count Distinct values using UNIQUE and COUNTIF Functions
Calculating Total Sales using SUMIF Function
How to Change Text Cases in Excel using VBA Excel Code - Part II
How to Split First Name and Last Name using LEFT and RIGHT Functions
Use CTRL + E shortcut to split first and last name
Highlight patterns and trends with conditional formatting in Microsoft Excel
SUMIFS with Multiple Conditional AND OR Logic
How to count row and column data with criteria using COUNTIF Excel Function
THe VLOOKUP Function - Multi Column Lookup
Using Microsoft Excel RIGHT & LEFT functions to split text
Create a Table in Power BI from another Power Query
How to use AI tool ChatGPT to write an internship letter
How to join text strings using CONCATENATE and CONCAT Functions
How to generate YTD, MTD and QTD using Power Pivot DAX Expressions
Automate Sales Reports Development with EOMONTH and SUMIF Microsoft Excel Functions - Part I
How to Get the First and Last Purchase Date of Customer then Purchase Price
How to SUM Total Sales by Month and Year using Excel SUMIFS Function
How to create a Speedometer Chart in Excel
How to use TOCOL and TOROW Functions in Excel
Find the Latest Date and Purchase Price using MAX IF and VLOOKUP Functions
How to us the TAKE and CHOOSECOLS functions in Excel
The Excel INDIRECT Function Use Cases - Create a Dependent List and Reference Named Range
How to use the MAX and IF Function to fetch the most recent date - Revaluation Use Case
How to create a Dynamic Chart using Excel OFFSET Functions
How to count specif words in a Cell
Using the ADDCOLUMNS DAX Expression in the CALENDAR TABLE
How to use the Microsoft Excel Sequence Function to generate a calendar
How to calculate Sales Commissions with Excel IFS Function
Count unique values in a range with COUNTIF
How to insert row after every Nth row in Excel
Using conditional formatting and IF Function to compare Actuals and Budgets in Excel
Analyzing Shipping Data with Microsoft Excel Pivot Tables
