Automatically translated.View original post

わこ｜1分で学べるPC仕事術

7371 followers

Follow

Follow

Follow

168 saved

44

[Convenient Excel] Shortcut to calculate the total of each row and column at once!

@ wako _ pc _ work ← Overtime will be reduced by following!

Today I introduced a shortcut to calculate the total ◎

① Select all the tables

② You can calculate the total of the entire table with Alt + Shift + =!

Please try using it 🫶

- - - - - - - - - - - - - - -

[Self-introduction]

It's Wako!

At a major IT company, I develop apps and manage teams 💪

There is such a past.

Adaptation disorder due to working too much

Overtime is now less than 10 hours a month!

・ I was shaken by my boyfriend who I dated for 5 years

Let go of perfectionism and 😊

Meet a nice person and have a happy marriage 🕊️

These two things changed me when I was at rock bottom!

① Skill up

② Mind

We will deliver not only Excel, PowerPoint, Word but also mind and know-how to promote work easily 🫧

Nice to meet you!

Those who want to know more 👇

@ wako _ pc _ work

- - - - - - - - - - - - - - -

1/9 Edited to

Excelで大量のデータを扱う時、SUM関数を使って合計を計算するのは当然の方法ですが、たくさんのセルを選択していちいち関数を入れるのは意外に手間です。そこで、Alt + Shift + =のショートカットはとても重宝します。私自身も普段の仕事でこのショートカットを頻繁に使っていますが、表全体を選択して一発で合計が出るため、作業時間の大幅短縮につながりました。例えば、月次の売上データや経費の集計など、複数列や行の数値を足し合わせる場合、このショートカットは特に効果的です。ExcelのSUM関数と違い、関数の入力ミスの心配も減るので、ミスを防ぎたい人にもおすすめです。ショートカットを使う際は、まず合計を出したい表の範囲をしっかり選択することがポイント。私が最初に使った時は、操作がシンプルなのに大幅に時間が節約できるのが本当に驚きでした。また、Excel初心者の方にも操作が簡単なので、すぐにマスターできると思います。仕事術として覚えておくと、日々のExcel作業が快適になり、残業削減にも繋がるでしょう。エクセルの便利なショートカットを知ることで、単調な集計作業がスピーディーになり、よりクリエイティブな仕事に時間を割けるようになります。ぜひ、この合計を算出するショートカットを日常業務に取り入れてみてください。

Related posts

People always say… 👇😅 “Just start with Amazon affiliate marketing!” Sure, it’s simple to join — but the commissions are tiny. And if you’re already putting in the effort to create content, share links, and build trust… you deserve to be earning in a way that actually reflects that work.

95 likes

Excel Cheatsheet: 7/20:the ultimate excel shortcut

I discovered this amazing Excel Cheat Sheet that's been a game-changer for me. It's like having a secret weapon in my academic arsenal. 🧠 #excelspreadsheets #cheatsheet #dataanalytics

183 likes

Excel's Most Powerful Trick-Ctrl+E

📊 Welcome to Our Excel Mini-Class! 🚀 In today’s session of the Boost Your Excel Skills series, we’re unlocking the magic of Ctrl+E—your new best friend for saving time! ⏳ Whether you’re working with big datasets or just need to clean up information, this shortcut will help you instantly fill in

150 likes

"I know a shortcut."The shortcut: 💀🏎️

"I know a shortcut." The shortcut: 💀🏎️ Tag that one friend who shouldn't be allowed to sit in the front seat or the one you don't want to sit in the passenger seat with. AI generated using Sora #drift #rallycar #monkey #besties #chaotic

2 likes

Excel alpha sort

alt+ASS Excel alpha short shortcut #excel #exceltraining #exceltricks #exceltips #business #exceltutorial #spreadsheet

8 likes

Excel cheat sheet

Excel cheat sheet #excel #exceltips #exceltricks #exceltraining #tutorials #excel_learning

14 likes

Christmas Dessert Shortcut

EASY SANTA CLAUS OREOS! Whether you're holiday baking or making- save this Easy Christmas dessert! 1/3 dipped in white chocolate for Santa’s beard, 1/3 dipped in red candy melts for his hat with a marshmallow on the end, a red M&M for his nose, and chocolate chips for his eyes. #l

1644 likes

EXCEL SHORTCUTS PART 3

As requested, here is another excel shortcut post! Discovering the power of Excel shortcuts has been a game-changer for my productivity at work. These little keystrokes might seem insignificant, but they're the key to working smarter, not harder. From navigating vast datasets quickly to instant

331 likes

CarPlay shortcut

16 likes

The best in car apple shortcut!

#homefinds #homedecor #viral #lemon8viral

2991 likes

Turn your Apple Pencil into a Shortcut

#applepencil #goodnotes #ipadshortcuts #ipad #digitalplanning

286 likes

Excel's Secret Weapon: The Power of F4 Key! 🔄✨

💡 Welcome to Our Excel Mini-Class! 📈 In this session, we’re unveiling the magic of the F4 Key! Ever wished you could repeat your last action instantly? That’s exactly what F4 does—whether it's formatting cells, inserting rows, or adjusting formulas, one tap of F4 and you’re good to go! 🎉 Say

4 likes

A hand holds an iPhone displaying the Shortcuts app gallery, with a laptop and coffee cup in the blurred background. The image features the title '5 BEST HACKS ON SHORTCUT APP' and shows various starter and quick shortcuts.

An iPhone screen shows the 'Start Pomodoro' shortcut, with a notification indicating a 25-minute timer has started. The surrounding text explains how to enable this productivity hack through the Shortcuts app gallery.

An iPhone screen displays the Automation setup within the Shortcuts app, configured to trigger 'When I leave' a specific location. The accompanying text details how to set up location-based reminders.

5 Best Shortcut app hacks for iphone!

✨ Ready to level up your iPhone experience? Discover the 5 best hacks for the Shortcuts app! 1. Pomodoro Timer :Enhance productivity with a customizable Pomodoro timer that helps you stay focused and take breaks. 2. Reminders Before Leaving: Set location-based reminders to ensure you never forget

866 likes

Crème brûlée will forever be THAT dessert 🤍 Creamy custard + crackly caramelized sugar = pure happiness. This recipe makes 4–6 servings 🤍🍮 🛒 INGREDIENTS 2 cups (480 g) heavy cream 1 tsp vanilla bean paste 5 egg yolks ½ cup (100 g) granulated sugar Pinch of salt Extra sugar (for torch

18 likes

Unlock Excel's Secret Weapon with One Shortcut! ✨

💫 Welcome to Our Excel Mini-Class! 🥳 Today's session is all about the magic of Ctrl + E ! Are you tired of manually filling in data or looking for a faster way to complete tasks? Well, I've got you covered with a quick tip that'll make you a productivity pro. 💼✨ With Ctrl + E , you

421 likes

Easy Shortcut Lasagna

Yummy easy shortcut lasagna #lasagna #easyrecipeideas

53 likes

Excel Magic: 5 Ctrl Shortcuts to Save Your Time 💫

✨ Welcome to Our Excel Mini-Class! ✨ Attention, productivity pros! 🔥 Excel isn’t just a tool; it’s your secret weapon for working smarter, not harder. Today, let’s dive into 5 essential CTRL shortcuts that will save you time and impress your coworkers! 💼✨ 💡 CTRL + 1: Bold text! 💡 CTRL + 2:

20 likes

How did the Wall Street Journal get that letter? #news

18 likes

This shortcut just changed how I use my iPad 🤯 

I created one shortcut with 3 setups — and now I can open everything I need in one tap. No more switching between apps or wasting time setting things up. I’m using it for: • Finance • Planning • Journaling Each option opens my planner in goodnotes + the exact apps I need — like Apple Ca

111 likes

What do you use for inflammation??

0 likes

A woman takes a mirror selfie, holding a coffee cup and phone, with text overlay 'EXCEL SHORT CUTS SAVE TIME & FRUSTRATION PART 1'. Abstract shapes frame the image.

A beige graphic slide explains the Excel shortcut 'SHIFT + END + DOWN' for selecting an entire column or section of data, with a 'SWIPE' indicator.

A brown graphic slide details the Excel shortcut 'CTRL + A' which selects all data in a worksheet, accompanied by a 'SWIPE' instruction.

EXCEL SHORTCUTS

These excel short-cuts are just a few that have made my excel work take a fraction of the time and genuinely changed my work life!! Working in excel can be extremely frustrating when not using the tool efficiently. Here are some crucial shortcuts to enhance your experience with Excel. CTRL + A

2586 likes

Stop looking for a shortcut that doesn’t exist. You can’t "hack" your way into a body or a mindset that requires consistency. The diet and the workout requires all of you. It’s not about the one day you felt motivated; it’s about the 100 days you didn’t, but you showed up anyway. #gymtok #gym

24 likes

Want the shortcut to lose weight?

Want the shortcut to lose weight? Here’s 7 years of hard lessons packed into a 40-second secret 🏆 ✅ At every meal, start with 1-4 palms of protein. Good examples are lean chicken, lean ground beef, etc This is going to make sure that you’re retaining as much muscle as possible while yo

45 likes

A MacBook Air displays the Canva interface with an open book graphic. Overlaid text reads "secret codes for kawaii Canva Elements part 8" and the Canva search bar shows "set:nAEvl2T0Br4".

A Canva search results page for "set:nAEvl2T0Br4" showing various kawaii book and apple graphics. The page is labeled "TECH TIPS & TRICKS" and "free".

A Canva search results page for "set:nAEwhl-1rqE" displaying various kawaii magical and cosmic-themed graphics, including butterflies, crowns, frogs, and unicorns.

This Canva Shortcut Will Save You SO Much Time! ⏳

Why spend forever searching for elements when Canva has secret codes to do the work for you? 🎨 These codes take you directly to curated collections of icons, graphics, and stickers—so you can design smarter, not harder! 📌 How to Use: Copy a code, go to Canva, open the Elements tab, paste it int

237 likes

The part they don’t tell you about numbing the pain is that you can’t selective-numb. When I stopped feeling the hurt, I also stopped feeling the love, the excitement, and the hope. I thought I was taking a shortcut to peace, but I was actually just locking myself in a room with no windows. Recove

0 likes

This shortcut turned my planning into a whole vibe

With iPadOS 26, multitasking feels more like a laptop — so I’ve been creating shortcuts to make planning effortless. In my last video, I showed how to build a one-tap planning shortcut. Today I’m editing it: swapping Reminders for Spotify so I can plan with music. 🎶 With one tap, my shortcut ope

298 likes

50 Excel Shortcut Keys

Check out these 50 Excel shortcut keys to boost your productivity! I hope this list helps you work more efficiently :) If you want to learn the best time-saving Excel tips, check out my Instagram: @excel.withgrant

41 likes

PLUG & PROFIT BUNDLE – Your Shortcut to Digital M

Ready to start making money online but don’t know where to begin? The Plug & Profit Bundle is your all-in-one toolkit to launch and grow your digital marketing business—even if you’re a total beginner! ✅ Done-for-you digital product (sell it as is or rebrand it as your own!) ✅ Crash Course

1 like

Sewing shortcut

$9 Sewing short cut to create ruffles (or gathering)! This thing is a massive time saved! #sewing #diycrafts #sewingfinds #amazonfinds #crafting

12 likes

Why Do Smell Triggers Instant Memory? What’s the one smell that takes you back? Discover why scent and memory are linked. Unlike other senses, smell triggers the limbic system directly. This olfactory bulb shortcut creates an emotional response and instant nostalgia, acting as a primal switch

1 like

Busy mornings? This is your shortcut to flawless.

Busy mornings? This is your shortcut to flawless. 💄 Our Two-Way Perfection Brush is designed to do it ALL — the larger end melts in foundation and cream products, while the smaller end gives you the perfect blush, contour, and bronzer placement. Less tools, faster glam, better results. Shop her

0 likes

My Go-To Mexican Street Corn Shortcut

This is what I make when I want that street corn flavor without the grill. The charred canned corn gives you that same smoky bite and the creamy lime sauce pulls everything together. It’s simple but it always hits and disappears fast in my house. Pro Tip: Drain your corn really well and let it

12 likes

Making money: the easy way 📲

How to make money online without showing your face 🙈 This is called affiliate marketing and over 80% of brands all over the world have this type of program and they will pay you to talk/share about their products online. (Without being an influencer) It's a great way for ANYONE, busy pare

2 likes

your shortcut to tiktok views ✨

you don’t need trending sounds or dance cuts. you need an opening line that stops the scroll. —— 1. the “this is for you if” hook filters the right audience instantly. “this is for you if you’re building a brand but have no idea where to start.” specific > viral. people stay when the

32 likes

Google’s Hidden Upgrades Are Rolling Out Quietly We explore a secret shortcut to unlock new Gemini voices in Google Home, discuss changes to Google Weather and Keep reminders, and highlight updates to Google Messages link previews. #GoogleHome #GeminiVoices #TechTips #GoogleAssistan

0 likes

Replying to @catalyst I will be posting more for fonts/ keyboard, cover screen as well as the customizing the battery status #fyp #motorolarazrflip #customizephone #themepack #coverscreen

7 likes

Google Sheets is your underrated superpower

If you’re a student, creator, or just spreadsheet-curious… Google Sheets is your underrated superpower, if you know the right shortcuts. Here are my favorite time-saving, brain-soothing hacks: – ⌘ + Shift + V (or Ctrl + Shift + V): paste without formatting chaos – =SPLIT(A1, ","): s

17 likes

Moments With Dayodman #dayodman #motivation #eeyayyahh #motivationalspeaker #positivity

1 like

Bend But Never 👎 Fold, We Don’t Break Under Pressure, (Like Heat Treated Steel) Tough

#mexicoamericano🇲🇽🇺🇸❤️corazon❤️ranchero #purocorazon❣️ #trabajandoduro #reflexaododia #dolor

0 likes

Everyone wants the shortcut to fat loss but which ones actually work? In this episode, I hand-picked some segments with my go-to experts to unpack the truth about calories, macros, resistance training, supplements, and even GLP-1 drugs. Save this one for when you need a reality check on fat l

0 likes

Build your 🍑not your bill! Consistency >shortcut

1. “Hip thrusts = booty magic 🍑✨ Add weight, go slow, and feel the burn!” 2. “Squats are great, but don’t skip deadlifts! 🍑 Build strength and shape naturally.” 3. “Eat your protein! 🥩🍳 Glutes grow when you fuel them right!” 4. “Progressive overload = growth! 📈 Kee

8 likes

Just a few facts about Dry Pixie Molds.🤭 •Dry molds be so satisfying to do and to watch. •It comes out so slick when you dry mold it! •Another perk when dry molding is that it drys 2X faster than a wet mold #shortcut #pixiecutblackwomen #relaxedpixiecut #pixiecutinspo #usa🇺🇸

308 likes

✨Monday’s Budget Meal✨Shortcut Chicken Pot Pie 🥧

Happy Monday! This is gonna be my first time making this recipe so I just winged it. I knew because it was Monday. I wanted to be quick,easy, and without a fuss so this was the recipe for me. I love chicken pot pie, but I don’t like to make an individual, and I don’t like to make it with all the lo

275 likes

Hearty Vegetable Soup (Meat + Vegetarian Option)

This vegetable soup is one of my favorite light, nourishing dishes 🤎 It’s simple, hearty, and packed with natural ingredients that leave you feeling full without feeling heavy. I love finishing it with fresh parsley on top it adds so much flavor and is rich in nutrients that support overall w

10 likes

See more