Learning Outcomes

Sorting Function

Filter And Conditional Formatting

Pivot Tables And What-If Analysis

Lesson Summary

This module will discuss Excel's sorting, filters, and pivot tables, and you will see how Excel can significantly contribute to effective data organization and analysis. You will learn that the sorting function enables users to arrange data in ascending or descending order based on selected criteria.

Vlookup and Hlookup Functions

Goal Seek And Data Table

Average, Median And Countif Functions

This module will cover the most powerful Microsoft Excel functions like VLOOKUP, HLOOKUP, and Goal Seek. You will learn that they are powerful tools that enhance data analysis and decision-making. You’ll also see that VLOOKUP is a function that enables users to search for a specific value in a vertical column and retrieve information.

Mastering Data Analysis Using Microsoft Excel – Course Assessment

Learn the hot topics of Big Data, Data Analysis, and Microsoft Excel formulas in this free online course.

Mastering Data Analysis Using Microsoft Excel

This course is an invaluable opportunity to gain insight into Data analysis and Microsoft Excel. The knowledge gained will give you the ability to make sense of your company’s data. In addition, you will have the competence to assist your company and managers in making informed decisions based on your data analysis. Discover the different Microsoft Excel formulas and tables that can help you reach your potential.

Introduction to Excel

Other Important Excel Functions

This module will teach you the fundamental and most commonly used Excel functions. You will learn proper syntax writing, functionalities, and how to use functions such as VlookUp, XlookUp, Sum, Average, Find, Concat, logical functions, and more.

Powerful Functions in Excel - Course Assessment

Learn the most important text, numeric, logical and lookup functions in Microsoft Excel in this free online course.

Powerful Functions in Excel

Microsoft Excel is a very popular data processing and organizing tool and this free online Microsoft Excel course will teach you the most useful functions in the program. You will discover the advantages of using Microsoft Excel and become familiar with its interface, how to create pivot tables along with the uses of the pivot table function including examples, as well as other popular features that will have you organizing data in no time.

10 Best Programming Courses for 2025

Udemy Announces Layoffs Without Saying ‘Layoffs’

The Business of Online Education: Khan Academy Tax Returns Analysis (2008–2021)

The Business of Online Education: A Deep Dive Into Coursera’s Financials

Udemy Appoints McKinsey Veteran as CEO Amid Growth Challenges

The Business of Online Education: A Deep Dive Into Udemy’s Financials

Open edX Conference 2024: Program & Speakers

Harvard and MIT’s $800 Million Mistake: The Triple Failure of 2U, edX, and Axim Collaborative

Chinese Edtech Pivots: Well-rounded Education, Hardware, Agriculture E-commerce, Fast-Food, Garments, and More

Coursera’s $100 Million Thesis: Andrew Ng Will Think of Something

6 Best Free OCaml Courses for 2025

2U Lays Off Staff for the Sixth Time Since its $800M edX Acquisition

2000+ Free Developer and IT Certifications

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

CreativeLive is Live Again: CourseHorse Acquires Platform 15 Days Before Shutdown

Chasing 100M Daily Users, Duolingo Reconsiders Ads, Paying Influencers, and Its Most Expensive Plan