📊 @uta_excel 👈 仕事が早くなるExcelテク発信中 GROUPBY SUMだけで終わってませんか？😳 実はこれ👇 ✔ 割合 ✔ 平均 ✔ 件数 ✔ 最大・最小 ✔ 月次集計 まで全部できます🔥 今回は GROUPBYの“集計の違い”を解説✨ ■まずは復習👇 =GROUPBY(D22:D107,G22:G107,SUM) 👉 商品ごとの売上合計を自動集計 SUMIFを大量に書かなくてもOK🔥 ■① PERCENTOF =GROUPBY(D22:D107,G22:G107,PERCENTOF,3) 👉 全体売上に対する割合を表示 「どの商品が売上を占めてるか」が一瞬で見える✨ ■② AVERAGE =GROUPBY(D22:D107,G22:G107,AVERAGE,3) 👉 商品ごとの平均売上を集計 売上傾向の比較に便利🔥 ■③ COUNT =GROUPBY(D22:D107,G22:G107,COUNT,3) 👉 データ件数を集計 「どの商品が何回売れたか」も分かる✨ ■④ MAX / MIN =GROUPBY(D22:D107,G22:G107,
1:21
📊 @uta_excel 👈 仕事が早くなるExcelテク発信中 GROUPBY SUMだけで終わってませんか？😳 実はこれ👇 ✔ 割合 ✔ 平均 ✔ 件数 ✔ 最大・最小 ✔ 月次集計 まで全部できます🔥 今回は GROUPBYの“集計の違い”を解説✨ ■まずは復習👇 =GROUPBY(D22:D107,G22:G107,SUM) 👉 商品ごとの売上合計を自動集計 SUMIFを大量に書かなくてもOK🔥 ■① PERCENTOF =GROUPBY(D22:D107,G22:G107,PERCENTOF,3) 👉 全体売上に対する割合を表示 「どの商品が売上を占めてるか」が一瞬で見える✨ ■② AVERAGE =GROUPBY(D22:D107,G22:G107,AVERAGE,3) 👉 商品ごとの平均売上を集計 売上傾向の比較に便利🔥 ■③ COUNT =GROUPBY(D22:D107,G22:G107,COUNT,3) 👉 データ件数を集計 「どの商品が何回売れたか」も分かる✨ ■④ MAX / MIN =GROUPBY(D22:D107,G22:G107,
3.6K views1 week ago
TikTokuta_excel
See more
Static thumbnail place holder

Short videos

0:08
😱 5 Websites to Find INSANELY CHEAP Flights! ✈️💸
1.3K views4 weeks ago
YouTubeVOYECOZY
0:56
The secret to cheap flights is this simple #travel #hacks
125 views1 month ago
YouTubeFind Your Coconut
1:26
How to Find the Cheapest Airfare
1 month ago
YouTubeAround The World In One Day
0:07
Cheapest Flights Right Now: 7 Flight Booking Tricks Airlines Don’t Want You to Know
1.6K views3 weeks ago
YouTubeAirport Strategy
1:28
Cheap Travel Tuesday: How to Book the Cheapest Flights
5.5K views1 month ago
TikTokjetsetting_jacki
1:09
Stop Using Google Flights — This Finds Flights 30% Cheaper
28 views1 month ago
YouTubeCheap Flights Finder : Travel
0:19
These Are the 10 Most Affordable Vacations Right Now
1.7K views5 months ago
YouTubeTravel + Leisure
0:16
👀 Cheap Flights Are Hiding on These Dates — Here's How to Find Them
72.2K views1 month ago
YouTubeFlySafair - For the Love of Flyin
1:59
Trip Planning 101: How to search for cheap flights
874 views2 months ago
YouTubeKatie Rockey
0:14
How I book insanely cheap flights every time #travelhacks #cheapflights #shorts
1.4K views1 month ago
YouTubeTibbe Travels
0:10
The best time to search for cheap flights according to frequent travelers
1 month ago
MSNReady Jet Roam
0:37
The secret to finding cheaper flights every time 🤫 #travelhacks #budgettravel
652 views1 month ago
YouTubeCheap Flights Finder : Travel
2:34
International Trips Under $1,000: Budget Destinations & Tips
479.9K views3 weeks ago
TikTokcallmebyzach
3:18
Booking Cheap Flights: Tips for Affordable Travel
3.4M viewsOct 6, 2024
TikTokclaudia.giblin
1:12
How To Book Cheap Flights Using ChatGPT Tips
368.4K viewsAug 25, 2025
TikToksam_jarman
0:13
Austin Texas travelers ✈️ cheap Europe flight for under $600 round trip AUS ➡️
16.2K views3 weeks ago
TikTokflightswithmimi
1:13
Best Travel Hacks for these cheap flights ✈️ | Traveling Hacks
985 views1 week ago
TikToknatefing
2:58
Air Peace Nigeria Review: $150 USD flight from Enugu to Lagos #nigeria
149.6K views1 month ago
YouTubeTraveltomtom
0:09
Booked my flight with Fly Fairly. easy, no hidden fees, and I even saved 5% on flights with
102.1K views4 months ago
TikTokkim_bulan4
9:10
So many red flags and zero pay to show for it. #youcantaffordananny
81.3K views1 month ago
TikTokkeralala1
Static thumbnail place holder