Excel Formulas & Functions Part 4: Statistical Functions
Offered By: Skillshare
Course Description
Overview
This course is part 4 of a 9-part series on Excel Formulas & Functions: from basic to advanced.
Statistical functions are critical tools for analyzing quantitative measures in Excel. In this section we’ll review the standard functions (SUM, AVERAGE, MEAN, MEDIAN, STDEV, etc.), then explore some of the more powerful and versatile functions for manipulating data, including ranking tools, random number generators, and dynamic calculations like SUMPRODUCT, SUMIFS and COUNTIFS.
About the Excel Formulas & Functions Series:
In this series, you will develop tools to transform Excel from a basic spreadsheet program into a dynamic and powerful analytics tool. Courses cover 75+ formulas, and feature hands-on, contextual demos and practice exercises designed to help you not only memorize formula syntax, but to think like Excel.
You'll learn how to write complex, powerful functions from scratch, allowing you to:
- Build dynamic tools & dashboards to filter, display and analyze your data
- Join datasets from multiple sources in seconds with LOOKUP, INDEX & MATCH functions
- Pull real-time data from APIs directly into Excel using WEBSERVICE & FILTERXML
- Manipulate dates, times, text, and arrays with ease
- Automate tedious and time-consuming analytics tasks (no VBA required!)
- And much more
If you're looking for the ONE series covering all of the advanced formulas and functions that you need to become an absolute Excel rock star, you've found it!
Syllabus
- Introduction to Statistical Functions
- Basic Statistical Functions
- SMALL/LARGE & RANK/PERCENTRANK
- RAND() & RANDBETWEEN
- The SUMPRODUCT Function
- COUNTIFS/SUMIFS/AVERAGEIFS
- Project Shocase: Building a Basic Dashboard
- HOMEWORK: Statistical Functions
Taught by
Chris Dutton
Related Courses
Social Network AnalysisUniversity of Michigan via Coursera Intro to Algorithms
Udacity Data Analysis
Johns Hopkins University via Coursera Computing for Data Analysis
Johns Hopkins University via Coursera Health in Numbers: Quantitative Methods in Clinical & Public Health Research
Harvard University via edX