Set Reminder Save for later

Intermediate Excel

Learn how to perform intermediate level functions in Microsoft Excel. In this course, you will learn how to use LOOKUP functions, build and modify pivot tables, use conditional formatting, find and replace data, and check for errors. Learning these tools will help you bring data to life and allow you to use Excel in a more meaningful way.

What you'll learn
  • Use the LOOKUP function to look in a single row or column and find a value from the same position in a second row or column.
  • Build and modify pivot tables
  • Use conditional formatting
  • Use find and replace
  • Perform error checking
Segments in this Workshop
    Get Details and Enroll Now

    OpenCourser is an affiliate partner of Treehouse.

    Get a Reminder

    Not ready to enroll yet? We'll send you an email reminder for this course

    Send to:

    Treehouse

    Rating Not enough ratings
    Length 60-minute Data Analysis Course
    Starts On Demand (Start anytime)
    Cost $25/month (Access to entire library- free trial available)
    From Treehouse
    Instructor Tyler Tallon
    Download Videos Only via web browser
    Language English
    Subjects Data Science
    Tags Data Analysis

    Get a Reminder

    Get an email reminder about this course

    Send to:

    Careers

    An overview of related careers and their average salaries in the US. Bars indicate income percentile.

    Middle School English Language Development, AVID & AVID Excel Teacher $50k

    English Language Development, AVID & AVID Excel Teacher $53k

    Enterprise Architecture-Corp Functions $66k

    BUILD Leadership Development Program-HR Generalist, Corporate Functions $67k

    Excel Reporting Developer $68k

    Marketing Coordinator - Functions & Promotions $73k

    Excel/Access DTS Developers $78k

    Excel VBA Developer $82k

    Tutor - Accounting/ Excel /ESL $87k

    Self Perform Concrete Engineer $96k

    BUILD Leadership Development Program-HR Generalist, Corporate Functions Manager $113k

    Senior Corporate Functions Recruiter - Talent Acquisition Specialist $114k

    Write a review

    Your opinion matters. Tell us what you think.

    Treehouse

    Rating Not enough ratings
    Length 60-minute Data Analysis Course
    Starts On Demand (Start anytime)
    Cost $25/month (Access to entire library- free trial available)
    From Treehouse
    Instructor Tyler Tallon
    Download Videos Only via web browser
    Language English
    Subjects Data Science
    Tags Data Analysis

    Similar Courses

    Sorted by relevance

    Like this course?

    Here's what to do next:

    • Save this course for later
    • Get more details from the course provider
    • Enroll in this course
    Enroll Now