Intermediate

Essential Excel Functions

Automate your calculations with the most useful Excel functions! Learn to use IF, AVERAGE, SUMIF, and more to create grade reports, budgets, or statistics effortlessly.

  • 4.7/5.0
  • 1492 enrolled
  • Intermediate
  • French
Course Description

Automate your calculations with the most useful Excel functions! Learn to use IF, AVERAGE, SUMIF, and more to create grade reports, budgets, or statistics effortlessly.

SUM, AVERAGE, COUNT for calculating and counting

--

MIN, MAX, MEDIAN for analysis

--

Simple IF: “if grade > 10, then pass”

--

Nested IFs for complex conditions

--

Round or truncate numbers

--

Validate data to prevent errors

--

Project: Automate a grade report

--

Project: Create a monthly or annual budget

--

Léonie NGOUCHE ANOKELLE

Léonie NGOUCHE ANOKELLE

Trainer & Project Manager

About the instructor

I demystify Excel functions. Even the most complex become simple with the right examples!

Student reviews
Inès Roy
Inès Roy

1 week ago

I automated my overall average calculation. No more manual work!

Frequently asked questions

You don’t need to learn them all at once! We focus on the 20% most useful that cover 80% of needs.

Yes, most basic functions are identical. We’ll show you minor differences if needed.
Essential Excel Functions
Online course: 25 € / hour
In-person course: 35 € / hour
Buy

This course includes

  • Chapters 12
  • Duration 8h
  • Level Intermediate
  • Language French
  • Unlimited access Yes
  • Certificate Yes