Automatically translated.View original post

ゆい｜仕事がラクになるExcel術

401 followers

Follow

Follow

Follow

263 saved

73

2

[Using Excel] If you don't know, it's a loss! Can you make a narrowing button ✨

Other posts from here 💁‍♀️

@ yui _ exel _ work

Refine the data,

It will be very easy ✨

─ ─ ─ ─ ─ ─ ─ ─ ─ ─ ─ ─ ─ ─ ─ ─ ─ ─ ─ ─ ─ ─ ─ ─ ─ ─ ─ ─ ─ ─ ─ ─ ─ ─ ─

◆ Useful way to narrow down the data in the table ◆

< Table >

① Select all tables with [Ctrl + A]

Press [Ctrl + T] and press [OK].

It's about converting table data into a form that Excel can easily manage 💡

After tabling,

✔ each row is colored

✔ filter attached automatically

✔ data is added, the range automatically expands

The table will be much easier to handle ✨

< Slicer >

① Select all tables with [Ctrl + A]

② Press [Alt → N → S → F] in order

③ Check the item you want to create (department, base name, etc.) and press [OK]

The slicer is...

At the click of a button

It is a function to narrow down data 💡

For example, if the sales table for each department,

[Sales Department]

[General Affairs Department]

[Accounting Department]

A button like this is displayed on the screen,

Just click on the department you want to see

Only that data can be displayed 😊✨

You don't have to open the filter ▼ every time,

Because you can see the options and narrowing status at a glance,

It makes checking and aggregating data much easier ❤

─ ─ ─ ─ ─ ─ ─ ─ ─ ─ ─ ─ ─ ─ ─ ─ ─ ─ ─ ─ ─ ─ ─ ─ ─ ─ ─ ─ ─ ─ ─ ─ ─ ─ ─

Please "Like ❤️" and "Save 🔖" if you like 😊

Please feel free to comment and DM 🌸

Excel technique to make work a little easier 📊

Follow here → @ yui _ exel _ work

# excel # Excel # excel _ time # Excel Time Shortener # excel _ beginner

6/21 Edited to

私も以前はExcelの大量データのフィルター操作に時間を取られていました。しかし、テーブル化とスライサーを使うようになってから、作業効率が格段に上がりました。まずテーブル化ですが、Ctrl＋Aで範囲を選択しCtrl＋Tでテーブルに変換すると、色分けや自動拡張などありがたい機能が自動付与されます。これによりデータが見やすくなり、管理しやすくなりました。次にスライサーの活用です。Alt → N → S → Fのショートカット操作でスライサーの挿入画面が開くので、絞り込みたい項目を選んでOKを押すだけで、ボタンクリックでの直感的なフィルター操作が可能になります。私の職場では部署別の売上分析で大活躍しています。部署名のスライサーボタンをクリックするだけで必要なデータだけにサッと絞り込めるので、フィルターの細かい設定に時間を割く必要がなくなりました。さらに絞り込み状況が一目でわかるので確認もラクです。日常的にExcelを使う業務で、これらの機能を知らずに手作業でフィルターをいじっている人が多いですが、ぜひ一度試してみてほしいツールです。使いこなせば作業が効率的になるだけでなく、ミスも減らせます。Excel初心者にもおすすめの時短テクニックとしてぜひ活用ください。

Related posts

Tips and tricks ❤️💓🫶🏻 #accounting #tipsandtricks #student #career #fyp

1222 likes

This image, titled "Essential Learning Techniques," describes the Feynman Technique for explaining concepts simply and the Pareto Principle (80/20 Rule) for focusing on high-impact study material. It features a person working on a laptop at a desk.

This image, titled "Essential Learning Techniques," explains the Ebbinghaus Forgetting Curve for memory retention through reviews and the Interdisciplinary Approach for comprehensive understanding. The background shows a desk with a laptop, flowers, and books.

This image, titled "Essential Learning Techniques," details the Dual Coding Theory for combining text and visuals, and the GROW Model for setting clear learning goals. The background features a modern desk with a computer monitor displaying code.

🧠 10 Game-Changing Study Hacks That Actually Work!

#studytips #productivity #learning Hey besties! 📚✨ Ready to level up your study game? I've got some mind-blowing learning techniques that'll transform how you absorb information! These aren't your boring old study tips - they're scientifically-proven methods used by

13 likes

Key Cardiac Disorders You MUST Know! ❤️📖

Hey nursing students! 🩺💉 Here are a few key cardiac disorders you should know for nursing school and the NCLEX. Understanding these conditions is crucial for patient care and passing your exams! Let me know if this helps, and save this post for later! #NursingStudent #NCLEXPrep #CardiacDi

838 likes

A hand holds a pen over a colorful, handwritten study poster covering respiratory, cardiac, and gastrointestinal topics. The poster features organized notes and headings, illustrating a study method for nursing school.

A detailed, colorful handwritten study poster displays information on various gastrointestinal conditions like GI bleeds, ulcers, and pancreatitis. The notes are organized with headings and bullet points, reflecting a comprehensive study approach.

A vibrant, handwritten study poster focuses on hematological disorders, including anemia, leukemias, lymphomas, and platelet conditions. The poster uses different colors and organized sections to present complex medical information clearly.

How do you Study? 🩺✨🙌🏻

Finding a good way to study is so very helpful! Colorful posters are a way that helps me and it might be able to help you! I find that the colors and the organization of a poster and that all the information is in one spot! It calms my brain with the amount of information we are given throughout nu

900 likes

A calculator screen displays '91.37' and the text 'My notes that got me a 91% in patho'. It shows various scientific calculator functions like sin, cos, tan, log, and basic arithmetic operations.

Handwritten notes titled 'Final Exam Review - Diabetes', covering Type 1, Type 2, Diabetic Ketoacidosis, the 3 P's, Labs/Tests, and Gestational Diabetes, with key characteristics and risks highlighted.

Handwritten notes on STIs, including Chlamydia, Gonorrhea, Syphilis (stages 1-3), and Trichomoniasis, detailing their causes, symptoms, complications, and treatments like antibiotics.

My notes that got me a 91% in patho✨

Enjoy lolz IM FREE FROM PATHO (I actually loved this class sm) #school notes #pathophysiology #pathophysiologymadeeasy #nursingschoolstudytips #nursingschoolnotes

46 likes

How to 🔥Tone🔥 Your Way to a ✨Sleeker Silhouette!✨🍋

Achieving a slim and toned upper body while also developing strong, defined abs is a common goal for many women. The key to reaching this goal lies in a balanced approach that combines cardiovascular exercise, strength training, proper nutrition, and lifestyle adjustments. Here’s my guide to he

347 likes

Nursing cheat sheets

#nursing #nurse #college #nurselife

2 likes

How I stayed organized when applying 4 grad school

The spreadsheet is really my best advice I can give when it comes to applying for graduate schools. It is so important to stay organized, on top of dates, and to lay out how much work you have to do as far as applying all in one place. Also, since my field is very research heavy, really narr

165 likes

This image details cardiac enzymes (CK, CK-MB, Troponin I/T, Myoglobin) with their normal ranges and detection times. It also presents cholesterol levels, triglyceride ranges, and outlines echocardiography (transthoracic, transesophageal) and electrocardiography basics for cardiac assessment.

This image outlines cardiac stress tests, including protocols and pre-procedure instructions. It details angiography procedures, complications like artery dissection and cardiac tamponade, and hemodynamic monitoring techniques such as arterial lines and pulmonary artery catheter insertion for cardiac assessment.

This image defines atherosclerosis and coronary atherosclerosis, listing symptoms, modifiable risk factors, and prevention strategies. It covers cholesterol medications (statins), angina pectoris (stable/unstable), and compares MI and angina pain. It also introduces the vascular system's right and left heart functions.

❤️ Cardiac Must-Knows for Nursing Students

📍 1. Blood Flow Through the Heart (always know this!): RA ➡️ Tricuspid ➡️ RV ➡️ Pulmonic Valve ➡️ Lungs ➡️ LA ➡️ Mitral Valve ➡️ LV ➡️ Aortic Valve ➡️ Body 🫀 Mnemonic: “Try Pulling My Aorta” T = Tricuspid, P = Pulmonic, M = Mitral, A = Aortic ⸻ 📍 2. Vital Signs to Watch: • HR: 60–1

107 likes

A nursing note page titled 'stroke alert / brain attack' detailing the FAST acronym (Face, Arm, Speech, Time) for stroke recognition. It lists warning signs, immediate actions for suspected stroke, and information on Transient Ischemic Attacks (TIAs), emphasizing quick intervention.

A nursing note page comparing ischemic and hemorrhagic stroke types. It outlines causes, symptoms, diagnosis, and treatment for each, including details on TPA administration for ischemic strokes and surgical interventions for hemorrhagic strokes.

A nursing note page illustrating pulmonology anatomy, showing the trachea, bronchi, bronchioles, and alveoli within the lungs. It explains the breathing process, gas exchange, and defines common 'Nurse Lingo' terms related to respiratory conditions.

Key Nursing Notes: Stroke, Pulmonary, O2 Delivery🫁

Hey guys! I’m sharing detailed notes on stroke types, pulmonary anatomy, and oxygen delivery methods. Hope you find it helpful!🧠🫁✨ #nursingstudent #nursingschool #lemon8challenge #Lemon8Diary #nursesoflemon8 #education @Lemon8 Edu #nurse #nursingnotes

255 likes

A woman in grey athletic wear stands with her back to the camera, showcasing her physique. Overlay text reads "That Girl Hobbies," "HIGH ENERGY LOW ENERGY," and "Becoming a Better You."

A person with a backpack and hiking poles is seen from behind on a trail. A white box lists "HIGH ENERGY HOBBIES" including running, CrossFit, cycling, and martial arts.

A blue sky with white clouds forms the background for a white box listing "LOW ENERGY HOBBIES" such as yoga, meditation, gardening, and reading.

50 Hobbies To Become Healthier & More Feminine ✨🌸🍋

✨Allocate 20% of Your Time for Hobbies✨ It's crucial to dedicate a portion of your day to engaging in interesting hobbies. It's good for your personal growth and happiness. ✨Tips for Choosing Hobbies✨ Just start doing something: Its importance to take action and experiment with var

2346 likes

A person in blue scrubs takes a selfie in an elevator, with overlaid text promoting a resume template for a data analyst role that led to a 6-figure job and 20+ interviews, encouraging viewers to save it.

ATS friendly resume template

#resume #resumeadvice #ats #resumetips #jobsearch

13 likes

What I used to pass nursing school!

During nursing school it’s always hard to find what apps or programs to use to study. The most effective ones that worked for me were: -Quizlet: doing flash cards and practice NCLEX questions helped a a TON - Microsoft Excel: when I took pharmacology I used this for every test. I’d make a spr

52 likes

Build a Content Calendar in Less than 30 sec!

Comment ‘CONTENT’ to access 365+ Content Ideas & AI Prompts just for you!👇🏽 Plan out next months content now! ⁠ 👉🏽 Do you want to save time creating Reels for your business?⁠ ⁠ 👉🏽 Do you wish you had clarity and a roadmap on what Reels to post?⁠ ⁠ 👉🏽 Have you ever wasted hours scrollin

255 likes

A table titled 'Medical Terminology' lists 67 common medical prefixes, their meanings, and example words. It includes prefixes like 'hypo-' (low), 'hyper-' (high), 'brady-' (slow), and 'tachy-' (fast), which are crucial for understanding medical terms.

A table titled 'Medical Terminology' lists various medical suffixes from '-ac' to '-metry', along with their meanings and example words. This section helps in understanding the latter part of medical terms, such as '-itis' (inflammation) and '-ectomy' (removal).

A table titled 'Medical Terminology' continues the list of medical suffixes from '-oid' to '-us', providing their meanings and example words. This comprehensive list aids in deciphering complex medical vocabulary by breaking down terms into their component parts.

Why Medical Terminology Matters!

If you’re in nursing school or studying for the NCLEX, understanding medical terminology is essential! Here’s why: Why It’s Important: ✅ Improves communication with healthcare teams ✅ Helps you understand medical records & documentation ✅ Prevents errors in patient care ✅ Makes learnin

3456 likes

A clear iPad case decorated with pink and glittery stickers, including a large 'Hoshi' sticker, a pink bow, and heart shapes, over a collage of hand-drawn sketches and notes, with text 'PINK GOODNOTES INSPO MY PSYCH NOTES'.

Handwritten psychology notes titled 'Chapter 7 Cognition,' covering intelligence theories, IQ, Stanford-Binet, Wechsler tests, reliability, validity, standardization, mental images, prototypes, schemas, scripts, and trial-and-error, adorned with pink bows and cartoon illustrations.

Handwritten psychology notes titled 'CH 11: Stress & Health Psychology,' detailing stress definitions, stressors, types of conflict, General Adaptation Syndrome, and personality types, decorated with a pink bow, a cartoon rabbit, a plant, and two drink bottles.

PINK GOODNOTES INSPO (PSYCHOLOGY)

here’s my psychology notes from my first term as a college student i loved sitting in class listening to the professor and going on pinterest cutting out all the pictures it helped me focus haha (if your a psych major pls message me id love to be friends :D ) #study #goodnotes #psychmajo

2171 likes

In LOVE with this book✨🍋

Swipe to the end to find your attachment style! I recommend this book I bought mine on Amazon but I’m sure you can find it other places as well, they have different books for different styles and if you are not sure yours, you can find a quiz online or look up the classifications of each type. I c

959 likes

A woman wearing a black cap with 'UNITED STATES OF AMERICA' embroidered on it smiles at the camera, standing against a backdrop of a vast canyon landscape. The image is titled 'THE ULTIMATE ROAD TRIP GUIDE HOW TO PLAN THE PERFECT ADVENTURE'.

A laptop screen displays the heading '1 | SET A BUDGET' with text explaining the importance of estimating expenses for a road trip. Categories like gas, stays, food, attractions, extras, and car repairs are listed for budgeting considerations.

A woman in a striped shirt and shorts stands on a pier, leaning on a railing, with a Ferris wheel and ocean in the background. The text '2 | DECIDE YOUR ROUTE' lists popular road trip routes such as Pacific Coast, Route 66, and Blue Ridge Parkway.

5 Tips to Plan the PERFECT Road Trip 🚗

🇺🇸 The United States is known for its beautiful scenic routes, from the historic Route 66 crossing the country to the Border to Border, which extends all the way from Canada down to the Sonoran Desert. There’s a perfect route for everyone. ✍️ Or, if you're more into ‘creating your own’ journ

58 likes

The image displays the title slide for an article, featuring a laptop with a teal leaf pattern, a smartphone, and white daisies. The text reads "10 Essential Learning Techniques you should know" with a "swipe" indicator.

This slide, titled "Essential Learning Techniques," describes the Feynman Technique and the Pareto Principle (80/20 Rule). The background shows a person reaching for a book on a bookshelf, indicating page 1/5.

Titled "Essential Learning Techniques," this slide explains the Ebbinghaus Forgetting Curve and the Interdisciplinary Approach. The background features a desk with a laptop, books, a flower, and a coffee cup, marked as page 3/5.

Unlock Your Full Potential: Master These 10 Learni

Hey there, fellow learners! 🚀 Are you ready to supercharge your study game? Look no further! I've got the scoop on 10 essential learning techniques that will turn you into a study ninja. 📚 Chunking Method: Break down those big, scary topics into bite-sized chunks. It's like eating an ele

11 likes

A book promotion image for "The Cowboy Hat Rule" by H.K. Green, featuring three women in hats walking in a grassy field. The text indicates it's available on Kindle Unlimited and has a twist.

A book excerpt about a 'cowboy hat rule' dialogue, where a woman refuses to touch a man's hat, overlaid on a blurred image of three women in hats walking in a grassy field.

A book promotion for "The Pieces We've Lost" by H.K. Green, showing a Kindle e-reader with the book cover and arrows pointing to key romance tropes like 'cowboys/rodeo plot,' 'he falls first,' and 'found family.'

Think you know the cowboy hat rule?

Think again 👀 🩵🩵🩵 📚: The Pieces We’ve Lost by H.K. Green What to Expect: ⚡️ Cowboys/Rodeo Plot ⚡️ Black Cat x Golden Retriever ⚡️ He Falls First ⚡️ Found Family ⚡️ All the Emotions ⚡️ No Third Act Breakup ⚡️ Grief/Emotional Healing #cowboyromance #cowboyhat #readersoflemon

1932 likes

8 likes

✨🗄️ Job Interview Cheat Sheet For Beginners 📋✨

✨ Whewww. If your palms get sweaty just thinking about job interviews, this post is for you. Whether you’re entering the workforce, pivoting careers, or going for that corporate baddie promotion,interviews don’t have to feel like a pop quiz you didn’t study for.✨ ✨ Here are 12 of the most common

155 likes

The cover of "The Nursing School Antidote" by Beautiful Nursing, written by Amanda Draayer, offering comfort, advice, and hacks for nursing students.

An open spiral-bound study guide displaying medical-surgical topics: HHS vs. DKA, covering pathophysiology, risks, symptoms, and treatments, and Adrenal Cortex Disorders like Cushing's and Addison's.

An open spiral-bound study guide showing medical-surgical topics: Coronary Artery Disease, detailing pathophysiology, risks, symptoms, and treatments, and Ventricular Fibrillation, including causes, manifestations, and treatment.

📚 EXTRA NURSING SCHOOL RESOURCES I SWEAR BY 📚

If you’re in nursing school, you already know… it’s a different kind of hard 🩺📖 But these resources? LIFE-SAVING. Here are 20 must-have study tools ranked & priced to help you survive (& THRIVE) in nursing school! ⬇️ TOP RATED RESOURCES 🏆 🔥 1. Simple Nursing – 10/10 ⭐⭐⭐⭐⭐ 💰 $39.99/mo

207 likes

Nursing students

#nursingstudent #cheatsheet #nursingschool #nursing #nursingtiktok

1 like

How To REALLY Take Multiple Choice Exams!

Multiple choice exams don’t have to be as intimidating as they seem. With a few smart strategies, you can tackle them with confidence and improve your scores. Start by reading each question carefully. Take your time to underline key terms or phrases so you fully understand what’s being asked bef

75 likes

HOW I CREATE SPARK-LINES IN EXCEL

What is a sparkline? A sparkline is a small, simple, data-intense graphical representation typically used in line with text to show trends, variations, or patterns in data at a glance. Creating a sparkline in excel is pretty simple. I highlight a range of horizontally organized data and go into

320 likes

A person in blue scrubs takes a selfie in an elevator, with text overlays promoting a resume template that secured a 6-figure AI engineer job and 20+ interviews, encouraging viewers to save it.

Havard resume template ATS resume

How to get interviews, Get RESUMES from APPLYGIGS.COM and get a resume from there fast #resumetemplates #resumetips #jobsearch #resume #ats

0 likes

A person in a cream top holds an open textbook, with overlay text "3 study hacks that Instantly boost study CONCENTRATION," introducing methods for improved focus.

A person in an orange top holds an open textbook displaying anatomical bone diagrams, with overlay text "1. Use White noise for focus," illustrating a study hack.

A person in a white top holds a paper with anatomical diagrams, with overlay text "2 minute rule For procrastination," illustrating a study hack.

Secrets to How Med Students Stay Focused for Hours

Staying focused during study sessions can be challenging, but a few simple techniques can make a big difference. Here are three study hacks that will instantly boost your focus and productivity: 1. White Noise for Concentration: For many students, complete silence can be distracting, whil

40 likes

An overhead shot of several books on a cozy, crocheted blanket with yellow, orange, and green squares. Large orange text overlays read 'books that feel like fall,' suggesting autumn-themed reading recommendations.

The book 'Ghosts of Harvard' by Francesca Serritella is centered on a crocheted blanket, with text highlighting it as a 480-page dark academia, paranormal thriller. Summaries detail a Harvard mystery involving ghosts and a brother's death.

The book 'Ink Blood Sister Scribe' by Emma Törzs is displayed on a crocheted blanket, described as a 416-page urban fantasy, magical realism, and witchy novel. Summaries mention a family guarding magical books and sisters reuniting.

autumn-coded novels 🍂

Autumn is just around the corner!! (for my northern hemisphere girlies) I LOVEEEEE the fall and i love anything that even remotely gives off fall vibes and these books are perfectttt to satisfy that need. Autumn books recs don’t always have to be thrillers or horrors, so these are all kinds of g

162 likes

An open Bible page showing Genesis 44-45 with highlighted text and handwritten notes about Joseph testing his brothers, Judah's plea, and the discovery of the goblet, emphasizing integrity trials and collective responsibility.

An open Bible page displaying Genesis 45-46, featuring highlighted text and a sticky note. Content includes Joseph revealing his identity, God's purpose in sending him ahead, and notes on embracing forgiveness and trusting God's plan.

A close-up of a yellow sticky note with handwritten text about Genesis 45, encouraging forgiveness, trusting God's greater plan and provisions, recognizing God's purpose, and reconciling relationships with grace and peace.

✨ Genesis 44–50 – Forgiveness, Reunion & God’s Sov

📖 Key Verse: “You meant evil against me, but God meant it for good.” (Gen 50:20) 🟩 Key Notes: • Joseph tests his brothers’ hearts 🪞 • Judah steps up with sacrificial love 🤍 • Joseph forgives & reunites with family 🌿 • Jacob blesses his sons & wors

64 likes

Swipe for nursing school notes

Nursing School notes to help you pass nursing school #nursingstudenttips #nursingstudentaesthetics #nursingmajor #nursing #nursesoflemon8

1226 likes

Questions about resume

What’s everyone’s thoughts on this? On the one hand you want to stand out from the rest and on the other a typical job isn’t necessarily all that exciting to write about. Where do you think the line is in terms of embellishing a resume? Obviously lying isn’t acceptable and downright silly but also

18 likes

Part 2: Weight Loss Starts in Your 🛒

I love bringing my girls grocery shopping with me because they get to see what supports our health — not just hear me talk about it. They watch what goes into our cart. They see the protein, the produce, the balanced options. They learn that what we put into our bodies either helps us or hurts

46 likes

Types of strokes

9 likes

do it for the resort credit 😎

One thing I’ve noticed working in travel… A lot of couples start looking at Sandals resorts during major sales. And this current Semi-Annual Caribbean Sale is one of the bigger promotions we see. It includes: • up to 65% off stays • a $175 resort credit • free night offers at select r

0 likes

Mastering Your Research Paper Introduction

Many believe that writing an introduction is straightforward, but there’s a specific logic to it: it’s a process of narrowing down from a broad academic field to a specific research objective. Think of it as a ""funnel"" structure, transitioning from a larger context to a focused to

33 likes

#therapy #teens #childrenbooks #ttshop

1 like

Future nurses this is for YOU 🩺📘 I help with TEAS, HESI, anatomy & physiology, online exams, and coursework so you can focus on becoming a great nurse. Let’s get you that PASS #nurse #nurse💉💊 #patientcaretechnician #student #medstudent

4 likes

Where is your tongue right now? If it is sitting on the floor of your mouth, you need to read this. Your tongue should be gently suctioned to the roof of your mouth. Not just the tip. The middle and the back of the tongue, closer to the root, should all be making contact with the palate. T

2 likes

#reading #romancebooks #romance #bookrecommendations #readingromance #trendingbooks2025 #bookworm #booktok

116 likes

books thicker than a bowl of oatmeal

Sometimes you just need a good ole 700-page book to keep you company, right??? Right!!! As much as I love short books, my heart belongs to thick ones <3 I love staying in one world for a while, and really taking my time and staying engrossed in one long story. It’s like binge watching one tel

57 likes

#leanbulk #musclegrowth #musclebuilding #dexascanresults #bodycompositionchange

3 likes

See more