Audit Excel

Learn how to Excel straight off our coffee mugs auditexcel.co.za/article/cof…

Finally understand why the Excel green has been getting darker and darker. auditexcel.co.za/blog/excels…

Excel Automation with PowerQuery If you spend hours getting data and then cleaning it up (every month) then this course is for you. It will teach you how to perform various complex data cleansing activities using Power Query and save you hours of time re-doing manual work

Spell Check Excel Documents. For more see auditexcel.co.za/blog/spell-… Part of the free 'Excel in 2 minutes per week' series. auditexcel.co.za/blog/learn-… #excel#exceltraining #msexcel #msexceltraining #excelconsultant #excelonlinetraining #excelvirtualtraining

Start of Month Formula in Excel For more see auditexcel.co.za/blog/start-… Part of the free 'Excel in 2 minutes per week' series. auditexcel.co.za/blog/learn-… #excel#exceltraining #msexcel #msexceltraining #excelconsultant #excelonlinetraining #excelvirtualtraining

Stop Users From Inserting / Deleting Rows - 2 ways. For more see auditexcel.co.za/blog/stop-e… Part of the free 'Excel in 2 minutes per week' series. auditexcel.co.za/blog/learn-… #excel#exceltraining #msexcel #msexceltraining #excelconsultant #excelonlinetraining #excelvirtualtraining

IF Function Not Working With Numbers. For more see auditexcel.co.za/blog/if-fun… Part of the free 'Excel in 2 minutes per week' series. auditexcel.co.za/blog/learn-… #excel#exceltraining #msexcel #msexceltraining #excelconsultant #excelonlinetraining #excelvirtualtraining

IF Function Not Working With Numbers. For more see auditexcel.co.za/blog/if-fun… Part of the free 'Excel in 2 minutes per week' series. auditexcel.co.za/blog/learn-… #excel#exceltraining #msexcel #msexceltraining #excelconsultant #excelonlinetraining #excelvirtualtraining

NPV Nominal Rate XNPV Effective Rate. For more see auditexcel.co.za/blog/xnpv-a… Part of the free 'Excel in 2 minutes per week' series. auditexcel.co.za/blog/learn-… #excel#exceltraining #msexcel #msexceltraining #excelconsultant #excelonlinetraining #excelvirtualtraining

For more see auditexcel.co.za/blog/sum-al… Part of the free 'Excel in 2 minutes per week' series. auditexcel.co.za/blog/learn-… #excel#exceltraining #msexcel #msexceltraining #excelconsultant #excelonlinetraining #excelvirtualtraining

For more see auditexcel.co.za/blog/averag… Part of the free 'Excel in 2 minutes per week' series. auditexcel.co.za/blog/learn-… #excel#exceltraining #msexcel #msexceltraining #excelconsultant #excelonlinetraining #excelvirtualtraining

For more information see auditexcel.co.za/excel-train…

Add Happy Face Emoji For more see auditexcel.co.za/blog/add-th… Part of the free 'Excel in 2 minutes per week' series. auditexcel.co.za/blog/learn-… #excel#exceltraining #msexcel #msexceltraining #excelconsultant #excelonlinetraining #excelvirtualtraining

Line break within a cell as the delimiter. For more see auditexcel.co.za/blog/line-b… Part of the free 'Excel in 2 minutes per week' series. auditexcel.co.za/blog/learn-… #excel#exceltraining#msexcel #msexceltraining#excelconsultant #excelonlinetrainingexcelvirtualtraining

Check out my latest video "Find cells with spaces at the end in Excel. Quick way to find spaces and how to remove the spaces" Watch Now: youtu.be/N2m1A1glbcs

Check out my latest video "Start Of Month Formula In Excel. How To Create Start of Month As There Is No Excel Function For It" Watch Now: youtu.be/uag4EahPNwU

Check out my latest video "Change cell colour based on value in cell" Watch Now: youtu.be/AQGic-BXCuA