Blog
Intro to Excel Macros: how to save time...
How to nest multiple functions in a single formula...
Text functions for fast string manipulation...
Financial functions in Excel: FV, PV, NPV, IRR...
Logical functions (IF, AND, OR) and how to use them smartly...
Charting secrets: presenting data clearly in Excel...
Data analysis in Excel: from simple tables to advanced analytics...
Using Power Query to import and clean data...