Excel Visualization: Getting Started with Excel for Data Visualization

“Excel charts can be used for a myriad of data visualizations including categorical data and continuous data like time-series data. In this course youll learn how to bring data into Excel and build and customize various charts.

Youll start by importing data from an existing workbook into a new spreadsheet. Youll then import data from CSV and JSON file formats and Microsoft Access database files. Next youll use the Power Query editor to perform various operations.

Moving on youll create column and clustered column charts and perform various formatting operations on the clustered column chart such as adding data labels error bars axis titles and trendlines.

Lastly youll create a simple line chart formatting various aspects such as the line background title legend axes and position of charts relative to each other.”