Premier Training Hub

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

Avoid this mistake while applying Conditional Formatting in Pivot tables

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

Pivot Table Calculations Basics: Calculated Fields, Items & Sets

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

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

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

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

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

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

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

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

A to Z of Data Validation in Excel (Including 3 unique examples of Custom Validation using Formulas)

Create Multiple Reports in Just 1 Click with Pivot Table Filters

Learn Excel Pivot Tables in 10 minutes

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

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

10 Practical Uses of Excel’s Unique () Function

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

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

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

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

Create Attractive Doughnut / Pie Charts for Presentations & Dashboards

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

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

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

10 Essential Time Saving Tips for Microsoft Excel

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

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

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

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

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

Use Power Query to Create Pivot Table from Multiple Sheets

Excel Data Bars Hack (Separate Values from Data Bars)

How to create a Funnel Chart in All Versions of Excel

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

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

Top 7 Hidden Secrets of Excel Options

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

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

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

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