Data Analysis Using Excel

Using formula, charts, pivot tables , what-if analysis and Solver add-in to understand complex data

What you'll learn
- Learn how to create formulae and identify the right formula for a use case. Troubleshoot and debugging of formulae
- Add visualization techniques i.e. charts, pivot charts and sparklines to tables and format the charts
- Analyse the data using pivot tables. Understand the different options available in pivot tables
- Use Excel for forecasting, what-if analysis and optimization technique using the Solver add-in
- Building interactive dashboards using Excel

Requirements
- This course requires that learners should have Microsoft Excel installed on their device. Basic knowledge of Microsoft Excel - i.e. opening and saving file and manual data entry knowledge is required. No advanced knowledge of excel is required. This course has been created using Excel 2019. This course will work for Excel 2019 and above. Most of the course will work for all versions of Excel. However, the menu options may change slightly depending upon the specific version used.

Description
This course on "Data Analysis Using Excel" is a beginner level course in Excel that helps in dealing with large amount of data and drawing meaningful conclusions from the data.

The course begins with the use of functions and formulae so that you can transform the raw input into meaningful data. You learn how to visually represent data using different techniques like charts, pivot charts and sparklines. These techniques will let you choose the best method available as per your specific requirement. To slice and dice large data sets and to understand hierarchical relationships between data, you will learn the use of pivot tables. You will learn to give a professional touch to your reports by the use of header and footer. You will learn different tools which aid in decision making - like the goal seek or the scenario manager. You will learn how to let Excel solve complex optimization problems for you using he Solver add-in.

By the end of this course, you will be able to transform raw data into meaningful reports, identify trends, test scenarios, and make informed decisions. Whether you are a student, professional, or business user, this course will help you harness the full potential of Excel for smarter and faster data analysis.

Who this course is for:
- This is a Beginner to Intermediate level course for those working with Microsoft Excel. If you are working with huge amount of data and need to understand more about various formulae, charts and pivot tables then this course is for you. This course is also intended for those who want to understand Excel's capability in forecasting, what-if analysis and usage of the Solver add-in
- If you are a data analyst, who has to work with huge amount of data, analyze the data, find trends and anomalies in data then this course is wok for you.
- If you are a manager, who needs to create reports and dashboards giving project status then this course is for you.
- If you are a business owner, who wants to forecast future sales, or optimize your resources or find out the inputs required to meet your targets, then this course is for you
More Info