Excel Productivity for Lazy (but Smart) People
Microsoft Excel Tips and Tricks Learning Power Pivot, data modelling and DAX is a skill you need to have if[…]
Read more
Tag: Excel
AWESOME Excel trick to combine data from multiple sheets
Microsoft Excel Tips and Tricks Reconcile & consolidate data from multiple worksheets automatically using this amazingly simple Excel trick. You[…]
Read more
Easily calculate YTD – Year to date totals with this formula (bonus trick on OFFSET)
Microsoft Excel Tips and Tricks Learn how to total Year to Date values for either calendar year (Jan to Dec)[…]
Read more
REPLAY – Your Excel Questions on CUBE functions, Accounting skills, Forecasting, SUBTOTAL & More
Microsoft Excel Tips and Tricks This month, my live stream will focus on your Excel questions. This aired on 19th[…]
Read more
Calculate Moving (or Rolling) Average in Excel
Microsoft Excel Tips and Tricks In this video I demonstrate how to perform moving (or rolling) average calculations. Typically rolling[…]
Read more