Course Content
Getting Started with Microsoft Excel
Getting Started with Microsoft Excel
0/2
Basic Workbook Operations
Basic Workbook Operations
0/2
Formulas and Functions
Formulas and Functions
0/3
Data Analysis Tools
Data Analysis Tools
0/3
Creating Charts and Graphs
Creating Charts and Graphs
0/2
Advanced Excel Features
Advanced Excel Features
0/3
Collaborating and Sharing Workbooks
Collaborating and Sharing Workbooks
0/3
Microsoft Excel Course
About Lesson

Common Functions

  • SUM: Adds a range of cells. Example: ‘=SUM(A1
     

    )’.

  • AVERAGE: Calculates the average of a range of cells. Example: ‘=AVERAGE(A1
     

    )’.

  • MAX: Returns the highest value in a range of cells. Example: ‘=MAX(A1
     

    )’.

  • MIN: Returns the lowest value in a range of cells. Example: ‘=MIN(A1
     

    )’.

  • COUNT: Counts the number of cells in a range that contain numbers. Example: ‘=COUNT(A1
     

    )’.