DIPLOMA
Mastering Data Analysis using Microsoft Excel: Formulas and Pivot Tables
byIT
Mastering Data Analysis using Microsoft Excel: Formulas and Pivot Tables
time1.5-3hrs
levelbeginner level
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
Recommended Related
Courses