The Scenario you have filtered your data in excel, rows hidden and now you want to use SUM to get the total of your filtered row. Only it does not work. It includes the rows that are hidden. 😣 Knowing how clever Microsoft Excel is you know there must be a way to stop this […]
Continue Reading
When working in all of my finance and consultancy roles I used Filters in Excel all the time, daily. That was until I came across Slicers. I am obsessed with the Slicers function in Microsoft Excel. They are often quicker to use than filters and they look so much more professional. Using these will definitely […]
Continue Reading
Are you new to Business Central? Perhaps you have moved systems in your role or have a new role (congratulations!) that uses Business Central/ Dynamics. And it looks nothing like Sage or any of the other systems you have used before. The terminology is even different! This was me a Sage through and through Accountant […]
Continue Reading
How to recover a unsaved spreadsheet. As of 1.5 minutes ago I realized that yesterday I moved a sheet out of excel into a new unsaved workbook so I could view it on a second screen. I proceeded to close all my excel docs ignoring any saving warnings and assumed all useful spreadsheets were under […]
Continue Reading