Should you use Excel for the Web or Excel Desktop and What’s the Difference?
With Microsoft 365 we have two main ways to access Excel, on the desktop, which means it is loaded onto your laptop or desktop computer or on the web, which means you access by going to www.microsoft.com and logging in. Note: If you are in a corporate environment, you may just click and Excel opens but you may not actually be sure what version of Microsoft Excel 365 you are using! That’s OK….in this post I want to help explain the versions and the differences. Whilst foundationally they are similar, Excel 365 for the web and Excel 365 desktop have …
How to Unlock the Power of 3 Dimensional Formulas in Excel 365: A Game-Changer for Quick Reporting
Looking to streamline your data analysis across multiple worksheets in Microsoft Excel 365? Then you MUST know about 3 Dimensional (3D) formulas! 3 Dimensional formulas allow the same cells to be referenced across multiple worksheets and is great for adding monthly data together with the result appearing on a summary sheet, reducing the risk of errors and helping you work more efficiently. In this post, I’ll share what 3D formulas are, how to use them, and why they are a game changer in Excel, particularly if you are working on consistent data added up over months, weeks, teams or departments. …
How to Easily Track Overdue Payments in Excel
Ever stared at a spreadsheet not sure what payments are overdue and which ones are not, you aren’t the only one. Regardless of whether you’re managing customer invoices, staff salaries or school fees, Excel can be a superpower if you know how to leverage it. Here’s a simple guide to make tracking overdue payments easy! Subscribe to my free eNewsletter for more regular tips and shortcuts… click here. Step 1 – Start with a Simple Table Layout Create columns for items such as: NOTE: Of course, you can also import data in from accounting programs such as Xero, Reckon, Quickbooks …
