We have released another Ad Supported course. This one focuses on Financial Calculations in Excel. If you use PV, PMT, NPV, IRR then have a look at this course. Also useful for university students who are studying finance so please forward to all student in B Comm.
Please forward this mail to anyone who you think struggles with MS Excel.
Forward to a friend
Learn what Excel is good at
Below some of our latest Excel tips and tricks.
- Even SUM can have errors- watch out for these– TIP
- IF not working with TRUE/ FALSE– TIP
- Live/ Virtual Advanced Course- 12-14 April (See Course Outline)- LIVE COURSE
- Financial and compound interest in Excel course– ONLINE COURSES
- Convert Time Sheet to Rooster Automatically– CONSULTING
- Resize all/ some/ non adjacent columns to the same size or auto fit– TIP
- South African Tax Calculator- 2021 (2022 now available)– TIP
YouTube Training
We have released the following training onto our YouTube channel. These include downloads of the exercise file so that you can practice.
Please watch, like, subscribe (and click the bell):
- WORKING days between dates– ONLINE COURSES
- Download VLOOKUP exercises– ONLINE COURSES
- Download SUMIFS, COUNTIFS, and AVERAGEIFS exercises– ONLINE COURSES
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 audit a spreadsheet for errors– Find the errors in your spreadsheet
- Easily import PDF’s into Excel – Import PDF’s into Excel
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