Using formula, charts, pivot tables , what-if analysis and Solver add-in to understand complex data
Sub Category
- Microsoft
{inAds}
Objectives
- 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
Pre Requisites
- 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.
FAQ
- Q. How long do I have access to the course materials?
- A. You can view and review the lecture materials indefinitely, like an on-demand channel.
- Q. Can I take my courses with me wherever I go?
- A. Definitely! If you have an internet connection, courses on Udemy are available on any device at any time. If you don't have an internet connection, some instructors also let their students download course lectures. That's up to the instructor though, so make sure you get on their good side!
{inAds}
Coupon Code(s)