Skip to main content

NOTICE: On Friday Nov 6, Workspaces will be temporarily unavailable for maintenance.

🚀 In our NEW AI Bootcamp you'll build a working app in 28 days, no experience required. Free to all subscription levels.

✨ Earn college credits in Cybersecurity, JS, HTML, CSS and Python

Join the Treehouse affiliate program and earn 25% recurring commission! 🤑

  • Treehouse Logo
    • For Individuals
    • For Businesses
    • For Schools
    • For Libraries
    • For Military
    • All Courses
    • Tracks
    • AI Bootcamp
    • College Credit
    • Techdegree Bootcamps
    • Front End Development
    • Full Stack JavaScript
    • Code Adventures
    • Discord
    • Forum
    • Success Stories
    • Treehouse Links
    • 100 Days of Code
    • Explore
    • Career Toolbox
    • Free Treehouse Near Me
    • Affiliates
    • Blog
    • Support
    • About
    • Learn
    • Beginner's Guide to Coding
    • Data Analysis with SQL & Python
    • Front-End Web Development
    • Python Programming Basics
    • Techdegree Bootcamp Overview
    • UX Design Fundamentals
    • AI Tools for Beginners
  • For Individuals For Businesses For Schools For Libraries For Military
  • All Courses Tracks AI Bootcamp College Credit
  • Techdegree Bootcamps Front End Web Development Full Stack JavaScript
  • Code Adventures Discord Forum Success Stories Treehouse Links 100 Days of Code
  • Explore Career Toolbox Free Treehouse Near Me Affiliates Blog Support About
    Learn Beginner's Guide to Coding Data Analysis with SQL & Python Front-End Web Development Python Programming Basics Techdegree Bootcamp Overview UX Design Fundamentals AI Tools for Beginners
  • Sign In
  • Free Trial
Instagram Twitter Facebook YouTube LinkedIn
Loading banner... Start your free trial at Treehouse
    • Newest
      • Newest
      • Active
      • Unanswered
      • Featured
    • All Topics
      • All Topics
      • • General Discussion
      • • AI
      • • APIs
      • • Coding for Kids
      • • College Credit
      • • Computer Science
      • • CSS
      • • Data Analysis
      • • Databases
      • • Design
      • • Development Tools
      • • Digital Literacy
      • • Game Development
      • • Go Language
      • • HTML
      • • Java
      • • JavaScript
      • • Learning Resources
      • • Machine Learning
      • • No-Code
      • • PHP
      • • Professional Growth
      • • Python
      • • Quality Assurance
      • • React
      • • Ruby
      • • Security
      • • Swift
      • • Vibe Coding
  • brigitte kock
    brigitte kock
    2,054 Points

    I don't understand where the left VS right and bottom VS top is coming from? And what it means?

    Posted November 14, 2020 10:27am by brigitte kock
    brigitte kock
    2,054 Points
    • Data Analysis
    • Intermediate Excel
    • LOOKUP Functions
    • LOOKUP Functions Quiz

    0 Answers

  • Kevin LG
    Kevin LG
    5,641 Points

    What should we do when "F and R" replaces a cell's number(in copied formulas) to give us a redundant total?

    Posted August 14, 2020 4:27pm by Kevin LG
    Kevin LG
    5,641 Points
    • Data Analysis
    • Intermediate Excel
    • Error Checking
    • How To Check For Errors

    1 Answer

  • babypanda
    babypanda
    520 Points

    HLookup Results

    Posted April 12, 2020 4:18pm by babypanda
    babypanda
    520 Points
    • Data Analysis
    • Intermediate Excel
    • LOOKUP Functions
    • Using HLOOKUP to Search in a Row

    1 Answer

  • Steve Nicksic
    Steve Nicksic
    8,968 Points

    "Circle Invalid Data" for Multiple Cells Not Working

    Posted April 6, 2020 9:15pm by Steve Nicksic
    Steve Nicksic
    8,968 Points
    • Data Analysis
    • Intermediate Excel
    • Error Checking
    • Prevent Errors Using Data Validation

    0 Answers

  • MOHAMMED BHUIYA
    MOHAMMED BHUIYA
    2,105 Points

    What are the four areas you can drag your pivot table into?

    Posted September 26, 2019 12:18pm by MOHAMMED BHUIYA
    MOHAMMED BHUIYA
    2,105 Points
    • Data Analysis
    • Intermediate Excel
    • Pivot Tables
    • Pivot Table Quiz

    1 Answer

  • Mark Chesney
    Mark Chesney
    11,747 Points

    Subototal

    Posted February 2, 2019 8:09pm by Mark Chesney
    Mark Chesney
    11,747 Points
    • Data Analysis
    • Intermediate Excel
    • Error Checking
    • Common Errors

    2 Answers

  • Mark Chesney
    Mark Chesney
    11,747 Points

    LibreOffice Calc - how to perform advanced pivot table tips (such as autoupdate after adding row)

    Posted January 25, 2019 11:29pm by Mark Chesney
    Mark Chesney
    11,747 Points
    • Data Analysis
    • Intermediate Excel
    • Pivot Tables
    • Other Pivot Table Tips and Tricks

    1 Answer

  • Mark Chesney
    Mark Chesney
    11,747 Points

    LibreOffice Calc -- please help with Pivot Table

    Posted January 25, 2019 11:02pm by Mark Chesney
    Mark Chesney
    11,747 Points
    • Data Analysis
    • Intermediate Excel
    • Pivot Tables
    • Finishing the Pivot Table

    1 Answer

  • Mark Chesney
    Mark Chesney
    11,747 Points

    Excel VLOOKUP: range_lookup=TRUE instead of FALSE

    Posted January 25, 2019 2:14am by Mark Chesney
    Mark Chesney
    11,747 Points
    • Data Analysis
    • Intermediate Excel
    • LOOKUP Functions
    • LOOKUP Tips and Common Errors

    1 Answer

  • Peter Javorkai
    Peter Javorkai
    31,477 Points

    Usage of absolute references VS using relative reference of value

    Posted September 16, 2018 11:57am by Peter Javorkai
    Peter Javorkai
    31,477 Points
    • Data Analysis
    • Intermediate Excel
    • LOOKUP Functions
    • Using VLOOKUP to Search in a Column

    1 Answer

  • Alexandra Harding
    Alexandra Harding
    1,044 Points

    Why can't I sort the sum of sales in the pivot table unless the total number of units is unchecked?

    Posted August 30, 2018 3:16pm by Alexandra Harding
    Alexandra Harding
    1,044 Points
    • Data Analysis
    • Intermediate Excel
    • Pivot Tables
    • Building a Pivot Table

    1 Answer

  • Charlie Krell
    Charlie Krell
    2,184 Points

    Advanced Pivot Table Features in Teacher's Notes?

    Posted August 23, 2018 12:22pm by Charlie Krell
    Charlie Krell
    2,184 Points
    • Data Analysis
    • Intermediate Excel
    • Pivot Tables
    • Other Pivot Table Tips and Tricks

    1 Answer

  • Marie-Pier Lauzon
    Marie-Pier Lauzon
    1,434 Points

    Copy formula

    Posted June 19, 2018 3:02pm by Marie-Pier Lauzon
    Marie-Pier Lauzon
    1,434 Points
    • Data Analysis
    • Intermediate Excel
    • LOOKUP Functions
    • Using HLOOKUP to Search in a Row

    0 Answers

  • Goekalp Cicek
    Goekalp Cicek
    9,322 Points

    Find and Replace tab does not exist in error sheet

    Posted April 1, 2018 5:18pm by Goekalp Cicek
    Goekalp Cicek
    9,322 Points
    • Data Analysis
    • Intermediate Excel
    • Error Checking
    • How To Check For Errors

    1 Answer

  • Mohammed Ismail
    Mohammed Ismail
    7,190 Points

    Teachers notes on the Intermediate Excel

    Posted March 20, 2018 10:50am by Mohammed Ismail
    Mohammed Ismail
    7,190 Points
    • Data Analysis
    • Intermediate Excel
    • Error Checking
    • Wrapping Up

    3 Answers

Posting to the forum is only allowed for members with active accounts.
Please sign in or sign up to post.

Techdegree

  • Front End Web Development
  • Full Stack JavaScript
SEE ALL

Tracks

  • Learn to Code for Beginners
  • Beginning Python
  • Beginning SQL
  • Beginning Java
SEE ALL

Courses

  • JavaScript Basics
  • Intro to HTML & CSS
  • Python Basics
  • CSS Layout
SEE ALL

About Us

  • About
  • Blog
  • Community
  • Stories
  • Contact
  • Gift Card

Explore

  • Plans
  • Affiliates
  • Perks
  • Shop
  • Free Treehouse Near Me
  • Treehouse for Libraries
  • Treehouse for Businesses

Treehouse is an online technology education platform founded in 2011. Treehouse offers more than 700 self-paced, video-based courses in web development, programming, data analysis, design, and AI, plus two project-based bootcamp programs in Front End Web Development and Full Stack JavaScript. Individual Treehouse plans start at $25 per month and include a 7-day free trial. Treehouse serves individual learners, businesses, schools, and public libraries. Cardholders at participating U.S. public libraries can use Treehouse for free. Select Treehouse courses, offered with University Pathways International, are recommended for college credit by ACE and NCCRS. Treehouse learners earn digital certificates for completed Tracks.

Terms & Conditions · Privacy · © 2026 Treehouse Island, Inc.
  • Twitter
  • YouTube
  • Facebook
  • LinkedIn
  • Instagram
  • Discord