Learning Outcomes

Microsoft Excel Functions - Part I

Microsoft Excel Functions - Part II

Microsoft Excel Functions - Part III

Lesson Summary

In this module, you will be introduced to sine and radians functions, and also how to use standard deviation and average functions. You will further learn about how to use combined functions in Excel, and other important topics. These functions are needed for effective data analysis and management, allowing you to perform advanced calculations.

Microsoft Excel Functions - Part IV

Microsoft Excel Functions - Part V

Microsoft Excel Functions - Part VI

In this module, you will be introduced to count and round functions in Excel, and also how to use log and log10 functions. You will further learn about how to use degrees and arctan functions in Excel, and other important topics. Mastering these functions will enhance your efficiency in using spreadsheet software and make data organization easier.

Simplified Microsoft Excel Functions - Course Assessment

Get the knowledge needed to become a spreadsheet expert with this simplified Microsoft Excel functions online course.

Simplified Microsoft Excel Functions

In this free online course, you will be introduced to the most simplified Microsoft Excel functions that everyone must know for effective Excel usage. The knowledge of this course will enable you to become a spreadsheet expert and handle data analysis activities with ease. This course is best for beginner to advanced Microsoft Excel users, and examples have been provided to improve understanding. So wait no more and start now.

Introduction to Formulas in Excel

Lookup Formulas

Decision Formulas

New Excel Functions

In this module, you will study how to use basic Excel formulas and functions and the process of inserting them correctly into your worksheet. Learn using the VLOOKUP formula to lookup data in a table, SUMIF to perform a conditional calculation IF to sort data according to a given logic, and Index Match to return the position of a value in a list.

Using Excel Named Ranges and Excel Tables

This module explains the strategies of applying different advanced Excel formula tools to build named ranges. You will learn to create an Excel table, use it as an advanced filter and edit that table with different formulas like RANDOM, NOW or INDIRECT.

Introduction to Pivot Tables

Working with Pivot Tables

Pivot Table Tricks

Excel's Data Model

This module explains the practices used to streamline your workflow in Excel using Pivot tables and Pivot charts. You will explore the ways of computing percentages, running totals, and ranking calculations without using a formula. The methods for displaying dynamic views of data using filters, slicers, and Pivot charts are also covered.

Mastering Data Analysis using Microsoft Excel: Formulas & Pivot Tables - Course Assessment

Learn how to develop and apply formulas and perform useful data analysis with this free online Microsoft Excel training.

Mastering Data Analysis using Microsoft Excel: Formulas and Pivot Tables

Did you know that Excel has become a prerequisite for almost all jobs in the analytics and consulting sector? Through this free online Microsoft Excel certification, you will gain the in-demand skills to generate and use lookup, conditional, and advanced Excel formulas and functions to conduct complex calculations, build professional reports as well as perform the data analysis and visualization of Excel tools, pivot tables and pivot charts.

Coursera and Udemy Shareholders Approve Merger With 99% of Votes

12 Best Data Analysis Courses for 2025: From Data to Insights

20 Most Cited Research Papers on MOOCs

Coursera Q1 2026: Platform Fee Raises Consumer Margins to a Multi-Year High, Enterprise Customers Slip

Udemy’s 2021: Half a Billion Revenue, B2B Revenue Soars, B2C Plateaus

8 Best Crochet Courses for 2025: Practical, Enriching, Creative

2022 Year in Review: The “New Normal” that Wasn’t

SEO Content Strategy Demystified: Coursera, MasterClass, and edX

OpenAI Academy Review: A Close Look at ChatGPT 101 for Small Businesses

200K Layoffs, $100B Lost: The Tsunami of China’s Regulation on Education

Beginning to Program: Review of CS50 Scratch Course

Coursera Lays Off ~150 Staff After Udemy Merger

Coursera Q4 2025: 197M Learners, ~$197M Revenue, ~$27M in Losses

10 Best Free Rust Courses for 2025: Write Memory-Safe Code

How GenAI Costs Sank Duolingo’s Stock 20% (A Non-AI Generated Analysis)

Duolingo Q1 2026: Toward 100M DAUs with Record Engagement and Slower Paid Growth