TAKE () Function in Excel (Learn its real use & how to combine it with other functions in excel)

The Inbuilt Data Consolidation Tool in Excel: Combine Multiple Reports into One Single Report

10 Essential Time Saving Tips for Microsoft Excel

Excel Flash Fill Automation Trick: Create Appraisal Letters for entire company in 1 minute

TAKE () Function in Excel (Learn its real use & how to combine it with other functions in excel)

Create NLOOKUP () function to find n'th occurrence of lookup value (something even XLOOKUP cant do)

Top Latest & Exciting New Feature Additions to Microsoft Excel (2023)

The underrated Hyperlink Function in Excel: Combine with a simple VBA code to unleash its full power

10 Practical Uses of Excel’s Unique () Function

Sequence Function: Create Sequential List of Dates, Weekdays & Months in Excel with Best Examples

Correct Wrong Totals for Filtered Items in Pivot Tables (Use Filtered Items with Excel Data Model)

Learn all 3 methods of Recording Macros in Excel (Absolute, Relative, By Selection) with Examples.

DGET () & DSUM () Function: Overcome limitations of VLOOKUP & SUMIFS with database function in Excel

Learn the best methods to create 3 types of Waffle Charts in Excel

Powerful Pivot Trick: Join multiple sheets with Excel Query Connections & create unique pivot table

The Latest Pivot Table Advanced Trick (Create 2 timelines on a single pivot table)

The Least Known Excel Trick: Use Hash sign (#) to create Unique & Dynamic Drop Down Lists

The New ‘Expand’ Function in Excel | Create Datasets Quickly with Expand Function | Best Explanation

Exclusive Charts in Google Sheets: Organisational Chart & Gauge Chart/ Speedometer Chart

Create Attractive Doughnut / Pie Charts for Presentations & Dashboards

10 Cool Chart Tricks in Excel to build creative Dashboards & Presentations

Build Stock Management Tool with Fully Automated Sales, Purchase and Stock Register (in Excel)

Pivot Table Printing Hack: Organise & Print Large Data Systematically using ‘Item wise Page Breaks’

Learn to create and manipulate ‘3D Named Ranges’ in Excel (Includes a Bonus VBA Code)

Excel’s Watch Window: A Must know feature for Large Files & Complex Financial Models