Audit Excel (@AuditExcel) header
Audit Excel (@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.

 South Africa
auditexcel.co.za
Joined March 2013
  • Tweets2K
  • Following247
  • Followers2.9K
107Media
Photo by Audit Excel (@AuditExcel)Photo by Audit Excel (@AuditExcel)Photo by Audit Excel (@AuditExcel)Photo by Audit Excel (@AuditExcel)Photo by Audit Excel (@AuditExcel)Photo by Audit Excel (@AuditExcel)Photo by Audit Excel (@AuditExcel)Photo by Audit Excel (@AuditExcel)Photo by Audit Excel (@AuditExcel)Photo by Audit Excel (@AuditExcel)
Learn how to Excel straight off our coffee mugs auditexcel.co.za/article/cof…
Image from Audit Excel (@AuditExcel)
98
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 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
195
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 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
186
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

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
139
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
124
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

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

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

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
149
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 Excel

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

auditexcel.co.za
95
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 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
149
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

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

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

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
157
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

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
130
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

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

auditexcel.co.za
116
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

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
115
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

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

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

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…
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

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
1
95
Excel Dropdown List on One Line Only? auditexcel.co.za/blog/excel-…
Excel Dropdown List on One Line Only

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