Course curriculum

  • 1

    Welcome to the course!

    • A message from your instructor

    • How to use this course

    • Before we begin...
  • 2

    Microsoft Excel Functions

    • Section 1 Intro

    • Lecture 1- Concatenate function

    • Lecture 2-Conditional Formatting

    • Lecture 3-Autosum

    • Lecture 4- Averages

    • Lecture 5-Minimum and Maximum

    • Lecture 6-Count Function

    • Lecture 7-Subtotals
  • 3

    Microsoft Excel Formulas

    • Section 2 Intro

    • Lecture 8-If...Then Formula

    • Lecture 9-Sumifs Function

    • Lecture 10-Countifs Function

    • Lecture 11- Nested If Formula

    • Lecture 12- V-Lookup Function

    • Lecture 13- H-Lookup Function

    • Lecture 14- Pivot Tables Introduction

    • Lecture 15- Pivot Table Data

    • Lecture 16-Pivot Table Construction
  • 4

    Microsoft Excel Charts and Graphs

    • Section 3 Intro

    • Lecture 17-Absolute Value

    • Lecture 18-Creating Pie Charts

    • Lecture 19- Creating Column Charts
  • 5

    It was a Pleasure!

    • A Final Message from Your Instructor

    • More resources for you

    • End of Course Survey