Heads up! To view this whole video, sign in with your Courses account or enroll in your free 7-day trial. Sign In Enroll

Data Visualization with Excel

Well done!

You have completed Data Visualization with Excel!

Sign up for Treehouse Back to Library

Practice: Total Sales

1:23 with Michael Watson

The first practice problem for Data Visualization in Excel.

Example Excel Spreadsheet

Related Discussions

Have questions about this video? Start a discussion with the community and Treehouse staff.

Sign up

    Related Discussions

    Have questions about this video? Start a discussion with the community and Treehouse staff.

    Sign up

    [SOUND] Now that we've learned a lot about data visualization and 0:00
    how to create and format charts in Excel, let's put some of that work to practice. 0:05
    Practice makes a big difference with chart building, data analysis, and, 0:12
    let's be honest, a lot of things in life. 0:16
    When I first started working in business, I didn't know much about charts. 0:19
    When to use what type of chart, the vocabulary. 0:23
    I was a complete novice, so 0:26
    in many ways you are already ahead of where I was when I started as an analyst. 0:28
    Over time, I got a lot more comfortable and confident with what I was doing and 0:34
    how I should be visualizing data. 0:39
    I want to remind you of the importance of telling stories when visualizing data. 0:41
    It's not only important as the chief goal of visualizing data, 0:46
    it's also a helpful learning tool. 0:50
    At the outset of my job as an analyst, 0:54
    I participated in the creation of many different stories and 0:56
    through that experience learned how to tell stories by myself. 1:00
    Let's get started on some practice. 1:04
    In this first problem, I want you to open the spreadsheet in the teacher's 1:06
    notes that includes sales data for a fictional retail chain. 1:10
    Your boss has asked you to create a chart showing total sales for 1:14
    the chain over the course of the year. 1:17
    What chart will you show her? 1:20

    You need to sign up for Treehouse in order to download course files.

    Sign up

      You need to sign up for Treehouse in order to set up Workspace

      Sign up