Microsoft Excel: Excel Data Visualization & Dashboard Design
Last updated 11/2024
Created by Maven Analytics • 1,500,000 Learners,Enrique Ruiz
MP4 | Video: h264, 1920x1080 | Audio: AAC, 44.1 KHz, 2 Ch
Level: All | Genre: eLearning | Language: English + subtitle | Duration: 74 Lectures ( 6h 25m ) | Size: 3.35 GB
Learn advanced Excel data visualization & dashboard design skills, and build pro-quality Excel dashboards from scratch
What you'll learn
Build stunning, professional-quality dashboards in MS Excel (from scratch!)
Review key data visualization best practices and dashboard design principles
Apply powerful techniques for transforming raw data into beautiful, interactive visuals
Learn the same tools used by professional data analysts, data scientists and business intelligence professionals
Work through 4 unique, hands-on course projects in Excel
Requirements
Microsoft Excel, ideally Office 365 for PC
Mac users are welcome to join, but may have difficulty following along
Description
This is a hands-on, project-based course designed to teach you advanced data analytics, data visualization and storytelling principles, along with powerful techniques for creating dynamic, interactive Microsoft Excel reports and dashboards.We'll start by reviewing data visualization best practices, including tips for selecting the right visuals, eliminating clutter, focusing attention, and telling data-driven stories. From there we'll introduce dashboard design principles, and share frameworks for defining clear objectives, identifying effective metrics and visual elements, and leveraging concepts like reading patterns and Gestalt principles to optimize layout and flow.Throughout the course you'll practice applying these data analysis and visualization techniques to a series of unique, real-world projects and scenarios:Maven MusicCreate a visual showing the evolution of the music industry and the impact of digital formatsMaven CareersBuild a dashboard to explore salary and employment data across key industries in the USMaven ToysDesign a monthly KPI dashboard for sales managers to track regional performance Maven Hotel GroupVisualize hotel booking data to show key cancellation patterns and business insightsBy the end of the course, not only will you have unique, professional-quality MS Excel dashboards to add to your portfolio, but you'll have gained the knowledge and confidence to apply these same concepts to your own spreadsheets.If you're ready to build the exact skills you need to create stunning, high-quality spreadsheets and dashboards in Excel, this is the course for you!Join today and get immediate, lifetime access to the following:6+ hours of high-quality videoDashboard Design PDF ebookDownloadable Excel project files & solutionsExpert support and Q&A forum30-day money-back guaranteeHappy learning!-Enrique (Certified Excel Expert & Instructor, Maven Analytics)__________Looking for our full course library? Search "Maven Analytics" to browse our full collection of Excel, Power BI, SQL, Tableau, Python, Alteryx & Machine Learning courses!See why our Excel courses are some of the TOP-RATED on Udemy:"At the first part I just said to myself, 'Wow, Excel is capable of that? It's amazing!' Then at the second part I told myself 'This guy is doing magic!', and now I feel like I'm capable of doing the same. I can't wait to dive into the other courses!"- Judit B."Excellent from start to finish. I picked up a bunch of techniques that will be useful in the workplace, from new chart templates to some very cool advanced visualizations. I loved all of it!"- Robert C."Excellent material that I apply to my daily use of Excel. I consider myself an Excel professional, yet I picked up dozens of new tips and techniques. Wonderful course, well-presented and well-explained."- Jeffrey P.__________
Who this course is for
Excel users 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 and compelling stories with data
Students looking to learn powerful, practical skills with hands-on projects and demos
Code:
Bitte
Anmelden
oder
Registrieren
um Code Inhalt zu sehen!