Excel Visualization: Getting Started with Excel for Data Visualization

Microsoft    |    Beginner
  • 9 videos | 1h 11m 24s
  • Includes Assessment
  • Earns a Badge
Rating 4.5 of 435 users Rating 4.5 of 435 users (435)
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.

WHAT YOU WILL LEARN

  • 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

IN THIS COURSE

  • 1m 37s
  • 11m 49s
  • Locked
    3.  Using Excel Power Query to Work with Imported Data
    10m 11s
  • Locked
    4.  Importing Various Data Types to Excel
    6m 32s
  • Locked
    5.  Getting Started with Data Visualization in Excel
    10m 40s
  • Locked
    6.  Customizing and Formatting a Column Chart in Excel
    10m 24s
  • Locked
    7.  Creating Basic Line Charts in Excel
    10m 26s
  • Locked
    8.  Formatting Line and Column Charts in Excel
    7m 45s
  • Locked
    9.  Course Summary
    2m

EARN A DIGITAL BADGE WHEN YOU COMPLETE THIS COURSE

Skillsoft is providing you the opportunity to earn a digital badge upon successful completion on some of our courses, which can be shared on any social network or business platform.

Digital badges are yours to keep, forever.

YOU MIGHT ALSO LIKE

Journey Data Visualization Mastery
Rating 5.0 of 8 users Rating 5.0 of 8 users (8)
Course Getting started with charts in Excel 365
Rating 4.5 of 1670 users Rating 4.5 of 1670 users (1670)
Course Customizing charts in Excel 365
Rating 4.5 of 250 users Rating 4.5 of 250 users (250)

PEOPLE WHO VIEWED THIS ALSO VIEWED THESE

Course Visualizing Data for Impact: Introduction to Data Visualization
Rating 4.5 of 78 users Rating 4.5 of 78 users (78)
Course Complete Guide to Excel 365: Pivot, PowerPivot, & Financial Modeling
Rating 4.5 of 353 users Rating 4.5 of 353 users (353)
Course Data Visualization: Best Practices for Creating Visuals
Rating 4.4 of 417 users Rating 4.4 of 417 users (417)