IT Professional Curricula     Enterprise Database Systems Solution Area     Data Visualization     Data Visualization in Excel

---

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.

---

---

Objectives

Excel Visualization: Getting Started with Excel for Data Visualization discover the key concepts covered in this course open up Microsoft Excel and read in data from an Excel workbook and a CSV file import an Excel file as an XML file and separately import a JSON file into Excel and open it up in the Power Query Editor import data from a PDF document and a Microsoft Access database as well as all files from a folder into Excel visualize data using built-in Excel charts, explore various column chart types, and create basic and clustered column charts customize a clustered column chart, add trendlines and format the chart, then create a basic line chart add up/down bars and high/low lines to a line chart, copy and paste a line chart to a new sheet, and format the line chart format the background fill, texture, axes, and title of a column chart and line chart and change the position of two charts relative to each other summarize the key concepts covered in this course