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
Category: 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
4 Ways to Split Cells in Microsoft Excel
Microsoft Excel Tips and Tricks In this video tutorial, I will show you how to split cells in Microsoft Excel[…]
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