- Home
- Excel Nerds
Learn the newest Excel tips and tricks and take your Excel wizardry to the next level.
11 Episodes
Episodes
How To Build a Dynamic Finance Dashboard in Excel - Part 2
Episode 11
During part two of our tutorial, you’ll learn how to make your dashboards dynamic and interactive—plus learn best practices for formatting and design.
How To Build a Dynamic Finance Dashboard in Excel - Part 1
Episode 10
It’s time to take your data visualization skills to the next level. In the first part of our tutorial, you’ll discover how to build a succinct and insightful finance dashboard in Excel.
How to Build Advanced Excel Charts for Finance Professionals - Part II
Episode 9
In the second episode of our two-part Excel Nerds training series, you’ll discover techniques for presenting data in Excel and how to build interactive charts
How to Build Advanced Excel Charts for Finance Professionals - Part I
Episode 8
In the first episode of our two-part Excel Nerds training series, you’ll learn best practices for building a budget vs. actual chart in Excel and how to perform variance analysis.
Data Visualization in Excel
Episode 7
Discover best practices in data visualization using Excel charts and graphs with Microsoft MVP and Vena Excel Nerd Chandoo.
Function Series Part 3: LAMBDA Function
Episode 6
In the third episode of our three-part Excel Functions training series with Microsoft MVP Liam Bastick, you’ll learn how to use the LAMBDA function. A relatively new function, LAMBDA allows you to create and name custom functions that can be reused throughout your workbook.
Function Series Part 2: LET Function
Episode 5
In the second episode of our three-part Excel Functions training series with Microsoft MVP Liam Bastick, you’ll learn how to use the LET function. The LET function enables you to define named variables in a formula. This allows you to store intermediate calculations, values or defining names within your formulas.
Function Series Part 1 : VLOOKUP and XLOOKUP
Episode 4
In the first episode of our three-part Excel Functions training series with Microsoft MVP Liam Bastick, you’ll learn how to use the V & X LOOKUP functions. Both V & X LOOKUP are powerful functions and great to learn if you’re working with data on a regular basis.
What-If Analysis Series Part 3 : Simulation Analysis
Episode 3
In the third episode of our three-part What-If Analysis training series with Microsoft MVP Liam Bastick, you’ll learn how to perform simulation analysis. With simulation analysis, you can see the expected range of returns for a given scenario.
What-If Analysis Series Part 2: Sensitivity Analysis
Episode 2
In the second episode of our three-part What-If Analysis training series with Microsoft MVP Liam Bastick, you’ll learn how to perform sensitivity analysis—a tool that can be used in financial modeling to help you make more accurate predictions.
What-If Analysis Series Part 1: Scenario Analysis
Episode 1
In the first episode of our three-part What-If Analysis training series with Microsoft MVP Liam Bastick, you’ll learn how to perform scenario analysis. You’ll discover how to build models that dynamically change based on your assumptions.