Learn To Transform Raw Data Into Stunning, Interactive Dashboards Using Excel Charts, Pivot Tables, Formulas, and Design
Sub Category
- Microsoft
{inAds}
Objectives
- Importance of Data Visualization in Decision Making
- Overview of Excel Visualization Tools
- Data Types, Structure, and Best Practices for Clean Visuals
- Structuring and Cleaning Data Tables
- Using Excel Tables for Dynamic Ranges
- asic Functions for Data Prep
- Choosing the Right Chart: When and Why
- Bar & Column Charts
- Line & Area Charts
- Pie & Donut Charts
- Conditional Formatting (Data Bars, Icon Sets, Heat Maps)
- Custom Chart Designs (Gauge Charts, Bullet Charts Using Creative Techniques)
- Building PivotTables for Data Summarization
- Creating PivotCharts From PivotTables
- Dashboard Wireframing and Layout Techniques
- Color Schemes, Fonts, Spacing, and Chart arrangement
- Best Practices for Performance Optimization and more
Pre Requisites
- No prior excel experience required
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)