Don’t Sort Columns in Excel One at a Time – There’s a Much Easier Way
Ever found yourself sorting one column, then another in Excel trying to isolate the information you need? It’s a common task, but one that could be wasting time and creating unnecessary stress and frustration. There is a better way: Excel 365’s Custom Sort option. In one of my Excel videos, I take you through how using Excel’s Custom Sort it is easy to sort multiple columns in one action. This simple change can significantly enhance the way you work with data. Why Is Custom Sort A Better Solution? Although sorting via multiple filters might seem comfortable, it is not that …
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 do I merge data from multiple sheets in Excel without losing anything?
Merging data from multiple Excel sheets can sound and seem complicated, but it doesn’t have to be. If you are looking for an approach that is simple and involves no complicated formulas or heavy duty Excel tools, then I’m here to help. This simplistic approach offers a clear process that minimises stress and prioritises accuracy. Subscribe to my productivity eNewsletter for more tips and insights to make using Microsoft 365 programs easier. Click here. Step 1: Create a Main Worksheet Step 2: Consistency is Key Before merging there are a few things we need to check: Once the data is …
