Discover the Excel hacks and best practices that empower you to do more with less. Whether it's formulas, keyboard shortcuts, or named ranges, you'll turbocharge your workflow!
Does VBA still have a place in the modern world?
Break through the PivotTable ceiling with formulas.
A collection of surprising examples, from basic to more complex scenarios, of how names are the must-have piece for certain Excel solutions.
How to use VBA to make report charts faster, easier, and less prone to error.
Immediately improve your daily work with these 10 NEW Microsoft Excel functions.
Victor demonstrates how to harness the power of dynamic arrays.
Discover the types of automation within Excel (Power Query/Power Pivot, LAMBDA, VBA, Office Scripts) and when one should be used over another.