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, and jump to the points you are interested in. Have a look, like and subscribe on the SUMIFS COUNTIFS AVERAGEIFS training exercises and solutions. We would love feedback on this. Do you prefer this method or the VLOOKUP method from last week?
Forward to a friend
Learn what Excel is good at
Below some of our latest Excel tips and tricks and Excel knowledge transfer posts.
- Make Excel start on the same cell on each sheet– TIP
- South African Tax Calculator- 2021 (2022 available this afternoon)– TIP
- Turn off automatic Pivot Table date grouping– 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
- Pull out one slice of a pie chart– 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 and subscribe:
- VLOOKUP– ONLINE COURSES
- SUMIFS COUNTIFS AVERAGEIFS– 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