The Excel Hub

10.3K subscribers

175 videos

The Excel Hub seeks to enhance your Excel and VBA knowledge by providing value-adding tutorials, techniques and examples in order to help you take your sprea...

Latest Videos

Stock Portfolio Tracker In Excel - The Excel Hub

Excel Intermediate #16 - Error Handling Explained IFERROR, ISNA & IF

Excel Intermediate #15 - Excel Text Functions Explained LEFT, RIGHT, MID, TRIM, CONCAT, TEXTJOIN

Excel Intermediate #14 - Dynamic Arrays in Excel The New Way to Filter, Sort & Transform Data

Excel Intermediate #13 - Stop Breaking Your Excel Models Named Ranges & Structured References

Excel Intermediate #12 – INDEX + MATCH Combo To Search Data

Excel Intermediate #11 - VLOOKUP vs HLOOKUP vs XLOOKUP

Excel for Beginners #10 – How to Build a Personal Budget Dashboard in Excel

Excel for Beginners #9 - Freezing Panes & Splitting Windows in Excel

Excel for Beginners #8 – How to Use Excel Tables (Step-by-Step Tutorial)

Excel for Beginners #7 - Conditional Formatting Made Easy

Excel for Beginners #6 - Sorting And Filtering Made Easy

Excel For Beginners #5 – Working With Dates And Times In Excel (Calculate Days, Hours & Durations)

Excel For Beginners #4 – Understand Absolute & Relative Cell References

Excel For Beginners #3 – Essential Excel Formulas You’ll Use Everyday

Excel For Beginners #2 – Entering & Formatting Data In Excel

Excel For Beginners #1 – Navigate The Excel Interface

Efficient Frontier In Excel - Portfolio Optimisation & Multi-Asset Management Tutorial

How To Solve A Portfolio Optimisation Problem In Excel

Visualise Return Distributions In A Portfolio With Histograms – Multi-Asset Portfolio Management

Run A Macro Automatically When A Scroll Bar Is Used In Excel – Gantt Chart VBA Tutorial

Pivot Table 101 Beginner’s Guide To Mastering Pivot Tables In Excel

Yield Curve Analysis And Fixed Income Strategies For Beginners In Excel

How To Create And Analyse A Basic Fixed Income Portfolio In Excel

How To Create A Dynamic Project Timeline Using A Scroll Bar In Excel

How To Create A Dynamic Gantt Chart Using A Scroll Bar In Excel

How To Create A Simple Gantt Chart In Excel

Excel Formulas Unleashed Top 10 Must-Know Functions!

Top 5 Data Validation Techniques In Excel You Need To Know

Master Excel With These Top 7 Conditional Formatting Tips!