Audit Excel Blog
611 FOLLOWERS
Covers the latest Excel tricks and Excel tips based on queries from clients and new learning from our excel consultants. Audit Excel provides Microsoft Excel training courses and consulting for all versions of MS Excel.
Audit Excel Blog
1M ago
Free download of the South African Tax Spreadsheet Calculator 2024/ 2025 with salary versus dividends optimization calculation taking into account PAYE, SDL and UIF ..read more
Audit Excel Blog
2M ago
Fixing "Excel found a problem with one or more formula references in the worksheet. Check that the cell references, range names, defined names, and links to other workbooks in your formulas are correct ..read more
Audit Excel Blog
3M ago
Certificate of attendance vs certificate of competency with our MS Excel courses ..read more
Audit Excel Blog
4M ago
What to do if your 'repeat item labels' is greyed out in Excel Pivot Tables ..read more
Audit Excel Blog
5M ago
If you have updated the data of a Pivot Table and it is not being pulled through there are a number of possible reasons. Here we go through them in order of likelihood ..read more
Audit Excel Blog
6M ago
The UK government is telling people to stop using Excel spreadsheets because of multiple data breaches ..read more
Audit Excel Blog
6M ago
How to copy an Excel sheet that is protected, where you are not able to click on the protected cells, only the unprotected cells ..read more
Audit Excel Blog
6M ago
How to drag down a date in Excel without it changing- so the same date must be in all the copied down cells ..read more
Audit Excel Blog
7M ago
How to use the new Navigation button in Excel to easily see and jump between sheets and elements (tables, charts, PivotTables, and images) in big Excel spreadsheets ..read more
Audit Excel Blog
7M ago
One of the most common reasons for errors in spreadsheets is inconsistent formulas in Excel. You look at the first few cells and the formula looks exactly the same so you assume that the whole row is correct, but hidden somewhere is an inconsistent formula that will cause chaos later. The idea of consistency is one of the good spreadsheet practices to be encouraged/ enforced ..read more