• Free

Excel Essentials: Functions

  • Course
  • 13 Lessons

Learn the essential functions within Excel! Even if you have zero experience using Excel, this course will make you feel more confident in your spreadsheet analysis abilities. Course Length: 49 Minutes

Want to start learning Excel? This is the course for you!

In this course, you will learn some of more essential functions within Excel, such as:

  • Basic Math Functions

  • IF, AND, OR

  • SUMIF(S), COUNTIF(S), AVERAGEIF(S)

  • Text Functions like CONCATENATE

  • Date & Time Functions

  • Lookup Functions

Functions are one of, if not, the most important concept of learning Excel. Most companies use Excel in their data teams and having the ability to find and analyze data within it can elevate your career.

Contents

Introduction

Welcome!
Course Workbook
Excel Functions PowerPoint Slides

Excel Functions (Part 1)

Basic Math Functions
Logical Functions
Conditional Aggregations

Mid-Course Assessment

Mid-Course Assessment

Excel Functions (Part 2)

Text Functions
Date & Time Functions
Lookup Functions

End-of-Course Assessment

End-of-Course Assessment

Conclusion

Submit your Info for the Leaderboard
Thank you!

Meet your Instructor

Chris French

CEO at DataFrenchy Academy, Senior Analyst at Spring Health

Hi everyone! As a current senior analyst with 5+ years of data analytics experience, I thoroughly enjoy helping others navigate the data analytics world. My goal is to always bring 100% effort into anyone who wants to make a difference in their career and life. I look forward to working with you!