Continuing with our MS Excel training experiments, we have made an hour long SUMIFS video available on YouTube. You can download the follow along file direct from the YouTube description or below, and jump to the points you are interested in. Have a look, like and subscribe on the SUMIFS COUNTIFS AVERAGEIFS training exercises and solutions.
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 and Excel knowledge transfer posts.
- Excel Slow- Hidden name ranges?– TIP
- South African Tax Calculator- 2021 (2022 now available)– TIP
- Export file names from a folder into Excel– TIP
- Live/ Virtual Advanced Course- 8-10 Mar 2021 (See Course Outline)- LIVE COURSE
- SUMIFS COUNTIFS AVERAGEIFS YouTube Excel Training– ONLINE COURSES
- Capacity modelling– CONSULTING
- Shift blank cells up– TIP
YouTube Excel 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 and subscribe:
- Match email addresses to employee names– 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
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 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