Please note the POPI/ GDPR Notice below.
Please forward/ share this with anyone who you think struggles with MS Excel.
Learn what Excel is good at
Below some of our latest Excel tips and tricks.
- What gets lost with corrupt Excel files– TIP
- Find the External Links in your Excel files– TIP
- Instructor led Face2Face- 12-14 July 2021 (See Course Outline)- LIVE COURSE
- NEW Beginner to Intermediate Online Course– ONLINE COURSES
- Excel Automation– CONSULTING
- Use multiple characters as a delimiter in text to columns– TIP
Solving for Excel’s weak points
MS Excel is brilliant, but there are 2 things that you may need which Excel CANNOT do very well.
For these there is a little help:
- Learn how to find spreadsheet errors– Find the errors in your spreadsheet
- Easily import PDF’s into Excel – Import PDF’s into Excel
YouTube Excel Training
We release a new tip every weekday onto our YouTube channel.
Please watch, like, subscribe (and click the bell to get notifications). Our playlists that will interest you.
- Merge 2 rows into 1 with the relevant data– Tip
- Fill in blank cells with cell above– Tip
- Move sub headings to own column and fill in blanks– Full Course
- Remove all rows with subtotals– Full Course
POPI/ GDPR Notice
Please be advised that as we prepare for the introduction of the POPI Act (Protection of Personal Information Act), effective 1st July 2021 and the EU data protection law (GDPR), we would like to give all existing customers the opportunity to opt-out/unsubscribe (see link below) should they no longer wish to receive communication from AuditExcel.co.za.
Please be advised that AuditExcel.co.za will only process and make use of your information in the process of carrying out our legitimate business practices and will not share your information with any 3rd party without your prior consent. We, together with relevant stakeholders, have been doing everything possible in ensuring that your personal information is safeguarded and only processed as far as needed and in line with the POPI Act.
Furthermore, we would like to invite all existing customers to advise on any information previously provided to AuditExcel.co.za and if same must be de-identified /destroyed or updated – please email us at info@AuditExcel.co.za to do so.
Please note that by staying opted in, you will continue to receive relevant content such as newsletter emails and information regarding promotional sales etc.
If you are happy to be kept on the mailing list, no action is required. Note that you can opt-out of our email/sms/whatsapp communication at any given point in time.
Contact Us
If you need any:
- MS Excel Training (all levels), or
- Spreadsheet Consulting assistance by MS Excel experts
feel free to contact us.
Keep up to date/ Help Others
If you want to be informed immediately of any new tip, trick or video clip please follow us on YouTube, Facebook, Twitter, Instagram or LinkedIn.
If you have missed a newsletter or want to find an old tip, look at the Newsletter Archive.
If you find these newsletters useful, please help us grow by telling others
Forward to a Friend