Statistical and Math Functions: Advanced Excel

Statistical and Math Functions: Advanced Excel
Published 4/2025
Duration: 1h | .MP4 1280×720, 30 fps(r) | AAC, 44100 Hz, 2ch | 485 MB

Elevate your Excel skills and learn the advance features of Excel with Microsoft Excel Advance.

What you’ll learn
– Analyze data using MEDIAN and MODE functions.
– Rank data using LARGE and SMALL functions.
– Utilize COUNTBLANK to identify empty cells.
– Apply RANK.EQ and RANK.AVG for data sorting.
– Apply specialized rounding techniques for specific scenarios.
– Utilize the AGGREGATE function for advanced data analysis.
– Demonstrate proficiency in mathematical operations within Excel.

Requirements
– Basic and intermediate skill level.
– Access to Microsoft Excel 2021.
– No prior statistical knowledge required.

Description
**This course includes downloadable course instructor files and exercise files to work with and follow along.**

In this course, you will learn how to:

Analyze data using MEDIAN and MODE functions.

Rank data using LARGE and SMALL functions.

Utilize COUNTBLANK to identify empty cells.

Apply RANK.EQ and RANK.AVG for data sorting.

Apply specialized rounding techniques for specific scenarios.

Utilize the AGGREGATE function for advanced data analysis.

Demonstrate proficiency in mathematical operations within Excel.

This course includes:

59 minutesof video tutorials

11 individual videolectures

Course and Exercise Filesto follow along

Certificate of completion

Who this course is for:
– Users with intermediate knowledge of Excel 2021 and those upgrading from previous software versions.
– Users who have Microsoft Excel foundation and seeking to advance their Excel knowledge.
– Business Professionals who need to share their work with others and want to make sure everyone enters the right information.
– Teachers and Educators who create worksheets for students and want to make sure the data entered is accurate.
– Anyone looking to improve Excel skills, especially if you often work with lists or forms and want to prevent mistakes when entering data.
More Info

Please check out others courses in your favourite language and bookmark them
– – – –