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

Intermediate Excel

Preview

Start a free Courses trial
to watch this video

Sign up for Treehouse

Introducing the Course

1:04 with Tyler Tallon

Excel is used all over the world, from the smallest startups to the largest fortune 500 companies. Knowing how to use excel is an invaluable skill - it’s a great tool for organizing data, performing simple analysis, and even more complex tasks like financial modeling. In this course I will teach you how to use the VLOOKUP and HLOOKUP functions, how to build and modify pivot tables, how to use conditional formatting, and perform error checking. Learning these tools will help you bring data to life and allow you to use excel in a more meaningful way.

Beginner Spreadsheet Courses

Here's a list of links to our beginner spreadsheet courses:

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

    [MUSIC] 0:00
    Hi, I'm Tyler and I'm the Finance Director at Treehouse. 0:09
    I'm really excited to be teaching you about Microsoft Excel today. 0:13
    Excel is used all over the world from the smallest startups 0:17
    to the largest Fortune 500 companies. 0:21
    Knowing how to use Excel is an invaluable skill. 0:23
    It's a great tool for organizing data, performing simple analysis, and 0:27
    even more complex tasks like financial modeling. 0:31
    For those of you who are unfamiliar with Excel, 0:34
    I recommend you start by taking our beginner spreadsheet courses. 0:37
    They're great primers for 0:40
    this intermediate course, and are linked below in the teacher's notes. 0:42
    In this course, I will teach you how to use the VLOOKUP and HLOOKUP functions. 0:46
    How to build and modify pivot tables. 0:50
    How to use conditional formatting, and perform error checking. 0:51
    Learning these tools will help you bring data to life and 0:56
    allow you to use Excel in a more meaningful way. 0:59
    All right, let's get started. 1:02

    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