Все публикации

0:14:30

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

0:07:18

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

0:12:24

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

0:10:43

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

0:15:28

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

0:16:16

10 Practical Uses of Excel’s Unique () Function

0:06:00

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

0:08:33

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

0:05:43

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

0:11:25

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

0:06:52

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

0:04:38

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

0:07:10

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

0:05:47

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

0:23:09

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

0:09:33

Create Attractive Doughnut / Pie Charts for Presentations & Dashboards

0:08:15

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

0:23:37

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

0:08:10

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

0:07:12

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

0:04:54

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

0:04:56

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

0:12:22

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

0:19:32

10 Essential Time Saving Tips for Microsoft Excel