Subtotal and Sumifs Function in Microsoft Excel

Microsoft Excel can be used for many things and little do people know this. Below are videos teaching how to use the subtotal and sumifs function of Ms Excel.

Also, a little explanation on:

  • Absolute referencing (Video 2)
  • Excel Table (Video 3)
were covered in this video.

The Videos

Watch Pt.1 - https://youtu.be/MkQUJaEE9GA Watch Pt. 2a - https://youtu.be/z_fneX5KHB4 Watch Pt. 2 - https://youtu.be/Qz8K5Eq1fZE Watch Pt. 3 - https://youtu.be/dxncTWBso1Y

The excel file can be downloaded from this link below:

In the file that you just download, ensure that you visit the two sheets and execute the instructions.

Thanks!

Comments

Post a Comment

Popular posts from this blog

Nigerian Air Force DSSC 2018 - Information

Nigerian Air Force DSSC 2018 The Nigerian Air Force which is among the military arm of Nigeria has commenced its 2018 DSSC Enlistment Application. GENERAL INSTRUCTIONS FOR CANDIDATES Online Registration starts on 19th October, 2018 and closes on 16th November, 2018 Applicants must possess a minimum of Second Class Upper for holders of First degree and Upper Credit for HND holders. Computer literacy will be an added advantage. Applicants must possess NYSC Discharge Certificate or Letter of Exemption from NYSC at the time of applying for DSSC. Applicants must possess certificates of full registration with their respective statutory professional bodies in Nigeria where applicable. Male applicants must not be less than  1.66 meters  tall while female applicants must not be less than  1.63 meters  tall. Applicants should be between  22  and  30  years of age by 30th September 2019. Any age declaration done earlier than 5 years to this exe...
Read more

Facebook Job - Secrets and Tips (Applicants)

Image
Do you apply for jobs on Facebook or any social media? Are you tired of the numerous applications you have made?? Does the Job Portal of the social media really functions??? In this video, you get answers to all questions above and others too. *Please do SUBSCRIBE, COMMENT & REACT.* Thanks! For this Job, Kindly like this page, our blog (www.hamplustech.com) and our YouTube channel (https://www.youtube.com/channel/UCvnVtIYp3_t037cL0KjU8DA). This is to keep you posted because the employed will be announced through these channels at the end of the Job deadline. Remmember, like and subscribe to: - www.facebook.com/HamplusHub - https://www.youtube.com/channel/UCvnVtIYp3_t037cL0KjU8DA - www.hamplustech.com Sign: Management, Hamplus Technologies (Hamplus Hub)
Read more