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 you ll learn how to bring data into Excel and build and customize various charts.

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

Moving on you ll 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 you ll create a simple line chart formatting various aspects such as the line background title legend axes and position of charts relative to each other.”