Automatically translated.View original post

ひろ | 定時退社のExcel時短術

22.1K followers

Follow

Follow

Follow

60 saved

11

Tabulation is a super time saving technique

How to create a table

① Select the whole table with CtFD45A7

② Table with Ctrl + 5T

Please use it! 🤩

2025/8/12 Edited to

Excel のテーブル機能は、ただ表を整理するだけでなく、データ分析や管理を劇的に簡単にするスグレモノです。特に事務職の方々には手放せない時短テクニックです。テーブル化すると自動でフィルター機能が付き、商品の売上や日付ごとに簡単に並べ替えや絞り込みができます。私の場合、毎日の販売データをテーブル化してから作業時間が大きく短縮されました。例えば、2025年7月の果物別売上データを一瞬で抽出して分析可能になりました。また、テーブルデザインタブからスタイル変更が自由自在にできるため、視認性の高い表も簡単に作成できます。空白セルの結合や中央揃えの配置も組み合わせれば、きれいで分かりやすい社内資料が短時間で完成します。さらに、テーブル化した範囲は数式の入力も楽になり、VLOOKUPやSUMIFなどの関数を使う際に指定範囲の変更が不要になってミスも減りました。私の経験からも、Excelのテーブル化は初心者でもすぐに使いこなせる効果的な技術といえます。これからも定時退社を目指す人に是非おすすめしたい機能です。ぜひCtrl+Tを駆使したテーブル化を使って、あなたの仕事も驚くほど楽にしてくださいね！

Related posts

A study setup featuring a tablet displaying apps, a pink drink in a clear cup, pens, and a notebook with handwritten notes. The image is overlaid with the text 'Lazy Girl COLLEGE HACKS' and 'GET A HIGH GPA WITHOUT TRYING SO HARD'.

A student in a lecture hall, seen from behind, attentively listening to a professor. Yellow arrows point from the student's head towards the professor, emphasizing focus on the lecture.

An open spiral-bound textbook with colorful tabs and highlighted sections, illustrating the concept of skimming. A yellow arrow points to a specific page.

Lazy Girl College Hacks: 9 Tips for a Higher GPA📚🎓

Yes, I know “why is Chalie posting college content?” I’m here mainly for fitness advice and everything health-related, but I’m also a lifestyle account—and a big part of my life is being a college student and let’s be real—college can be overwhelming, especially when it feels like there’s a never-e

7454 likes

50 Habits That Quietly Change Your Entire Life

Most people think their life changes through one big moment. One breakthrough. One opportunity. One burst of motivation. But if you really study people who become healthier, calmer, wealthier, disciplined, emotionally stable, attractive, focused, or successful… it’s usually the opposite. The

1537 likes

The image features a dance studio with a dancer, overlaid with a pink cloud containing the title "Tips for dancers who want to Improve Fast!". Colorful cartoon dancers are also present.

A dancer sits on the floor of a studio, recording herself in a mirror, illustrating the tip "Video yourself practicing" to improve technique and track growth.

A group of people in white hooded suits and sunglasses pose, accompanying the tip "Take class/ Dance with dancers you look up to!" to learn from others in the community.

Tips for Dancers who Want to Improve Fast!

#dance #dancer #selfimprovement #danceimprovement #professionaldancer

340 likes

An open textbook with a stethoscope and floral sticker, overlaid with text 'APPS ALL STUDENTS SHOULD HAVE DOWNLOADED' and '#studywithme', suggesting essential study tools.

A screenshot of the Apple App Store page for Zotero, showing its icon, 4.7-star rating, and in-app views of its research organization and citation management features.

A screenshot of the Apple App Store page for Clockify Time Tracker, displaying its icon, 4.6-star rating, and in-app views of its time tracking and timesheet logging functions.

The best study apps for nursing students 🫶🫶🫶

Reach your academic goals through These apps! They are perfect for busy back to school students! As this next semester starts, it is time to set up your study supplies fora successful spring semester! ⏰ Zotero ~ a powerful and user-friendly reference management tool that simplifies the research

1156 likes

Language Study Template (Notion) - Part 2 Tutorial

✨Perfect for Chinese learners (but work for any language too). Start your language study journey today with structure, creativity and motivation all in one place. Download now at 🛒missydizzy.gumroad.com #notiontemplate #studytemplates #chineselearning #notionstudent #learnlanguage

2 likes

A student's desk with a MacBook Air displaying a calendar, a pencil case, and lip balm, illustrating a setup for focused studying.

A MacBook Air shows virtual study space interfaces like 'I Miss My Cafe' and 'i miss my library,' offering ambient sounds to aid focus during study sessions.

A MacBook Air displays a Pomodoro timer and study notes, alongside a water bottle, demonstrating the Pomodoro technique for focused study with timed breaks.

how to: stay focused while studying ✏️🌱🎧

how to: stay focused while studying ✏️🌱🎧 as i approach midterms season, i’m relearning how to study for long periods of time. most of my exams habe been pretty spaced out so far but i have three midterms coming up that are all in the same week! i’m bringing out all my study techniques to make su

1279 likes

A large, ornate study hall or library with wooden tables and chairs, and chandeliers. Overlayed text reads: "From 2.4 to 3.2 GPA: My Top Essay-Writing Hacks for Academic Success!" with a Lemon8 watermark.

Text overlay on a blurred background, titled "1 Understand the Prompt Inside-Out." It advises dissecting essay questions, highlighting key terms, and asking professors for clarification to save time. A Lemon8 watermark is visible.

Text overlay on a blurred background, titled "2 Research Smarter, Not Harder." It describes using Knowee AI to summarize articles by highlighting sections, with a screenshot of the Knowee AI interface below. A Lemon8 watermark is present.

My Top Essay-Writing Hacks for Academic Success!

Improving my GPA from 2.4 to 3.2 was all about refining my approach to essay writing. I learned that understanding the essay prompt, researching efficiently, and creating a solid outline are key to staying focused and organized. Writing the first draft without aiming for perfection, then editin

26 likes

A desk setup featuring a tablet displaying Google Calendar and a MacBook Air showing Notion Calendar, illustrating a comparison between the two digital planning tools.

A MacBook Air screen shows Google Calendar, highlighting its primary function for scheduling events, meetings, and tasks, as described in the accompanying text.

A MacBook Air displays Notion Calendar, emphasizing its integration with Notion for project scheduling and its ability to sync with other calendars like Apple or Google Calendar.

google calendar vs notion calendar 🗓️🎧💖

google calendar vs notion calendar 🗓️🎧💖 i’ve been using google calendar since high school, and switched over to notion in the beginning of the year! i’ve been able to play around with notion calendar a lot and wanted to share some differences between the two platforms so you can choose what’s be

280 likes

A split image comparing Google Drive/Sheets on the left monitor and Notion on the right, with text asking whether students should use Google or Notion for organization.

A desk setup with a monitor displaying Google Drive, alongside text explaining a preference for Google's flexibility over Notion for student organization.

A monitor displaying Notion, with text overlays detailing its uses for students, including semester planning, study schedules, notes, assignment tracking, and digital filing.

Student; Notion or Google Sheets?

📊 If it’s not organized, it’s not getting done. I built a whole system in Notion to track my classes, apps, MCAT, and even my habits… and honestly? It changed everything. Google Sheets helps me plan my week by energy, not guilt. 💡 Use templates to save time 💡 Add emojis for quick scanning 💡 Al

96 likes

A black and white graphic titled "HOW TO GET MY LIFE TOGETHER (aspects of life)" with a small image of Rihanna. It lists tips for Diet & Exercise, Career & Education, Finances, Social Connections, Personal Development, and How to Stay Organized.

A page titled "IMPROVE THESE 3 AREAS IN YOUR LIFE" detailing advice for career, finances, and relationships. It features images of a person working on a laptop and another person holding a bag.

How To Get Your Life Together💅🏼

The feeling of not being able to clear your to-do is frustrating. Instead of working through your overwhelm without a plan, take a step back and consider how to get your life together in a reasonable, healthy way. Here’s how to apply some of these tips into your daily routine: 1. Be Honest With

1466 likes

tour my daily planner in notion! 🥰✨

hi friends! i’ve started to get back into using notion to try to help me get back into a normal routine of things. i definitely find notion difficult to use at times, but i am starting to get a little more used to using it! as of right now i’m keeping my notion page extremely simple so i don’t

153 likes

The image displays the first 17 points of "175 POINTS NURSING MUST KNOWS," covering essential nursing practices like documentation, patient assessment (PERRLA, pulse, respirations), injection techniques, fluid balance, and foundational nurse-patient relationship principles.

This image presents points 18-35 of "175 POINTS NURSING MUST KNOWS," detailing legal and ethical aspects of nursing (malpractice, negligence, Good Samaritan Laws), patient rights, health record management, controlled substances, nursing diagnoses, care planning, and maintaining sterile technique.

The image shows points 36-55 of "175 POINTS NURSING MUST KNOWS," including guidelines for ear care, patient identification, activities of daily living, physical assessments (gaze, heart murmurs), postmortem care, dietary considerations, and specific injection techniques and needle sizes.

🩺 175 Things Every Nurse Should Know! 💉🧠

your journey or you’re a seasoned nurse, these 175 essentials will boost your confidence, sharpen your skills, and make every shift smoother. From quick clinical facts to time-saving hacks, this list is your go-to survival guide! 💪✨ 📌 Save this post for later — you’ll thank yourself during your

499 likes

The image displays the xTiles daily planner interface, showcasing a customizable dashboard with sections for goal mantras, main goals, weekly habits, skills, and important notes, emphasizing its aesthetic and user-friendly design as a Notion alternative.

This image highlights the xTiles template gallery, offering various pre-filled templates like daily schedules, weekly planners, and personal planning layouts, allowing users to start from scratch or use existing designs.

The image demonstrates the tab feature in xTiles, showing how users can add different tabs for organization and freely add and resize tiles anywhere on their board for flexible customization.

My aesthetic xTiles planner, Notion alternative!

If you’re looking for a more aesthetic and flexible alternative to Notion, check out xTiles! With xTiles, you can organize everything exactly how you want, making it super personalized and visually pleasing. Whether you're creating vision boards, planning your week, or just organizing your

462 likes

10 Manifestation Techniques Backed by Science 🌸

Hi, Lemon drops! Have you ever felt that your dreams are just out of reach, no matter how hard you try? What if there was a way to unlock your potential and bring those dreams closer to reality? Manifestation is a powerful concept that has gained popularity in recent years, promising to help indivi

20 likes

The image shows a spacious, ornate study hall with large chandeliers, wooden tables, and students. Overlay text reads: "From 2.4 to 3.2 GPA: My Top Essay-Writing Hacks for Academic Success!"

The image features a blue background with the heading "1 Understand the Prompt Inside-Out." The text advises dissecting essay questions, highlighting key terms, and asking professors for clarification.

The image displays a blue background with the heading "2 Research Smarter, Not Harder." It explains using Knowee AI to summarize articles and shows a screenshot of the Knowee AI interface.

My Top Essay-Writing Hacks for Academic Success🌟

Improving my GPA from 2.4 to 3.2 was all about refining my approach to essay writing. I learned that understanding the essay prompt, researching efficiently, and creating a solid outline are key to staying focused and organized. Writing the first draft without aiming for perfection, then editing la

8 likes

A flat lay shows a meal in a bowl, a journal, a pen, a candle, and a plant, with text overlayed: 'Time-Saving Hacks Every Mom Needs!' and icons representing time management.

An iPad on a stand displays its home screen with various apps. Overlaid text explains '1 Start with a Simple, Realistic Plan,' detailing using a planner and the 3-Task Rule.

The back of a silver MacBook is visible. Overlaid text states '2 Time Block & Batch Tasks,' explaining scheduling chunks of time and batching similar activities.

Time Management Tips for Moms ✨

Managing time as a mom can feel impossible, but with the right strategies and mindset, you can stay on top of things without burning out. Here’s how: 1️⃣ Start with a Simple, Realistic Plan 📅 Use a Planner or Digital Calendar – Write down appointments, kids’ schedules, and to-dos so nothing g

135 likes

Build better habits with this Notion Habit Tracker

I started using this Notion Habit Tracker to organize my daily routines, and it has made staying consistent so much easier. Instead of feeling overwhelmed by big goals, I can now: 🌿 track my habits every day 📊 see my progress visually 🎯 stay focused on what matters 💡 build routines that actu

16 likes

A savings challenge grid showing various dollar amounts from $10 to $160, aiming to save $2,000 in 30 days. It includes fields for 'Saving For' and 'Goal Date'.

A savings challenge grid with amounts from $10 to $160, illustrating how to save different amounts daily. Checkmarks indicate $10, $11, and $12 have been saved.

A budget template section for savings goals, showing an 'Emergency F.' of $500 and 'Vacation' of $500, demonstrating how to set monthly savings targets.

How to save 2,000 in 30 Days 💸

Steps: 1. Pick a square each day 2. Save the amount listed 3. Watch your savings grow to 2,000 in one month — You can also try a budget template, type in your savings goal for the month. Then set up auto transfers from your paycheck each month towards your savings goals. Have you trie

408 likes

cross cut technique || kitchen tip

Today, I’m here to share a time saving kitchen hack that will save you time and effort when it comes to chopping cherry tomatoes! 🍅💥 Introducing the “Crossed Cut Technique”! 😮🔪 All you need are two plastic container lids and a serrated knife. Here’s how it works: Step 1️⃣: Grab your cherry to

29 likes

An iPad in a pink composition book-style case with a pink stylus, white headphones, and a white tube on a wooden surface. The image has text overlayed: '5 WAYS TO USE YOUR IPAD'.

An iPad displaying a digital journal entry titled 'MISSING THE HOMELAND' with various images, text blocks, and a music player widget, set against a dark background with calendar months at the top.

An iPad displaying a font creation interface. The screen shows an alphabet, a large 'A' being designed with grid lines, and tools at the bottom, under the title 'CREATE YOUR OWN FONT'.

5 (more) ways to use your iPad 👩🏻‍💻✍🏻💕

You guys seemed to like the last post, so here are some more ways to use your iPad! ☺️✍🏻💕 1. Digital journaling: turn your iPad into an art journal, junk journal, diary, scrapbook… it is so versatile!! Not only are you saving paper, but you’re also getting to unwind and be creative ✍🏻💕 2. Cre

27.8K likes

NOTION TOUR ✨how I stay organized w/ notion!

welcome to my notion! I use notion for literally EVERYTHING. it’s a fantastic tool to stay organized with. while notion can feel a little overwhelming at first, templates are a great way to get started. here’s a lil overview of my page: • directory page - I use this page to quickly acces

59 likes

Time-saving techniques for busy entrepreneurs

You can reclaim your calendar and crush your goals. Here’s how: 1️⃣ Time Box Every Task - Set strict time limits to conquer procrastination. 2️⃣ Schedule Everything - Yes, even breaks. No time gets wasted. 3️⃣ Find Your Focus Windows - Use your peak energy times for high-impact tasks.

60 likes

A graphic with the text "GETTING THROUGH NURSING SCHOOL ONE MELTDOWN AT A TIME" in red and black. It features red hearts, medical crosses, and syringes, symbolizing the challenging yet dedicated journey of nursing students as described in the article.

How to study for nursing school

📚✨ Nursing School: Where Coffee is a Food Group and Sleep is a Myth 💉👩‍⚕️👨‍⚕️ Behind every nurse is a story of sleepless nights, early mornings, clinicals that test your patience, and exams that test your sanity. But also — moments of breakthrough, the first time you hear heart sounds, the first

57 likes

A scenic road through a forest with "HELLO, August" and "Monthly Reset!" overlaid, serving as the title image for a guide on monthly resets.

A person's legs and feet dangle over calm water, reflecting city buildings and trees, illustrating the first step of a monthly reset: "Reflect on the previous month."

A four-panel cartoon illustrates the importance of a "brain dump," showing a figure stuck in a head, then turning on a lightbulb to make it a "nice place to be."

‼️How To Monthly Reset‼️ In 7️⃣ Steps 📌

Step 1️⃣: Reflect on the previous month by asking yourself: 📌 What went well last month ? 📌 What didn’t go so well or could be improved ? 📌 Did I achieve my goals & intentions ? Step 2️⃣: Brain Dump: WRITE IT OUT 📝 Journaling is a great way to keep track of what’s going on i

36 likes

A laptop displays a Notion template for tracking Stardew Valley Community Center bundles, featuring item checklists, bundle categories, and Stardew Valley-themed graphics like corn and gift boxes. The screen shows various items and their associated bundles.

A close-up of the Notion template shows the 'SDV: Bundle Items' section with a search function highlighted. Checkboxes next to items like Potato and Tomato indicate that checked items disappear, helping users track bundle progress.

The Notion template displays 'Bundles' and 'Rooms' sections, allowing users to check progress on each bundle. Stars indicate donated items, while black circles signify missing items, helping track donations and bundle access.

notion template to track your stardew bundles 🌷💐✨

*i did not create this, but is available online for free!* i’ve been very vocal that i’m on my first ever play through of stardew valley right now, and i’m currently on winter of year 1 and finally decided to see what was up at the community center 😂 i was quickly overwhelmed and was going to m

164 likes

My Secret to Studying Without Burnout: Pomodoro

If you know me, you probably already know that I am a big fan of the Pomodoro method. Ever since I started using it, I don’t experience burnout as often as I used to. I still do from time to time, but much less than before. Not only that, I’m able to focus better and my productivity has increased e

13 likes

My Favorite Pages in My Notion Content Calendar

These are my most-used pages inside my Notion Content Planner 📒 the ones that keep my life and creator workflow actually organized ✨ 📅 Content Calendar to visually plan posts across platforms 📊 Analytics to track and compare how my accounts are performing 🎯 Goals to set monthly creator goals

98 likes

✿˖° Taking Notes using my iPad and Notion

°𐐪♡𐑂°‧₊ 💌 I rebuilt my note-taking system from the ground up using just two tools. The magic happens on my iPad first where quick Freeform scribbles and Otter.ai’s live transcripts catch every fleeting thought before it disappears. But the real transformation comes when I port everything into Noti

39 likes

A cover image for "A Complete Guide to Sewing Machine Presser Foots Part 5 by Thriftdrevival," featuring spools of thread, sewing pins, and scissors surrounding a white title box.

A guide to the Rolled Hem Presser Foot, showing two close-up images of the foot and its use, with text detailing its features, benefits, and helpful tips for creating narrow rolled hems.

A guide to the Rolling/Roller Presser Foot, featuring three close-up images of the foot, including its use on leather, with text explaining its features, benefits, and when to use it for difficult fabrics.

PRESSER FOOT GUIDE PT 5

Hi! Here is part 5 to all sewing machine presser feet! I may have like 2 more to add at some point, but for now here is your ultimate guide to help you understand & elevate your sewing game/knowledge! In part one you’ll find: -Rolled Hem presser foot -Rolling/Roller presser foot -Ruffl

15 likes

A flat lay shows a red book titled "People skills" surrounded by self-improvement items like candles, flowers, and a notebook. The scene is set for a "Study with me" session, emphasizing investing in oneself for a better future.

A page from a self-help book or notes provides advice on discerning people, including warnings about those who hurt you, borrow money, or are overly enthusiastic. It also features a "Wealth Formula" and a final takeaway on building real wealth.

A page from a self-help book or notes, titled "CHAPTER 1: DISCERNING PEOPLE," offers advice on fighting back when feelings are ignored, identifying ulterior motives in public praise, and decoding the meaning behind "we're not compatible."

Come Study with Me!

Studying people skills, boundaries, communication, and emotional intelligence one chapter at a time ✍🏽📚✨ Lowkey… this book has me taking NOTES notes 😭👀 Should I do a full “Study With Me: Chapter 2” video next? self improvement, people skills, emotional intelligence, feminine growth, mindset

12 likes

Our Budget Planner is designed to help you take control of your finances with ease. Whether you're saving for a big goal, managing monthly expenses, or tracking spending, this simple yet effective planner offers sections for income, expenses, savings, and budgeting tips. Stay organized, stay on

1 like

My personal savings hack part 2

Lemon8 needs longer vid time but part 2! This is my personal saving hack for my serving and bartending girlies. Try out this money saving technique. #moneysavingtips #savemoney #savemoneyhacks

9 likes

🗣️HOW TO REDUCE YOUR MONTHLY BILLS

Here are practical ways to reduce your monthly bills These steps can help you save significantly without major lifestyle changes. #savinghacks #savingtechnique #savingtips #savingideas #savingshack

38 likes

Things I actually use in my new notion planner

Started using this to help with my ADHD and so far its rlly working! The next version I make will have buttons that congratulate you when you complete stuff because I find that helps with my motivation Link in my bio ! #lifestyle #productive #digitalplanning #adhd #lifeorganization

9 likes

This image illustrates the 70/20/10 budget breakdown, showing 70% for needs (housing, food, transportation), 20% for wants (daily spending, shopping), and 10% for savings (savings fund, emergency fund) based on an $18/hour income.

This image shows step 1 of the budgeting tool, where the user enters an hourly wage of $18 for 40 hours/week, resulting in an automatically calculated monthly income of $2,331 and annual income of $27,970.

This image displays step 2, where the user selects the 70/20/10 budget split from a dropdown menu, with other options like 50/30/20, 80/10/10, and 90/5/5 also visible.

How to budget using the 70/20/10 rule 💸

Most budgets are too complicated to set up, but this one actually makes sense when you're trying to save more each month. The template does all the percentage calculations automatically - you just enter your income, choose pre-tax or tax, and it tells you exactly how much to spend in each ca

587 likes

FOLLOW&LIKE&4MORE CONTENT🎥 I POST FOR THE COMMENTS

103 likes

Fridge Restock Pt. 1 ✨👏🏼#restock #fridgerestock

Fridge Restock Pt. 1 ✨👏🏼 #restock #fridgerestock #short

185 likes

Stop Ignoring Your Campus Library 📚

Okay, so I used to treat the campus library like it was just a mysterious building with too many fluorescent lights and serious energy. But once I actually stepped inside? Game. Changer. First of all, it’s free real estate—quiet, cozy, and usually has better Wi-Fi than your apartment or dorm. Ne

260 likes

Beginner savings 💕💰. . .

#savingideas #savingtechnique #moneyglowup #repost @Hannah 💗

5 likes

Our Budget Planner is designed to help you take control of your finances with ease. Whether you're saving for a big goal, managing monthly expenses, or tracking spending, this simple yet effective planner offers sections for income, expenses, savings, and budgeting tips. Stay organized, stay on

1 like

The simple budgeting method I use.

Here’s a simple budgeting technique that I personally use and love! Take this template and make it your own—optimize, customize, and rearrange it to fit your unique financial situation. Don’t forget to include your yearly expenses to get a clearer picture of your finances. Start budgeting today and

41 likes

Get A with me 🥰🥰

#successfulstudent #goodgrades #student #studygram #studywithme #tips #notewave #lemon8

13 likes

🪴One New Plant Skill I learned This Month🪴

🌱As I reflect on this month’s journey, I am reminded that growth comes not only from our plants but from the experiences we choose to engage in. 🌱Whether you are a beginner or a seasoned gardener, I encourage you to dive into a new plant skill this month. 🌱The possibilities are endless, and who k

42 likes

A laptop and phone rest on a white bedsheet, with a grey blanket in the background. Overlay text reads "WELLNESS HABITS that changed my life" and "Productivity Power-Ups: 5 Apps to Blast Through Your To-Do List in Half the Time."

5 Apps to Blast Your To-Do List in Half the Time ✨

Hi, lemons! In our fast-paced world, managing time effectively is key. However, staying on top of your to-do list can sometimes feel like a daunting task. Luckily, we have a solution. Here are five powerful apps designed to help you power through your to-do list in half the time: 1. Todoist T

46 likes

A very unserious speedrun #fyp

4 likes

the best budget technique

these budget binders from Amazon have been a huge life saver for budgeting especially with my adhd #amazonfinds #budgeting #budgetbinder #cashstuffing #savingmoneytips

79 likes

overnight oats 46g protein + creatine 🤌🏼

#mealprep #highproteinrecipe #protein #overnightoats #proteinbreakfast

270 likes

Budgeting Mistakes- Can Be Fixed ‼️‼️

#budgeting #savingsgoals #savingtechnique

7 likes

Gym second week mom dukes decided join me 🏋🏾‍♂️💪🏾🫵🏽💕 #gym #workout #fitness #f

0 likes

See more