@AuditExcel profile picture
Audit Excel @AuditExcel

We offer Excel 2010, 2013, 2016 and 2011 (Apple Mac) Training Courses for all levels in Johannesburg and the whole of South Africa.

Joined March 2013
  • Tweets 1,963
  • Following 248
  • Followers 2,911
107 Photos and videos
Learn how to Excel straight off our coffee mugs auditexcel.co.za/article/cof…
91
Upper and Lower case causing problems in Excel's ability to use the FIND function? auditexcel.co.za/blog/match-…

Match case in Excel FIND causes issue

Match case in Excel FIND causing an issue. You know the word is there but FIND is not working and saying it is not there?

auditexcel.co.za
187
FIND/ REPLACE not working in Excel. Seems to only find it for the whole cell matches and doesn't look inside the cell? auditexcel.co.za/blog/find-t…

FIND the whole cell versus part of cell

FIND not working in Excel? One of the reasons could be that it is searching for the whole cell with nothing before, after or in-between.

auditexcel.co.za
181
Excel's FIND tool not working? Either finding (or not finding) items that are in Notes or Comments inside the spreadsheet? auditexcel.co.za/blog/excels…

Excel's Find not working- notes and comments

MS Excel's 'Find' not working- looks in the notes and comments instead of the main part of the spreadsheets.

auditexcel.co.za
137
University student and need to know how to create a Stem Leaf chart in Excel? See a quick, repeatable way using dynamic arrays. auditexcel.co.za/blog/stem-l…

Stem Leaf Chart in Excel using dynamic arrays

Stem Leaf Chart in Excel using dynamic arrays. Get Excel to split the numbers and place them in a sorted Stem Leaf chart.

auditexcel.co.za
1
1
122
Trying to use Excel NETWORKDAY formula and it is not working? Here are the 3 reasons that could be causing a problem. auditexcel.co.za/blog/excel-…

Excel NETWORKDAYS function not working

Excel NETWORKDAYS function not working? Some of the reasons you are getting the error messages or the results are wrong.

auditexcel.co.za
124
Number of months between 2 dates in Excel WITHOUT using DATEDIF. auditexcel.co.za/blog/number…

Number of months between 2 dates in Excel

How to calculate the number of months between 2 dates in Excel where the DATEDIF function is unreliable (and unknown)

auditexcel.co.za
1
1
148
Quickly fix spaces missing between words in Excel auditexcel.co.za/blog/how-to…

How to Quickly Add Spaces Between Words in Excel

How to quickly add spaces between words in MS Excel e.g. where first name and surname are joined together.

auditexcel.co.za
94
Insert cells missing from Excel right click dropdown? Why you are seeing 'Insert copied cells' and how to get insert cells back. auditexcel.co.za/blog/insert…

Insert cells missing from Excel dropdown options

Insert cells missing from Excel right click dropdown? Why you are seeing 'Insert copied cells' and how to get insert cells back.

auditexcel.co.za
148
EOMONTH function not working in Excel (EOMONTH creates the (E)nd (O)f Month date) auditexcel.co.za/blog/eomont…

EOMONTH function not working in Excel

EOMONTH function not working in Excel? Giving a #Value error? Giving the wrong year? Four possible reasons and their fixes.

auditexcel.co.za
1
141
Copy Multiple Tags from Excel to YouTube auditexcel.co.za/blog/copy-m…

Copy Multiple Tags from Excel to YouTube

How to copy multiple tags from Excel to YouTube i.e. where you paste it expecting separate items and it pastes as a sentence.

auditexcel.co.za
1
156
Strikethrough on all Excel cells suddenly, m2 in Excel cells, SumProduct visible cells only auditexcel.co.za/article/str…

Strikethrough on all cell suddenly, m2 in Excel cells, SumProduct visible cells only

AE News: 13 Nov 2024: Strikethrough on all cell suddenly, m2 in Excel cells, SumProduct visible cells only

auditexcel.co.za
129
Strikethrough appearing on Excel cells then disappearing (and reappearing) and so on auditexcel.co.za/blog/strike…

Strikethrough appearing on Excel cells then disappearing

Strikethrough appearing on Excel cells then disappearing, but you cannot find where the strikethrough came from (not on the format cells)

auditexcel.co.za
115
Excel 2025 Course dates Excel tips and tricks - Cond. Format in pivot tables, PQ overflow error, Linking across workbooks auditexcel.co.za/article/con…

Cond. Format in pivot tables, PQ overflow error, Linking across workbooks

AE News: 23 Oct 2024Cond. Format in pivot tables, PQ overflow error, Linking across workbooks

auditexcel.co.za
1
114
Dynamic Excel hyperlinks, Remove line breaks in Excel, Charts screen preview vs printed version auditexcel.co.za/article/dyn…

Dynamic Excel hyperlinks, Remove line breaks in Excel, Charts screen preview vs printed version

AE News: 2 Oct 2024Dynamic Excel hyperlinks, Remove line breaks in Excel, Charts screen preview vs printed version

auditexcel.co.za
1
190
PowerQuery NOT PowerBI, Build Gmail filters in Excel, Find first non zero value auditexcel.co.za/article/pow…

PowerQuery NOT PowerBI, Build Gmail filters in Excel, Find first non zero value

AE News: 25 Sep 2024PowerQuery NOT PowerBI, Build Gmail filters in Excel, Find first non zero value

auditexcel.co.za
1
111
Creating a Filter for Multiple Email Addresses in Gmail Using Excel auditexcel.co.za/blog/creati…

Creating a Filter for Multiple Email Addresses in Gmail Using Excel

Create a filter in Gmail that applies to multiple email addresses with an 'OR' in between each email address for email filtering.

auditexcel.co.za
100
Excel chart not showing all data? All the possible reasons. auditexcel.co.za/blog/why-yo…

Why Your Excel Chart Isn't Showing All Data

Multiple reasons why your MS Excel chart is not showing all data, varies from the obvious to the more obscure reasons.

auditexcel.co.za
81
Excel dropdown list appears on one row, Chart labels overlapping, Table number format not working auditexcel.co.za/article/exc…

Excel dropdown list appears on one row, Chart labels overlapping, Table number format not working

AE News: 11 Sep 2024Excel dropdown list appears on one row, Chart labels overlapping, Table number format not working

auditexcel.co.za
95
Excel Dropdown List on One Line Only? auditexcel.co.za/blog/excel-…

Excel Dropdown List on One Line Only

How to fix where your MS Excel dropdown validation list is showing on one line only, instead of below each other.

auditexcel.co.za
57
Load more