@ruri.excel◁仕事を楽しむワーママの投稿はこちら🎀 今回は条件に合うデータをカウントする方法を紹介😌 前の職場で同僚が出欠確認手で数えたら 一人数え間違えちゃったことがあったの😭 お弁当の数も当然一つ足りなくて上司に注意されて 悔し泣きしてたの思い出して今日の投稿作ったよ🌱 仕事でミスするのってマジで悔しいから そんな思いをする人が少しでも減るといいな。 （ちなみにその話聞いたあとこの方法同僚に教えたよ） ───────────────────── ‎✎ܚ 解説 ◽️出席の集計 ①集計したいセルに＝COUNTIF（範囲，条件）を入力 ②Enterを押すと集計完了 ◽️欠席の集計 ①範囲選択してF4キーを押してセルを固定 ②固定してドラッグすると欠席も集計完了 ※出席のセルをそのままドラッグすると データの範囲がズレちゃうから注意してね⚠️ ───────────────────── いつもいいねやコメントありがとうございます𐙚🤍 私の原動力！励み！になっています😌 右下の「•••」から保存して見返すとお仕事中便利です🌸 このアカウントでは 毎日残業でスキルアッ
0:40
TikTokruri.excel
@ruri.excel◁仕事を楽しむワーママの投稿はこちら🎀 今回は条件に合うデータをカウントする方法を紹介😌 前の職場で同僚が出欠確認手で数えたら 一人数え間違えちゃったことがあっ
るり⌇ワーママの仕事を楽しむExcel×お仕事tips(@ruri.excel). 캔디 하트(Candy Heart) - JOY MOON. @ruri.excel 仕事を楽しむワーママの投稿はこちら🎀 今回は条件に合うデータをカウントする方法を紹介😌 前の職場で同僚が出欠確認手で数えたら 一人数え間違えちゃった ...
1K views2 weeks ago
Microsoft Excel Excel Tips and Tricks
Top 100 Excel Tips and Tricks to Make You Productive in 2026
Top 100 Excel Tips and Tricks to Make You Productive in 2026
excelchamps.com
Jul 24, 2024
These 47 Expert Excel Tricks Will Transform You Into a Power User
These 47 Expert Excel Tricks Will Transform You Into a Power User
pcmag.com
3 months ago
Microsoft Excel Full Tutorial in Hindi | Excel Tips & Tricks | Learn Excel Formulas, Charts & Data
0:57
Microsoft Excel Full Tutorial in Hindi | Excel Tips & Tricks | Learn Excel Formulas, Charts & Data
YouTubeZindagi Technical
236 views2 weeks ago
Top videos
Excel Convert Text to Number with Keyboard Shortcuts
Excel Convert Text to Number with Keyboard Shortcuts
excelcampus.com
May 6, 2013
CODE Function Examples - Excel & Google Sheets
15:00
CODE Function Examples - Excel & Google Sheets
automateexcel.com
Feb 6, 2023
GROUP and SUBTOTAL data in Excel | Excel Quick Help
GROUP and SUBTOTAL data in Excel | Excel Quick Help
excelquick.com
Jun 21, 2019
Microsoft Excel Excel Formulas
101 Advanced Excel Formulas & Functions Examples
101 Advanced Excel Formulas & Functions Examples
myexcelonline.com
127K viewsMar 3, 2021
Subtraction in Microsoft Excel
0:42
Subtraction in Microsoft Excel
YouTubeMicrosoft 365
517.2K viewsOct 3, 2019
Excel Formulas And Functions
39:03
Excel Formulas And Functions
YouTubeMike's Office
15.5K viewsMay 19, 2021
Excel Convert Text to Number with Keyboard Shortcuts
Excel Convert Text to Number with Keyboard Shortcuts
May 6, 2013
excelcampus.com
CODE Function Examples - Excel & Google Sheets
15:00
CODE Function Examples - Excel & Google Sheets
Feb 6, 2023
automateexcel.com
GROUP and SUBTOTAL data in Excel | Excel Quick Help
GROUP and SUBTOTAL data in Excel | Excel Quick Help
Jun 21, 2019
excelquick.com
Fully Automated Stock and Inventory Management System in Excel [No VBA] PART 1 - QuickExcel
Fully Automated Stock and Inventory Management System in …
Aug 31, 2021
quickexcel.com
Excel Barcode Generate in just 5 sec🔥😍✔️ #excel #exceltipsandtricks #exceltutorial #computer #tls #tlscomputer #gurmeetsir #instareels #reels #facebookreels | TLS Computer
1:00
Excel Barcode Generate in just 5 sec🔥😍✔️ #excel #exceltipsandtrick…
379.4K viewsOct 27, 2023
FacebookTLS Computer
How to Lock Cells for Editing and Protect Formulas - Excel Campus
How to Lock Cells for Editing and Protect Formulas - Excel Campus
Apr 4, 2019
excelcampus.com
How to Calculate Standard Deviation in Excel Step-by-Step
How to Calculate Standard Deviation in Excel Step-by-Step
Jan 27, 2023
spreadsheeto.com
Code in Excel - Examples, How To Use?
Sep 24, 2018
wallstreetmojo.com
Convert text to numbers
9 months ago
exceljet.net
Auto Numbering in Excel - How To Do? Examples, Ways, Template
Jan 2, 2019
wallstreetmojo.com
0:39
Total the data in an Excel table
May 20, 2014
Microsoft
1:09:21
GUILD LEAGUE - ASSASIN PROSGARD GOD OF WAR !! MOJ…
843 views2 weeks ago
YouTubeMojo L2M
0:21
Add Code in Excel Formula Easily | Excel Code Formula Tutorial for B…
296 views3 weeks ago
YouTubeProfessional skill
1:31
Excel Copilot Function: Easy Data Extraction
7K views1 week ago
TikTokjifryissadeen
0:54
Tons of untreated chemical waste is dumped in rivers everyday day. B…
412.2K views2 weeks ago
x.comAdivaraha
38:06
【Excel必备技能】做数据分析只会 Excel？照样吊打大部分人
283 views5 days ago
bilibili黑曼巴大师兄
0:25
Automatically Calculate Totals in Excel with Shortcuts
17.4K views2 months ago
TikToktotmindschools
Excelhacks101 | Daily Excel Tips on Instagram: "How to Calculate Sale…
151.2K views7 months ago
Instagramexcelhacks101
11:22
How to create barcodes in Excel that WORK!
696.3K viewsFeb 6, 2020
YouTubeLeila Gharani
2:07
How to Use the FREQUENCY Function in Excel
102.2K viewsJan 20, 2016
YouTubeExcel Bootcamp
8:24
CODE Excel Function - Overview, Example, How to Use Code Formu…
69K viewsJul 28, 2019
YouTubeWallStreetMojo
25:16
Microsoft Excel Tutorial - Beginners Level 4
633.2K viewsFeb 22, 2021
YouTubeTeacher's Tech
3:57
How to Calculate Percentages in Excel
636.5K viewsAug 4, 2019
YouTubeKevin Stratvert
4:40
How To Insert Page Number In Excel
291.7K viewsMar 17, 2021
YouTubeExcel 10 tutorial
10:20
Modern Excel Data Entry Work Form Tutorial
862.8K viewsJul 12, 2021
YouTubeKevin Stratvert
7:57
Microsoft Excel Tutorial for Beginners #4 - Functions (Formulas)
1.3M viewsApr 28, 2008
YouTubeMotionTraining
9:52
Introduction to Correlation Analysis in Excel
119.2K viewsMar 11, 2021
YouTubeDavid Langer
45:09
10 Advanced Excel Formula Examples | FREE Excel Course
195.7K viewsMay 8, 2019
YouTubeTrumpExcel
2:18
How to Recover and Repair Corrupted Excel File
647.8K viewsOct 23, 2017
YouTubeRay Tube Fixes
See more videos
Static thumbnail place holder