Automatically translated.View original post

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

7756 followers

Follow

Follow

Follow

172 saved

33

[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

The best in car apple shortcut!

#homefinds #homedecor #viral #lemon8viral

3020 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

1648 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 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

242 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

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

332 likes

A MacBook displays a budget spreadsheet, while an iPad in front shows a debt payoff dashboard. Overlay text announces a hack to control the iPad with the Mac, highlighting the dual-screen setup.

A MacBook screen shows a spreadsheet with a 'Display' menu open. An arrow points to 'Susan's iPad' under 'Link keyboard and mouse to', illustrating the first step of connecting devices.

The MacBook screen displays system settings, showing 'Displays' with icons for 'Susan's iPad' and 'Susan's MacBook Pro'. The image highlights clicking 'Display Settings' and then 'Arrange' for setup.

👇👇👇 Easy MacBook & IPad Hack

Everyone knows an IPad is incredibly powerful as this, but when paired with a MacBook, it can do a lot more. I’m very much deep into the Apple and IOS ecosystem, so here is another hack with both MacBooks and IPads that’s 10x more useful than “Screen Mirroring”. Apple doesn’t have a specific na

1522 likes

High Protein Creamy Chicken Salad

High Protein Creamy Chicken Bowl Simple, fresh, and filling! Calories 386 Protein 45.3g Carbs 4g Fat 18.8g Ingredients 5 oz grilled chicken 2 mini cucumbers Handful of cherry tomatoes 1 tablespoon mayo Salt Pepper Optional Feta cheese Notes You can use pre-cooked grilled c

713 likes

Excel cheat sheet

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

14 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

868 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

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

2583 likes

A flat lay image featuring an iPad, a MacBook, and AirPods on a desk, with the title 'HOW TO GET THE MOST Out of your iPad!' in pink text. Decorative hearts and sparkles are overlaid.

A graphic listing 'THE BEST IPAD APPS' including Goodnotes, Notability, Canva, Noteful, Notion, Affinity Photo, Procreate, and Things 3, each with an icon and a brief description, set against a desk background.

A graphic detailing 'MUST HAVE IPAD ACCESSORIES' such as a case (shown with a pink heart design), a screen protector, and an iPad Pencil, with descriptions for each, against a laptop and iPad background.

How To Get The Most Out Of Your iPad!

Hey, Gorgeous! Unlock Your iPad’s Full Potential! Are you ready to take your iPad game to the next level? 🌟 Join me on a fabulous journey as we dive into the best apps, must-have accessories, and creative digital planning tips that will make your iPad your new BFF! Let’s start with my favorite

1440 likes

Mini Chicken Pot Pie Cups (Comfort Food Shortcut)

Love chicken pot pie but hate the long cooking time? These mini pot pie cups are the shortcut version. Ingredients: • shredded chicken • frozen vegetables • cream of chicken soup • biscuit dough Steps: 1️⃣ Mix chicken, vegetables and soup. 2️⃣ Press biscuit dough into muffin ti

13 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

An office cubicle desk with a computer monitor, keyboard, and various personal items, including framed photos and plants. Overlay text reads 'How to List Items within one Cell in Excel', introducing a productivity tip.

A screenshot of Microsoft Excel showing a cell with '1) hello'. Text explains that pressing 'Enter' moves to the next cell, and introduces the 'ALT - Enter' shortcut to add a new line within the same cell.

A simplified Excel view demonstrating a single cell containing a multi-line list: '1) hello', '2) Hi', '3) Howdy'. Text confirms this is the result of using 'Alt - Enter' to create a list of steps within one cell.

HOW I LIST MULTIPLE LINES IN ONE CELL - EXCEL

I've discovered how to list out several items by line in a single cell by using the Alt-Enter key shortcut. I can now structure my spreadsheet in a more ideal way with this ability, and keep data that belongs together in the correct rows. I select the cell I want and type the first item. Then,

406 likes

Excel alpha sort

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

8 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

An iPhone settings screen showing various options, with 'Accessibility' highlighted, indicating the first step to access vocal shortcuts.

An iPhone accessibility settings screen, with 'Vocal Shortcuts' highlighted, showing where to find the feature to customize voice commands.

A screen titled 'Set Up Vocal Shortcuts' with a blue microphone icon, explaining that users can choose an action and record a phrase.

IOS 18 Shortcut !!!!

Did you know you can use vocal shortcut to give Siri a new name??? Feel like being creative or funny? This hack is super neat and I will 100% be giving my Siri a funny name. You can use the shortcuts to access anything but this one is my favorite for sure. Here’s the steps : 1) Settings> A

2553 likes

Use this shortcut if you wanna make money on Etsy

Make more sales on Etsy using PLR products! First when you join the First Class PLR membership you’ll get instant access to a bunch of pretty PLR products that you can make your own and resell on Canva. You should definitely get started as soon as possible because the holidays are right around the

10 likes

This is a Shortcut

The center you can remind yourself that “you are where you are, and it is what it is.“ You will get to where you want to be despite where you think you’re going. #WellnessJourney #HolisticHealth #QuantumHealing #Mindfulness #MentalHealthAwareness

1 like

Your Shortcut to Starting Digital Marketing

That’s exactly why I created my done-for-you beginner guide ✨ Inside, I break down: • what digital marketing actually is • different ways people make money online • how MRR + PLR products work • how to set up your storefront + email list • beginner-friendly systems that save time AND the

0 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

35 likes

The beginner creator shortcut nobody talks about

I thought PR was only for huge influencers until I found this 😭 #influencerstyle #influencercommunity #influencerpr #influencerhelp #fypシ゚viral

0 likes

A screenshot of an iPhone shortcut titled 'Line Swap', displaying steps to find an active cellular plan that is not the current data line, then setting it as the default data and voice line. The image includes a Lemon8 watermark.

Create this shortcut and you will be able to swap between lines at will! It’s super convenient!! #iPhone #ios #shortcut #iphone17

4 likes

CarPlay shortcut

19 likes

Must-Know Excel Tip for Busy Days! ⏰ 🥰

✨ Welcome to Our Excel Mini-Class! 📈 In this session, we’re unveiling the magic of Text to Columns! 🤓 Have you ever had a long list of data all in one cell and wished you could separate it into neat, organized columns? Well, now you can—with just a few clicks! 🔥 No more messy data or manual cutt

4 likes

A green and white graphic titled 'Master Simple Excel Operations', listing five basic Excel tasks: creating a workbook, entering data, adjusting column/row size, inserting/deleting cells, and using functions.

A graphic titled 'Keyboard Function Key Identification' showing a white keyboard layout and a table identifying common keys like Esc, Tab, Caps Lock, Shift, Ctrl, Alt, Enter, Backspace, Sleep, and Wake Up.

Getting Started with Excel: It's Really Simple!

We'll start with the basics, learning about Excel's interface, toolbar, cells, and other fundamental operations. Then, we'll move on to common office shortcuts, as well as some frequently used functions and formulas. #ExcelBasics #ProductivityTips #SpreadsheetSkills #Exce

40 likes

Master Excel with CTRL + Series Shortcut! 📊✨

👉 Welcome to Our Excel Mini-Class! 💡 Hey, Excel warriors! 💪 Ready to level up your Excel skills and work faster? Today, I’m sharing some essential CTRL shortcuts that will make your life soooo much easier. Whether you're a student or a professional, these are game-changers! 🏆✨ ✨ Pro Tip:

1 like

Journal: Angela 2 of 3

Part 1 — The Shuttle The shuttle smelled like wet coats, coffee, and exhaustion. Outside the windows, snow slammed sideways beneath airport floodlights while Newark slowly disappeared behind waves of white. Every few seconds the tires slid softly across slush before catching pavement again, m

1 like

A pink mechanical keyboard with glowing keys, displaying the text "WINDOWS SHORTCUTS FOR PRODUCTIVITY" on a pink background with yellow wavy lines and red hearts.

A pink mechanical keyboard with text overlays listing Windows 11 shortcuts: Hold Alt to search open windows, Alt + Tab to switch windows, Ctrl + N to open a new window, and Ctrl + W to close the current tab.

A pink mechanical keyboard with text overlays for Windows 11 shortcuts: Alt + D to select the address bar and Ctrl + E to select search, enabling typing without a mouse.

💿 Windows 11 Shortcut Hacks

Here are some shortcuts you may not know of in Windows 11. I omitted the most basic ones (copy, paste, etc). I hope you learn something new and remember - it will take you longer to use them at first. Once the shortcuts are part of your routine, you’ll be lightning fast. ⚡️ These may or may

83 likes

A digital notebook page displays Matthew Chapter 1, detailing Jesus' genealogy from Abraham to Joseph. Handwritten notes highlight Matthew as a tax collector and disciple, and Jesus' connection to important Old Testament figures like David and Abraham, emphasizing the royal and Abrahamic lines.

A digital notebook page shows Matthew Chapter 1, continuing Jesus' genealogy and the account of His birth. Annotations explain that Luke details Jesus' birth, while Matthew focuses on Joseph's lineage. Notes also describe Mary's pregnancy as a supernatural miracle and Joseph's obedience.

A digital notebook page presents Matthew Chapter 2, describing the Magi's pilgrimage to find Jesus. Annotations discuss the Magi's remarkable journey, Herod's deceitful plan to eliminate Jesus, and the symbolic gifts of gold, frankincense, and myrrh representing Jesus' royal status, divinity, and future suffering.

matthew 1-3 notes + journaling ❤️📝💌💚

#biblejournaling #biblestudynotes #biblestudy #christian #digitalnotes

132 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

300 likes

Easy Shortcut Lasagna

Yummy easy shortcut lasagna #lasagna #easyrecipeideas

62 likes

The image displays fresh green aloe vera plant leaves with visible water droplets at the top. Below, a text box provides a beauty tip: 'DID YOU KNOW? First place a warm towel on your face for 10 minutes. Now do massage with aloevera for 5 minutes and wash. It will give you a crystal clear glass skin in no time.'

Aloe vera: Your shortcut to glass skin. ✨

#glasskin #Aloevera #beauty #selflove #healthylifestyle2024 #foryoupage #Lemon8Diary #tiktok

30 likes

Gratitude Is the Shortcut to Peace

Gratitude is the shortcut to peace. You can’t feel miserable and grateful at the same time. The moment you start focusing on what’s still good, your whole energy shifts. You begin to notice the little things again — and that’s where peace lives. Gratitude doesn’t fix everything — but it

2 likes

A shortcut to perfect party slices! 🍰✨

A shortcut to perfect party slices! 📸 duckieconfetti #CakeCuttingHack #cakestyling #cakeslices

3584 likes

A shortcut to learn tattooing

Really wish I knew about these pens from the start 🫥🫠😭 #asmr #artchallenge #arttips #tattoolife

13 likes

A silver MacBook Air is open on a wooden table, with text overlayed that reads, 'you need to save this MacBook setting hack.' A white blanket is visible in the background.

A MacBook screen displays the 'Hot Corner Shortcuts' settings within System Preferences, showing options like Launchpad and Start Screen Saver. Text overlay instructs to search for 'hot corner shortcut' and customize actions.

A close-up of a MacBook screen shows the Finder menu bar. Text overlay explains that hovering over the corners will automatically complete the chosen actions.

the best MacBook shortcut?! 🤭

Here's a little tutorial on how to setup hot corner shortcuts for your MacBook Air! This feature makes it so easy to quickly use a variety of actions on your MacBook (all you have to do is hover your mouse over the corner)! Let me know if you want to see more Apple device shortcuts 🩵 #le

478 likes

If you grew up waiting for the ice cream truck jus

If you grew up waiting for the ice cream truck just for that Strawberry Shortcake bar... this is for you. 🍓🍦 Those nostalgic strawberry shortcake bars from the ice cream truck are a classic for a reason—that crunchy, salty-sweet crumble is addictive. Making "bites" at home is actually v

11 likes

A laptop screen shows a Google search for 'CLEP' with an overlay asking if a $97 test can replace a college class, highlighting the search bar.

A laptop screen displays the CLEP College Board website, showing 'Earn College Credit with CLEP' and options to register for an exam, with an overlay explaining CLEP as taking one test for college credit.

A laptop screen shows the CLEP website listing various 'History and Social Sciences' exams, including American Government and Introductory Psychology, each priced at $97, with a 'History & Social Sciences' overlay.

CLEP Tests Are My Girl Era Shortcut to Credits 🎀

Okay so I went to get my eyes checked… and somehow walked out with a shortcut to college credit 😭💅🏻 My eye doctor randomly told me about this site called CLEP — it’s basically a $97 exam you can take instead of doing an entire class. No Zooms. No professor. No group project trauma. Just pa

26 likes

See more