Mastering Data Analysis using Microsoft Excel: Formulas and Pivot Tables

Course description

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.

Are you tired of feeling like you are walking into a brick wall every time you try to organize and analyze spreadsheets in Microsoft Excel? In this Microsoft Excel tutorial, discover how to use the essential Excel formulae to execute all your work automatically, rather than screen the hundreds of cells on your desk using a calculator. You will learn how to use LOOKUP functions to look up information in a row or column and formulae and functions like SUMIF and COUNTIF to do conditional calculations.

After that, you will experiment with a variety of new Excel features and learn how to use UNIQUE and FILTER functions to return a list of unique values in a list and filter a range of data based on the criteria you define. The next section discusses that applying the TEXTJOIN and LET functions leads to adding given text values and controlling the delimiters and calculations within a formula.

This Microsoft Excel course then delves into the benefits of using Named Ranges, such as making formulas easier to enter and debug and generating variable-size ranges to make your spreadsheet dynamic and easy to update. The final part of the course will teach you how to use pivot tables and charts and the techniques needed to combine these two capabilities to perform in-depth numerical analysis, query enormous volumes of data in a variety of user-friendly ways, and add data visualizations. Enrolling in this Microsoft Excel training course will teach you the technical expertise and practical application of a range of important and useful functions in order to master the software so you can become an Excel power user to apply in your data, analytics, technical, administration or finance career.