Introduction to Data Analysis with Excel

In this course, you will learn how to use the key features of Microsoft Excel that make it such an essential tool for data analytics. Using the data analysis and visualization features native to Excel, you will be able to extract maximum value from the information your organization collects. you’ll begin with the fundamentals then dive into all you need to understand about spreadsheets, from layout to applications. you’ll gain crucial skills in a variety of concepts, including exploring formulas, cleaning data and identifying data attributes. After finishing this course, you’ll know how to analyze data using Excel and tackle complicated criteria. you’ll master how to use Excel charts to depict data, relationships and potential outcomes, as well as be able to use the what-if functionality of the Analysis ToolPak add-in that comes with Excel.