Premier Training Hub

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

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

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

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

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

10 Practical Uses of Excel’s Unique () Function

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

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

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

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

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

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

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

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

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

Create Attractive Doughnut / Pie Charts for Presentations & Dashboards

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

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

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

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

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

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

10 Essential Time Saving Tips for Microsoft Excel

Dynamic Excel Charts Trick: Add Automated Data Labels to any Chart

Learn these Hidden Features to filter Dates in Excel Pivot Tables

Learn to use 'Solve Order' to correct unwanted mistakes in Pivot Table Calculated Fields

Use ChatGPT to create a Gauge Chart / Speedometer Chart in Excel

Learn how to manipulate dates with the important date functions in Excel

Best way to create the Sales & Margin Growth Chart in Excel (4 charts combined into 1 chart)

Create Sales MIS Report in Excel (Compare Sales with Last Month, Last Year and Budget)

How to create a Funnel Chart in All Versions of Excel

I saw my colleague doing this mistake while creating Excel Pivot Table

Attractive Chart Designs in Excel: Create a Bi Directional Bar Chart

50 Most Important & Time saving Excel Shortcut Keys

Create Multiple Reports in Just 1 Click with Pivot Table Filters

The exciting Drill Up/Drill Down Hierarchy in Excel Pivot Tables

Conditional Formatting Super Trick (Auto Apply formatting for Formulas, Numbers, Text & Errors)

The Super Charged ‘Analyze Tool’ in Excel (Speed up your analysis by 5x)

Awesome Excel Technique: Use Power Pivot to combine files and create a single pivot table

Transfer Image/PDF Data into Excel with Latest Feature (Get Data From Picture)

Top 10 Data Cleaning practices in Excel (With Latest Tricks)

Excel Data Bars Hack (Separate Values from Data Bars)

Unlink the Pivot Table Cache (An Excel Dashboard Hack you must know)

Learn Excel Advanced Filter (Step-by-Step) with Best Examples

4 powerful but ignored features of Excel Pivot tables

10 Amazing Excel Tricks that no one tells you (Volume 2)

Avoid this mistake while applying Conditional Formatting in Pivot tables

Excel Advanced Trick: Rotate Any Chart (2 Methods)

Create the Ultimate Sales Dashboard in Microsoft Excel (Part 2)