AutoSum and Count Functions

Instructor:  Jed Guinto
Course Dates: Open-ended
Enrollment Dates: Enroll Anytime
Who can Enroll: Anyone
Course Language: English
Price:  FREE

About the Course

DESCRIPTION
The AutoSum and Count functions are fundamentals tools EVERY Excel user MUST know! These tools especially when they are combined with more advanced formulas later on, become very powerful. The AutoSum and Count functions in themselves are very simple. The former adds all the values in a range of cells, and the latter counts how many entries there are. That’s it! Very simple. 

TARGET AUDIENCE
The first few videos are a must for all users. The later part of the course is for intermediate users. However, completing just the first few videos is sufficient for beginners. 

STRUCTURE
This course has just over 5 videos with a total time just over 10 minutes. 

DIFFICULTY
Beginners and intermediates. 

COURSE OUTCOMES

  • Basic AutoSum functions
  • AutoSum – Average, Count, Max, Min
  • Status Toolbar Checking
  • CountA and CountBlank
  • CountIf and CountIfs

Course Structure

  • AutoSum and Count Functions
    • Introduction
      00:00:00
      • Don't forget to download the work file so you can follow along!
    • AutoSum and Full Table AutoSum
      00:00:00
    • AutoSum - Average, Count, Max, Min
      00:00:00
    • Status Toolbar Checking
      00:00:00
    • CountA and CountBlank
      00:00:00
    • CountIf and CountIfs
      00:00:00
    • Congratulations
      00:00:00
    • Thanks for Watching
      00:00:00

Instructors

Jed Guinto
Jed Guinto
Jed Guinto is the Co-Founder of Paperclip Learning. Currently pursuing his Ph.D. in Aerospace Engineering, he is also an avid educator with experience teaching primary students, high school students and undergraduate Aerospace, Civil and Mechanical Engineers. Over 44,000 students from over 170 countries have signed up for his courses.

This entry was posted in . Bookmark the permalink.