Excel Data Visualization Techniques
What you'll learn
- Work with datasets to create an interactive Excel Dashboard with pivot tables, where charts and graphs are updated automatically in an easy to view display.
- Understand how to apply your knowledge of Microsoft Excel features for data visualizations
- Create your own portfolio piece to showcase your skills with Microsoft Excel
- Learn how to explain your visualizations, including reports, dashboards, and KPIs
Requirements
- Microsoft Excel 2007, 2010, 2013, 2013, 2019 or Microsoft 365/Online
- Access to an Internet Connection
- Data Samples (Optional)
- Suitable for beginners of Data Visualizations
- Basic Excel experience is required
Description
In today's modern world, individuals and corporations are exposed to data and need to know how to use it to their benefit. Data can provide answers to old problems or predictions of new situations. This course will provide the essential skills needed to successfully create data visualizations, simple and complex in nature. In Excel Data Visualization Techniques, we will walk you through common charting techniques to assemble reports, dashboards, and KPIs. Many of the skills necessary to graduate from Excel to enterprise tools including Microsoft Power BI Desktop and Microsoft Power BI Services as well as Tableau Desktop, Server, and Data Prep are covered in this hands-on, interactive class.
By the time you finish this course, you’ll learn to identify trends, navigate large data sets, and streamline data into visual representations in Excel Topics include:
Data Visualization Principles, including Reports, Dashboards, and KPIs
Tables and Heatmaps
Bar and Column Charts
Gantt Charts
Histogram and Pareto Charts
Box and Whisker Plot Charts
Tree maps and Sunburst
Line Charts (Time Series) & Sparkline
Area & Waterfall Charts
Scatter Plots & Regression
Bubble Charts
Geospatial Maps
Pivot Tables & Dashboards
At the conclusion of each unit, you’ll be able to practice these skills taught using an extended exercise along with various quizzes. When you finish this course, you will be able to build business intelligence deliverables that maximize data visualization.
Who this course is for:
- Beginners who want to work with large data sets in Excel.
- Professionals users looking to learn how to leverage data as an analysis tool.
- Learners who want to expand their portfolio and have a real example of their work to prospective employers.
- For learners who are seeking a well organized, structured, straight-to-the-point course.
- Learners who are tasked with making visualizations of data by creating visual representations like charts and graphs.
- Professionals looking to become more confident in Excel.
- Students who want a structured, engaging, fun and useful Excel course.
Instructor
![Desiree Frances](data:image/svg+xml,%3Csvg xmlns="http://www.w3.org/2000/svg" viewBox="0 0 64 64"%3E%3C/svg%3E){kind=avatar}
- 4.6 Instructor Rating
- 3 Reviews
- 19 Students
- 1 Course
With over 10+ years of in-person and online teaching experience with learners of all ages, Desiree leads HyerTek’s training team. In teaching nationally and internationally, she has evaluated, improved, created, and delivered educational programs for schools, corporations, and government agencies within the public and private sectors. With her diverse experiences in education, she creates engaging, effective, applicable, ethical, and inclusive, technology-assisted educational programs. Many of her courses have been taught entirely in Spanish!
When Desiree is not working, she loves to travel, enjoys long hikes, spelunking and camping with her husband and two dogs. To balance the work rigor, she loves to cook, work with plants and renovate homes. Desiree is also a wellness coach, personal trainer, yoga, Pilates, meditation/mindfulness, and cycling instructor.