Perhaps you work in accounting? Or Finance? Or you use Excel regularly. If you do then you will have entered dates into excel sheets all the time. This post is bringing you another work smarter not harder excel tip and it will make you look so pro in the office. How to insert a calendar […]
Continue Reading
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
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