iEmoji Feeds @Cheet’s Sheets (CheetSheets)
1.
Cheet’s Sheets
@CheetSheets
Daily Google Sheets Cheat
The most powerful spreadsheet formula
=QUERY(B2:C11,“[your query]”)
• B2:C11 - rang… twitter.com/i/web/status/1…
The most powerful spreadsheet formula
=QUERY(B2:C11,“[your query]”)
• B2:C11 - rang… twitter.com/i/web/status/1…
Retweet of status by @CheetSheets
2.
Cheet’s Sheets
@CheetSheets
Daily Google Sheets Cheat
Improve your decision-making process.
Use FORECAST to get insights into the future and… twitter.com/i/web/status/1…
Improve your decision-making process.
Use FORECAST to get insights into the future and… twitter.com/i/web/status/1…
Retweet of status by @CheetSheets
3.
![CheetSheets]( "CheetSheets: Twitter")
4.
![CheetSheets]( "CheetSheets: Twitter")
5.
![CheetSheets]( "CheetSheets: Twitter")
6.
![CheetSheets]( "CheetSheets: Twitter")
7.
![CheetSheets]( "CheetSheets: Twitter")
Cheet’s Sheets
@CheetSheets
Daily Google Sheets Cheat
Today, we discuss the last of the three averages:
1. Mean
2. Median
3. Mode ←
Mode r… twitter.com/i/web/status/1…
Today, we discuss the last of the three averages:
1. Mean
2. Median
3. Mode ←
Mode r… twitter.com/i/web/status/1…
Retweet of status by @CheetSheets
Cheet’s Sheets
@CheetSheets
@MakadiaHarsh Love r/excel!
r/googlesheets is excellent as well
r/googlesheets is excellent as well
Cheet’s Sheets
@CheetSheets
Daily Google Sheets Cheat
“What day of the week is this date?”
Use WEEKDAY to find out!
=WEEKDAY(C2)
• C2 -… twitter.com/i/web/status/1…
“What day of the week is this date?”
Use WEEKDAY to find out!
=WEEKDAY(C2)
• C2 -… twitter.com/i/web/status/1…
Retweet of status by @CheetSheets
Cheet’s Sheets
@CheetSheets
Today is a special day…
XLOOKUP is now available in Google Sheets!
Let’s explore this powerful spreadsheet formula:
XLOOKUP is now available in Google Sheets!
Let’s explore this powerful spreadsheet formula:
Retweet of status by @CheetSheets
Cheet’s Sheets
@CheetSheets
Quick Google Sheets cheat
Look up matching values with VLOOKUP!
=VLOOKUP(C3,$B$12:$C$18,2,FALSE)
•C3 - value to… twitter.com/i/web/status/1…
Look up matching values with VLOOKUP!
=VLOOKUP(C3,$B$12:$C$18,2,FALSE)
•C3 - value to… twitter.com/i/web/status/1…
Retweet of status by @CheetSheets
8.
![CheetSheets]( "CheetSheets: Twitter")
9.
![CheetSheets]( "CheetSheets: Twitter")
10.
![CheetSheets]( "CheetSheets: Twitter")
11.
![CheetSheets]( "CheetSheets: Twitter")
Cheet’s Sheets
@CheetSheets
Quick Google Sheets tip
“Who’s the best salesperson? And what about 2nd best?”
Use LARGE to find out!
=LARGE(… twitter.com/i/web/status/1…
“Who’s the best salesperson? And what about 2nd best?”
Use LARGE to find out!
=LARGE(… twitter.com/i/web/status/1…
Retweet of status by @CheetSheets
Cheet’s Sheets
@CheetSheets
Quick Google Sheets tip
Need to know your total sales quickly?
Use SUMPRODUCT!
=SUMPRODUCT(C3:C12,D3:D12)
• C… twitter.com/i/web/status/1…
Need to know your total sales quickly?
Use SUMPRODUCT!
=SUMPRODUCT(C3:C12,D3:D12)
• C… twitter.com/i/web/status/1…
Retweet of status by @CheetSheets
Cheet’s Sheets
@CheetSheets
Quick Google Sheets tip
Sometimes you get databases that are just too messy…
Luckily, Google Sheets has lots o… twitter.com/i/web/status/1…
Sometimes you get databases that are just too messy…
Luckily, Google Sheets has lots o… twitter.com/i/web/status/1…
Cheet’s Sheets
@CheetSheets
10 Google Sheets formulas to boost your productivity in July:
Retweet of status by @CheetSheets
...but wait! There's more!
1.
fakhright
@fakhright
astaghfirullah peng.krim guaaaaaaaa..............a *salto sambil solat*
