Treehouse | Community | Getting Started With Spreadsheets Review

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

Join our Live Career-Building Workshop: Launch Your Tech-Adjacent Career! ⭐ Register here!

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

Curious which AI tools Treehouse developers love? ⚙️ Check them out!

🫡 Treehouse for Military offers discounts to Veterans, service members and their families!

Newest
- Newest
- Active
- Unanswered
- Featured
All Topics

Murilo de Melo
14,456 Points
Filter applied, only the categories F&B and Entertainment selected, =SUM(B5:B176), result: $9,431.00. What's wrong?

Posted September 4, 2018 3:40pm by Murilo de Melo

Murilo de Melo
14,456 Points
2 Answers
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
1 Answer
Tony Ahn
24,417 Points
Data Analysis and UX

Posted August 29, 2018 5:36pm by Tony Ahn

Tony Ahn
24,417 Points
- Data Analysis
1 Answer
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
1 Answer
danielchristie
21,505 Points
Is this test working?

Posted August 14, 2018 3:53pm by danielchristie

danielchristie
21,505 Points
1 Answer
PLUS

Richard gt
Courses Plus Student 749 Points
SET OPERATIONS

Posted August 4, 2018 1:30pm by Richard gt

Richard gt
Courses Plus Student 749 Points
- Data Analysis
0 Answers
PLUS

Richard gt
Courses Plus Student 749 Points
join queries

Posted August 4, 2018 7:09am by Richard gt

Richard gt
Courses Plus Student 749 Points
- Data Analysis
1 Answer
Deborah Watson
2,614 Points
Isn't the answer 07/19/2013?

Posted July 30, 2018 6:54pm by Deborah Watson

Deborah Watson
2,614 Points
1 Answer
Shreya Bhargava
35 Points
SQL - Extract month and date from DATETIME

Posted July 21, 2018 8:51pm by Shreya Bhargava

Shreya Bhargava
35 Points
- Data Analysis
1 Answer
Jun Hyun Yoon
297 Points
My goal ratio = 1 employees per 15 guests. 3,030 guests expected to come. =rounddown(3030/15,0) is it not correct?

Posted July 19, 2018 3:12am by Jun Hyun Yoon

Jun Hyun Yoon
297 Points
1 Answer
Moses Wynn
20,461 Points
Particular value seems arbitrary.

Posted July 13, 2018 9:10pm by Moses Wynn

Moses Wynn
20,461 Points
1 Answer
Ricky Sparks
22,249 Points
In the Retail Network spreadsheet you opened in the fourth quiz question, the number of cells with a value of “TRUE” in?

Posted July 11, 2018 4:10am by Ricky Sparks

Ricky Sparks
22,249 Points
2 Answers
Ricky Sparks
22,249 Points
The date of the highest recorded temperature?

Posted July 9, 2018 5:27am by Ricky Sparks

Ricky Sparks
22,249 Points
1 Answer
Hans Eisenman
1,315 Points
Introductory courses which cover data modeling?

Posted July 3, 2018 8:54pm by Hans Eisenman

Hans Eisenman
1,315 Points
- Data Analysis
0 Answers
Nicolas Montoya
10,592 Points
What is the answer is it not just =ROUNDDOWN(3030/15)?

Posted June 21, 2018 12:44am by Nicolas Montoya

Nicolas Montoya
10,592 Points
1 Answer
Marie-Pier Lauzon
1,434 Points
Copy formula

Posted June 19, 2018 3:02pm by Marie-Pier Lauzon

Marie-Pier Lauzon
1,434 Points
0 Answers
Mary Hunter
216 Points
The total value as I find it is $9,431.00, but the quiz is saying that's the wrong answer. What's wrong?

Posted June 2, 2018 10:41pm by Mary Hunter

Mary Hunter
216 Points
3 Answers
Esdras Dieguez
4,692 Points
don't understand why i'm getting this question wrong? the date of the highest temperature recorded is 07/19/2013 yes?

Posted May 16, 2018 12:43am by Esdras Dieguez

Esdras Dieguez
4,692 Points
1 Answer
PLUS

Jervinne Lester Cruz
Courses Plus Student 535 Points
Getting Philippines stock market values

Posted May 1, 2018 8:40am by Jervinne Lester Cruz

Jervinne Lester Cruz
Courses Plus Student 535 Points
- Data Analysis
1 Answer
bessiebarnes
88,917 Points
How do I find the median? In the Expenses spreadsheet you opened in the first question, the median value of all expenses

Posted April 30, 2018 11:35pm by bessiebarnes

bessiebarnes
88,917 Points
1 Answer
Luis Roman
1,511 Points
I ended up with the same Average and Median Percentage, but as I continued to compare my numbers...

Posted April 27, 2018 5:57pm by Luis Roman

Luis Roman
1,511 Points
0 Answers
Jiatong` Li
1,538 Points
Just wonder how many people find our current business communication platforms have flaws and how we can improve it.

Posted April 23, 2018 1:38pm by Jiatong` Li

Jiatong` Li
1,538 Points
- Data Analysis
1 Answer
Brian Ross
11,209 Points
Is Michael color blind? He called that color blue when it's clearly purple hahaha

Posted April 19, 2018 8:08pm by Brian Ross

Brian Ross
11,209 Points
3 Answers
Brian Ross
11,209 Points
The most expensive item in the other category is $318.00 Is this a bug or a glitch?

Posted April 19, 2018 8:09am by Brian Ross

Brian Ross
11,209 Points
2 Answers
Zach Puckett
3,493 Points
Spreadsheets Basics - Expenses

Posted April 7, 2018 1:24am by Zach Puckett

Zach Puckett
3,493 Points
1 Answer
aymene chaabaoui
901 Points
how to apply machine learning to a database with scikit-learn , idea ??

Posted April 7, 2018 12:39am by aymene chaabaoui

aymene chaabaoui
901 Points
- Data Analysis
0 Answers
Miguel Enriquez
2,057 Points
How to exclude Saturdays and Sundays while using EDATE?

Posted April 2, 2018 5:08am by Miguel Enriquez

Miguel Enriquez
2,057 Points
1 Answer
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
1 Answer
Tim Borrego
1,684 Points
Will there be other Data Vis courses in addition to "Introduction to Data Visualization with Matplotlib"?

Posted March 26, 2018 3:30am by Tim Borrego

Tim Borrego
1,684 Points
1 Answer
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
3 Answers

Prev Page 8 of 33 Next

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