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

New No-Code Track! 🚀start learning today!

🌟 Dreaming of a bright future? 🎓 Ask about the Treehouse Scholarship program! 🚀

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

  • Treehouse Logo
  • Plans
    Chevron
    • For Individuals
    • For Businesses
    • For Schools
    • For Libraries
    • For Military
  • Library
    Chevron
    • All Courses
    • Tracks
    • College Credit
  • Techdegree
    Chevron
    • Overview
    • Front End Development
    • Full Stack JavaScript
    • Data Analysis
    • UX Design
    • Python
  • Community
    Chevron
    • Code Adventures
    • Discord
    • Forum
    • Success Stories
    • Treehouse Links
    • 100 Days of Code
  • Resources
    Chevron
    • Career Toolbox
    • CodeForward
    • Free Treehouse Near Me
    • Jobs
    • Blog
    • Support
    • About
  • For Individuals For Businesses For Schools For Libraries For Military
  • All Courses Tracks College Credit
  • Overview Front End Web Development Full Stack JavaScript Python Development Data Analysis UX Design
  • Code Adventures Discord Forum Success Stories Treehouse Links 100 Days of Code
  • Career Toolbox CodeForward Free Treehouse Near Me Jobs Blog Support About
  • Sign In
  • Free Trial
Instagram Twitter Facebook YouTube LinkedIn
    • Newest
      • Newest
      • Active
      • Unanswered
      • Featured
    • All Topics
      • All Topics
      • • General Discussion
      • • AI
      • • Android
      • • 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
  • 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.

    Treehouse

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

See Full Catalogue

Techdegree

  • Front End Web Development
  • Full Stack JavaScript
  • Python Development
  • Data Analysis
  • UX Design

Tracks

  • Learn to Code for Beginners
  • Beginning Python
  • Beginning SQL
  • Beginning Java
  • ...see more

Courses

  • JavaScript Basics
  • Intro to HTML & CSS
  • Python Basics
  • CSS Layout
  • ...see more

Explore

  • Plans
  • Affiliates
  • Perks
  • Free Treehouse Near Me
  • Treehouse for Libraries
  • Treehouse for Businesses
  • Twitter
  • YouTube
  • Facebook
  • LinkedIn
  • Instagram
Terms & Conditions | Privacy

© 2025 Treehouse Island, Inc.