Udemy - Data Analysis Using Excel

Data Analysis Using Excel

https://WebToolTip.com

Published 10/2025
MP4 | Video: h264, 1280x720 | Audio: AAC, 44.1 KHz, 2 Ch
Language: English | Duration: 3h 24m | Size: 1.72 GB

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.