CRAIG HATMAKER

2.01K subscribers

46 videos

Craig is a Microsoft MVP. His Beyond Excel channel provides tutorials and solutions for creating and using 5g functions in Excel. The Beyond Excel website is...

Latest Videos

How to get 5g functions - 3 easy ways to import 5g functions directly into our Excel workbooks.

In an AI world, Excel is the one.

Step by step tutorial on how to view assumptions and results of an Excel model simultaneously.

Step by Step Excel Tutorial on how to get and install Advanced Formula Environment.

Financial Model Schedules To 5g Functions - Turn major model sections into simple to use functions.

REDUCE and STACK Method - An easy way to convert Financial Model sections into 5g functions (LAMBDA)

MLookupλ A Powerful Addition to Excel's Lookup Functions

Excel Dynamic Array and LAMBDA Tutorial TEXTSPLIT

BXL Tests automates running user defined functions through 100s of randomized scenarios. Free!

Amortizeλ - Insanely easy amortization schedule

Depreciation schedules made incredibly easy

Get GitHub Gist Account for Storing and Distributing 5g Functions

Dynamic Array Revolution Part 2 Converting from traditional to dynamic array model

The dynamic array revolution! Part 1

Circularity in Excel Solved with 5G LAMBDA - Beyond Excel - 5G Modeling. and Recursion.

How to Import 5G Functions into Excel Models

5G Testing - How Beyond Excel tests formulas and 5G LAMBDAs in Excel to ensure accuracy

Fast+ 5G

Intro 5G - Watch an Excel Model do something incredible using 5G methods

5G Modeling Part 2 - Incredibly fast Excel modeling

BXL DAN

PQ Helper

Intro to VBA, the VBE (Visual Basic Editor)

BXL Org Chart Promo

BXL Org Chart Demo

Create mail merge template from un-editable, preprinted form then merge wExcel records.

Beyond Excel's Tiny Database Demonstration

BXL Integrity Checks Walkthrough

How to Use and Manage Cell Styles in Excel

Matching Corporate Colors in Excel