Data Visualization and Building Dashboards with Excel
Build the fundamental knowledge necessary to use Excel to create data visualizations and to create dashboards containing those visualizations to help tell a lucid story about data.
There is one session available
This course is part of a Professional Course
ABOUT THIS COURSE
This course provides students with the basics required to create data visualizations and dashboards using both Microsoft Excel. You begin the process of telling a story about your data by creating several basic and advanced charts in Excel and learning how to add them to a digital dashboard. By completing this course, you will gain a basic understanding of using spreadsheets as a tool for data visualization. You will also gain the ability to create effective data visualizations, such as charts or graphs, and you will start to see how they can play a key role in the communication of your data analysis findings to interested parties. All of this can be accomplished without the need to write any code. By the end of this course you will be able to describe common dashboarding tools used by a data analyst, design and create a dashboard in a cloud platform, and begin to raise your level of confidence when creating intermediate level data visualizations.
The emphasis is on applied learning and hands-on practice in this course, and with each hands-on lab, you will gain further experience in the creation of basic and advanced charts and the creation of digital dashboards using Excel.
The final assignment project will allow you to apply these newly acquired skills to create and use data visualizations and add them to a digital dashboard to fulfil a business scenario.
This course makes it simple to get started using Excel to create data visualizations and dashboards to help tell a story about your data, and it does not require any previous data analysis or computer science experience. The course
also does not require you to perform any software downloads or installations. All that is basic computer literacy, high-school level math, a device with a modern web browser, and the ability to use (or create) a Microsoft account
to access Excel online at no-cost , and a basic understanding of Excel spreadsheets. Although the Excel hands-on labs steps are specifically related to using ‘Excel for the web’, if you already have the full desktop version of Excel,
you should be able to use that to follow along quite easily with the labs
FREE add a verified certificate at 99USD
What you’ll learn
Basic Excel features to create charts and pivot charts
The important role charts play in telling a data-driven story
About creating advanced charts and visualizations
About the basics of dashboarding
How to create a simple dashboard using a spreadsheet
Join us! It will only take a minute
GET A PROFESSIONAL DATA ANALYSIS CERTIFICATE
You will learn the core principals of data analysis, participate in hands-on skills-based practice, and gain the knowledge to help companies make smarter business decisions