Explanation
This is a hands-on, project-based course designed to teach key theory and design principles, along with powerful techniques for creating dynamic, interactive Excel reports and dashboards. We’ll start with a review of data processing best practices, including tips for choosing the right visuals, eliminating clutter, focusing, and telling data-driven stories. There we will introduce the principles of dashboard design, and share a framework for defining clear objectives, identifying effective metrics and visual elements, and leveraging concepts such as reading patterns and principles. Gestalt to improve form and flow.
By the end of the course, you’ll not only have a high-quality Excel tool to add to your portfolio, but you’ll have the knowledge and confidence to apply these same concepts to your work. If you are ready to build actually skills you need to create high-quality dashboards in Excel, this is the course for you!
What will you learn?
-
Build quality spreadsheets in Excel (from scratch!)
-
Review key data highlighting best practices and principles for dashboard design
-
Apply powerful techniques to transform raw data into beautiful, interactive visuals
-
Learn the same tools used by professional business intelligence analysts and data scientists
-
Work on 4 unique, hands-on projects
Who is this course for?
- Excel users are looking to bring their data to life with dynamic, interactive reports and dashboards
- Analysts, Data Scientists, or BI professionals who want to develop expert-level data visualization and design skills
- Anyone who wants to learn how to tell clear, compelling and informative stories
- Students looking to learn powerful and practical skills with projects and presentations
Microsoft Excel Tutorial: Advanced Dashboard Design in Excel
Microsoft Excel Content: Advanced Dashboard Design in Excel
Requirements
-
Microsoft Excel, compatible with Office 365 for PC
-
Mac users are welcome to join, but it may be difficult to follow
Pictures
Sample Clip
Installation Guide
Extract files and watch your favorite player
Subtitle : English
Quality: 720p
Download Links
Password file: free download software
file size
2.59 GB