byIT
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.
Mastering Data Analysis using Microsoft Excel: Formulas and Pivot Tables
Learn how to develop and apply formulas and perform useful data analysis with this free online Microsoft Excel training.
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.
Formulas for Decision Makers
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.
Advanced Formula Tools
Pivot Tables
Course assessment
AD
Related
Articles
The Business of Online Education: A Deep Dive Into Udemy’s Financials
10 Best Assembly Language Courses for 2025: Bare-Metal Programming
70+ FutureLearn Courses with Free Certificates
20 Most Cited Research Papers on MOOCs
EdX’s 2021: Year in Review
Duolingo Acqui-hires Music Gaming Studio NextBeat for $34.5 Million
Recommended Related
Courses
byIT
Foundations of ITIL 4 for Service Management
Start learning
View Details
byIT
CompTIA A+ 1000 - Part 2
Start learning
View Details
byIT
Fundamentals of NIS2 Directive - EU Cybersecurity Enhancement
Start learning
View Details
byIT
Introduction to Electronic Document Management
Start learning
View Details
byIT
Introduction to CCTV Systems & AutoCAD Layouts
Start learning
View Details
byIT
Diploma in ISO 27001:2022 - Information Security Management System (ISMS)
Start learning
View Details
