Premier Training Hub

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

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

The Top 3 Sum Functions in EXCEL (Sum, Subtotal & Aggregate). Which one will you choose?

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

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

Conditional Formatting Super Tricks - Highlight Full Row with numbers as well as text

Top 10 Excel Shortcut Keys to Simplify Formulas

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

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

50 Most Important & Time saving Excel Shortcut Keys

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

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

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

Create attractive column charts quickly to make them presentation ready

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

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)