OCL Learning

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

The Microsoft Excel SWITCH Function