Automatically translated.View original post

あお｜Excelで“自分時間”を増やす働き方

9189 followers

Follow

Follow

Follow

485 saved

196

2

🔸Two sheets side by side🔸

[How to do]

① Press Alt → W → N in order

② Open another one of the same data

③ Select the data you want to display on the left

④ Press the Windows key and the left arrow at the same time

⑤ Select another data on the right

Please try to imitate it by [saving] 😊

｡: + * ﾟﾟﾟ

How to Work to Increase Your Own Time with Excel

A way of working that doesn't require hard work

▷ Efficient 🪄

▷ Clear life that comes true with Excel 🌿

▷ Housework and work 🌷

　

Home Freelance Mom 💻

Mom with three children | 3 years of entrepreneurial support | Contributed over 200 million yen

Other time saving techniques from here

@あお｜Excelで“自分時間”を増やす働き方

｡: + * ﾟﾟﾟ

# excel # work # work The computer # excel

1/11 Edited to

Excelで2つのシートを別々に2画面表示する方法は、データを比較したりチェックするときに非常に便利ですよね。私も家計簿の収入と支出を見比べる際などに、今回紹介したAlt→W→Nキーの操作とWindowsキー＋矢印キーの組み合わせを使っています。この方法で2つのシートを左右に並べて表示できるので、簡単に違いを確認しながら作業ができ、更新内容も即座に反映されるのでストレスフリー。普段は1画面に切り替えて作業している方も、ぜひ電卓や計算結果を同時に確認したい場合などに試してみてください。また、OCRで読み取れた「1か月の収入」や「家賃/住宅ローン」などの項目を比較するのにもぴったりです。実際に2つの収入源や支出の項目を並べて見ると家計の見直しがしやすくなりました。パソコンの小技として、Windowsキーと矢印キーの併用は他のアプリでも使えることが多いので、覚えておくと画面操作がスムーズになります。これからもExcelの便利な使い方を取り入れて、自分時間を増やしていきたいですね！

Related posts

A plated anti-inflammatory dinner featuring honey soy chicken meatballs, roasted cauliflower, and a baked sweet potato topped with a creamy sauce and herbs.

Various ingredients for the anti-inflammatory dinner laid out on a wooden cutting board, including ground chicken, soy sauce, honey, sweet potatoes, and bags of cauliflower florets.

Cauliflower florets seasoned with spices and spread on a parchment-lined baking sheet, ready for roasting as part of the anti-inflammatory dinner.

Easy Anti-Inflammatory Dinner

Honey Soy Chicken Meatballs (I doubled the recipe here so wed have leftovers for the week) -1 lb ground chicken -1 egg -1/2 cup panko breadcrumbs -1 tsp each: salt, paprika, thyme, parsley, oregano, garlic powder, onion powder -1/2 tsp black pepper, chili flakes -1 tbsp olive oil Sauce -1

3076 likes

Shake Them MF Sheets 😜

#shakethemsheets #fitmomlife #simpleexercise #armsworkout #foryoupage

1400 likes

If you haven’t started here are 2 budgeting sheets you can use! #budgetingforbeginners #budgeting101 #budgeting #budgetingmadeeasy

547 likes

A person in black scrubs holds a phone, with blue text overlays reading "NURSING CHEAT SHEETS MEDICAL SURGICAL" and a right arrow symbol. The background shows a colorful abstract painting and a window.

A white page titled "B - Medical-Surgical Terms" lists 10 medical conditions, including Bradycardia, Burns, Bronchitis, and Bowel Obstruction. Each entry provides a definition, PNLE clue, and nursing notes.

A white page titled "C - Medical-Surgical Terms" lists 10 medical conditions, including Cholecystitis, COPD, Cirrhosis, and Cushing's Syndrome. Each entry provides a definition, PNLE clue, and nursing notes.

Medical surgical cheat sheets ✨🍋✨

#nursingstudent #nursing #nursingstudentlife #nursingnotes #nursing

149 likes

A handwritten study sheet titled 'Steal my nervous system Review Sheets' detailing neuroglial cells of the CNS (Ependymal, Oligodendrocytes, Astrocytes, Microglial) and the definition of Action Potential, including polarization and resting potential.

A handwritten study sheet outlining the '4 Steps of Action Potential': Resting Potential (maintained by Sodium Potassium Pump), Depolarization, Repolarization, and Hyperpolarization, with explanations for each stage.

A handwritten study sheet defining 'Neurons' (nerve cells, their parts, and unusual characteristics), 'Cell Body,' 'Dendrites,' 'Axon,' and 'Synapse,' explaining neurotransmitter release and transmission.

Steal my nervous system a&p summary sheets 🗒️

Master the Nervous System! 🧠✨ Sharing my AP 2 notes to make studying easier—save this for future reference! 📌 Hope someone benefits from all these notes haha, my hand almost fell off writing them all out! The nervous system is one of the most complex and important systems in the body, controlli

174 likes

Two side hustles you can do ✨from your bed✨

If you're anything like me, you like to treat yourself from time to time (all the time), but all those little Starbucks runs add up! So let's talk about two side hustles you can crush without even leaving your bed 🛌 And with DataAnnotation, you can even do it as a full time wfh job if that&

2717 likes

ONE MEAL,TWO WAYS 🥐✨ (Baby + Hubby Approved)

Sunday afternoon prep looked a little different today! Had a can of jumbo biscuits and a few ingredients to use up, and turned them into these Creamy Chicken & Broccoli Biscuit Empanadas. The best part? It took 20 minutes and fed everyone! For the 11-month-old: Cut into finger-width strips

14 likes

Google Sheets Girlies Don’t Gate Keep 🦋

Sharing resources I’ve bookmarked on my phone for Google Sheets : 1. https://developers.google.com/sheets - I used this to learn formulas and App Script 2. https://pigment.shapefactory.co & https://m3.material.io/styles/color/resources - these 2 sites come in very clutch for picking colo

1623 likes

Make dryer sheets that last forever 🌸

#laundryhacks #laundry #budgetfriendly

5447 likes

A smiling nursing student in a car, with text overlay reading "Helpful Medicine Lists FROM A NURSING STUDENT," indicating the content of the following pharmacology cheat sheets.

A pharmacology cheat sheet titled "PATHOPHYSIOLOGY" detailing Antihistamines, Proton Pump Inhibitors, and H2 Receptor Antagonists, including their drugs, uses, side effects, and important considerations.

A pharmacology cheat sheet titled "SKELETAL MUSCLE" outlining Neuromuscular Blockers, Muscle Relaxants, and Antispasmodics, listing their drugs, uses, side effects, and key considerations.

Pharmacology cheat sheets✨🫶🏼

✨Here are a couple of sheets that have been helpful so far as a nursing student!! #nursingstudent #pharmacologytips #collegelife #lemon8challenge #fyp

453 likes

A desktop setup with a monitor displaying a cartoon background. A tablet in the foreground shows an 'Aesthetic Google Sheets Templates' mood tracker, featuring daily notes, mood, sleep, and weather tracking for January.

A laptop screen displays a 'Life Planner' Google Sheets template, featuring a calendar and various planning sections, designed to simplify daily goal management.

A laptop screen displays an 'Academic Planner' Google Sheets template, including annual, monthly, and course dashboards for organizing academic and personal life.

Aesthetic Google Sheets Templates

Imagine a life where managing your money, habits, and goals is a breeze. with Aesthetic Google Sheets Templates make it possible! ✨ Start being intentional with your finances and jumpstart your personal finance journey. Track your daily and weekly habits effortlessly, ensuring you stay on top o

1541 likes

Nursing clinical cheet sheets

#nursingstudent #nursingschool #cheatsheet #nursing #nursingtiktok

137 likes

AI tools to make money as a side job

1. Copywriting: Writesonic 2. E-commerce art: Pebblely 3. Illustration design: Stable diffusion 4. Photo editing: Paint By Text 5. Graphic design: StockImg AI 6. Website development: Codeium 7. Video editing: Runway 8. AI modeling: Kinetix 9. PPT making: Prezo #ai #toolbox #websites

783 likes

Amazon’s Best-Selling Sheets

Aside from my going all out with my bedroom decor, making sure that I have high quality bedding is just as important. I get my sheet sets from Mellanni Fine Linens on Amazon, they have over 300K + positive reviews and the sheet sets are very affordable. The sheets are about $38 for a set. So I

4603 likes

Two mystery boxes built side by side

#packwithme #mysterybox #customorder #smallbusiness

20 likes

3 SUM formulas in Google Sheets

Knowing how to add cells together is fundamental to using Google Sheets. It’s just as easy to add cells based on specific criteria existing. You’ll just use the SUMIF or SUMIFS formulas instead. #googlesheets #spreadsheet #sum #sumif #sumifs

12 likes

A baby wearing a black onesie with a pacifier, lying down, with the title "Newborn Cheat Sheets" overlaid.

A close-up of a sleeping baby with text overlays detailing newborn sleep facts, including sleeping 16-20 hours, recognizing sleep cues, and dressing appropriately.

A blurred image of a baby's umbilical cord area with text overlays providing care instructions, such as keeping it dry, cleaning with a damp q-tip, and its typical fall-off time.

newborn cheat sheets

hello ◡̈ 💤 Newborn Sleep - Newborn babies sleep a lot, but in short bursts, and often have trouble settling down for long stretches. It's normal for newborns to wake up frequently as their tiny tummies need frequent refueling and their brains are constantly processing new sights and sounds.

3249 likes

The image displays the title "THE SHADOW SIDE OF EACH ZODIAC SIGN" and "What You Need to Face & Heal" in white text against a dark, starry night sky with silhouetted figures in the foreground.

This image details the shadow traits, challenges, and healing paths for Aries (Impulsiveness, aggression) and Taurus (Stubbornness, materialism) against a dark, mountainous background.

This image outlines the shadow traits, challenges, and healing paths for Gemini (Superficiality, restlessness) and Cancer (Moodiness, over-sensitivity) against a dark, mountainous background.

Shadow side of each zodiac sign!!

Every zodiac sign has a light and a dark side. The "shadow self" represents the unconscious patterns, fears, and hidden traits that we may struggle with. By acknowledging and working through these shadows, we grow into our highest selves. #shadowself #astrology #zodiacsigns #healing

1112 likes

How to improve your Google Sheets Skills

(From someone who has created over 44 #googlesheets dashboards) 1. Learn by doing - my first ones are more simple compared to my current Dashboards but I need practice in order to design Dashboards that are more complex to meet my own needs 2. Add images and Icons - certain formulas also wor

966 likes

Current Loc Style: Two Strands w/ Side Part

This will always be a classic style and is a two in one style, because the takedown is going to hit! Do you like two strands? #twostrandlocs #locstylesforwomen #sidepartlocs #blackwomenwithlocs #shoulderlengthlocstyle

33 likes

A store shelf displays multiple teal boxes of CareUs Silicone Scar Sheets, each priced at $1.25. The packaging highlights transparent, self-adhesive, reusable sheets for improving and preventing scars. Each box contains four large sheets, measuring 1.5 x 3 inches.

Silicone Scar Sheets

I just had a fun Dollar Tree beauty haul and was thrilled to find some unexpected gems! The standout of the trip was definitely these CareUs Silicone Scar Sheets, which I picked up for just $1.25. These are typically used to reduce the appearance of scars, but I’m planning to use them on my face to

548 likes

Nursing clinical cheat sheets

#nursingstudent #clinicals #cheatsheet #nursingschool #nursing

57 likes

A nursing cheat sheet titled 'Symptoms of Hypothyroidism' using the mnemonic 'M-O-M IS T-I-R-E-D' to list symptoms like memory loss, obesity, impaired fertility, slowness, skin dryness, tiredness, intolerance to cold, raised BP, and depression.

A nursing cheat sheet titled 'ACID-BASE MNEMONIC' using 'R-O-M-E' to explain respiratory (opposite pH/PCO2) and metabolic (equal pH/HCO3) acid-base imbalances, indicating alkalosis and acidosis.

A nursing cheat sheet titled 'Pharmacology' listing common drug class suffixes and their corresponding drug types, such as '-amil' for calcium channel blockers, '-caine' for local anesthetics, '-dine' for anti-ulcer agents, and '-olol' for beta blockers.

NURSING CHEAT SHEETS✨

#lemon8diarychallenge Hey friends it’s Faye, I’m obsessed with this app. I seen these cute little study cards for Nursing Students and just wanted to share because girls who share are girls who care 🥹💕🥹 Faye Out 🥰 #nursingstudenttips #nursestudent #patientcaretechnician #m

251 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

205 likes

A baby in a blue and white checkered onesie smiles with an open mouth. Overlay text reads "Cheat Sheets For Babies Cries SWIPE," indicating a guide to understanding baby cries.

A baby in a checkered onesie is shown with text describing hungry cries as "NEH" (rhythmic, repetitive, escalating) and sleepy cries as "OWH" (whiny, nasal, persistent).

A baby in a checkered onesie is shown with text describing pain cries as "EAIRH" (loud, sudden, intense) and discomfort cries as "HEH" (fussy, squirming, restless).

hello ◡̈ Dunstan Baby Language — it's a total lifesaver for understanding newborn's cries! By learning the different sounds and patterns, you can start to crack the code on what your baby needs! As you get to know your baby better, you start to recognize the subtle differences in their

1256 likes

GUT HEALTH CHEAT SHEETS FOR FALL✨

Our bodies are CONSTANTlY communicating to us all of the time, whether we realize it or not. In the winter, we naturally crave soups, nuts, warm grains, and comfort foods🍜 In the summer, we want cooling, high energy foods like salads, fruits, and leafy greens. 🥬 Our gut microbes are meant to ch

638 likes

A stethoscope rests on a dark surface with a faint heart drawing, accompanied by the text 'CHEAT SHEETS To pass your Nursing Pre-requisites' and 'Lemon8 @taylin.schmidt'.

A hand-drawn diagram of the human body illustrates major blood vessels, with arteries in red and veins in blue, labeled with anatomical terms like carotid, jugular, subclavian, and femoral.

Detailed handwritten notes and diagrams explain the heart's anatomy, blood flow, electrical impulses, cardiac output calculation, control mechanisms, and an ECG wave complex.

Struggling in Anatomy and Physiology 2? Here are some cheat sheets to help you study for your next exam! Best of luck ❣️

76 likes

A woman in purple athletic wear stands in a gym, looking down at her leggings. Overlay text reads 'PROTEIN CHEAT SHEET' on a torn paper graphic.

A graphic titled 'MUSCLE BUILDING MEAT PROTEINS' lists various meats with their protein content per 100g, such as chicken breast, sirloin steak, and salmon. Another section, 'GOOD SOURCES OF LEAN PROTEIN,' shows items like cottage cheese, Greek yogurt, and egg whites.

A 'SAMPLE MEAL PREP' guide for 1500 calories, detailing 151g protein, 151g carbs, and 33g fat. It lists food to prep (chicken, turkey, rice, sweet potatoes) and meal ideas for breakfast, snacks, lunch, dinner, and dessert with accompanying food images.

THE ONLY PROTEIN CHEAT SHEETS U NEED FOR GYM GAINS

struggling to hit your protein goals again? i got you, always🙌 here are some protein cheat sheets that i used at the beginning of my fitness journey that have helped me learned how i could hit my protein goals faster and 10x the gym gains🍑 full meal plan with a recipe library (curated by mwah🤌🏼)

626 likes

Money saving sheets!

These are money saving sheets! Take them and save that money honey! #savingsmadeeasy #savingsmadesimple #savingdollars #savingideas #savingssheet

1116 likes

This image is an EKG interpretation guide for nurses, detailing heart structure with a diagram of heart chambers and electrical conduction pathways, including the SA node, AV node, and Purkinje fibers. It explains the basics of electrical signals causing heart contractions.

This EKG cheat sheet explains EKG waves (P, QRS, T, U), intervals (PP, RR, QT, QRS), and how to measure voltage and time on an EKG strip. It includes diagrams illustrating waveforms and interval measurements.

This image outlines five steps for EKG interpretation: determining heart rate, rhythm, evaluating the P wave, calculating the PR interval, and analyzing the QRS complex, with examples of EKG strips for each step.

EKG cheat sheets

Today starts the last semester of nursing school and I can’t wait to be done. For my medsurg 3 clinical, I am in the neuro ICU again which I love and so happy about that. Our medsurg 3 class is 7 weeks long and focuses mainly on the critically ill client. Our first exam is on arrhythmias and the d

794 likes

A laptop displays a Google Sheet with a green header, alongside a tablet showing a calendar. The image features text overlay: 'Hack How to create a Notion-like header in Google Sheets'.

A Google Sheet interface demonstrates steps to 'Add 6 Rows' and 'Change Row 1 to height of 300', with a pop-up window for specifying row height to 300 pixels.

A Google Sheet interface shows instructions to 'Change Rows 2-5 to height of 40' and 'Change Row 6 to height of 30', with respective pop-up windows for resizing rows.

Google Sheets Hack - Adding a Notion Like Header

I recently updated my Masterlist with a header! Colors I Used: 1. Dark Green - 0b8043 2. Light Green -ccd5ae Full YT Tutorial is in my profile! #assignments #collegestudent #techfinds #studymotivation #googlesheetscalendar #googlesheets #organization #masterlist

312 likes

A Google Sheets dashboard titled 'Cost Splitter Dashboard' with financial summaries for multiple individuals. Large text overlay reads 'GOOGLE SHEETS HOW TO ADD IMAGES'.

A Google Sheets screenshot showing the 'Insert' menu with 'Image' highlighted, demonstrating the first step to add images. The text overlay says '1. INSERT > IMAGES'.

A Google Sheets screenshot showing the 'Image' submenu with 'Insert image in cell' and 'Insert image over cells' highlighted. The text overlay says '2. INSERT IMAGE IN CELL OR INSERT IMAGE OVER CELLS'.

👇🏻How I add images in Google Sheets

First Method: 💻 1. Copy and Paste OR Second Method: 🖥️ 1. Go to Insert > Images 🖼️ 2. Insert images ✅ 3. Upload and browse for image from computer These are the steps on a laptop and steps for the Google Sheets App are slightly different but I’ll bring sharing more tips on using

286 likes

A package of biore. portable soap sheets, priced at $1.25, is shown. It contains 20 instant soap sheets in a pocket-size case with a carabiner clip, designed for on-the-go use. Each sheet provides one wash with just water.

These are portable soap sheets. I bought a few packs. To go in my purse, diaper bag and car. Easy to carry #soap sheets #dollarstorefinds #dollar tree #dollartree #dollartreebeauty

932 likes

A Google Sheets tab titled 'My Courses' displaying course codes and names, with an overlay indicating 'MY UPDATED ASSIGNMENT Master list' for academic organization.

A Google Sheets view showing a 'Course Schedule' by semester and year, alongside 'Course Progress' tracking finished assignments and completion percentages for various courses.

A Google Sheets 'Course Progress' section demonstrating auto-colored boxes (green, yellow, red) based on assignment completion percentages, with 0% completion being blank.

How to Create A Masterlist in Google Sheets

Starting template: https://docs.google.com/spreadsheets/d/1MrxXG08PumhN1c5z5-3_kUA1_H5-z9OJFzSz0c_BVUQ/edit. I recently updated my Google Sheets Masterlist and filmed a tutorial of the process a too. My Masterlist and Calendar has kept me on top of all my readings, homework, exams, and I also ad

476 likes

A Google Sheets annual expense tracking dashboard showing total expenses, incomes, and credit card expenses. It includes pie charts for expense breakdown, income breakdown, and credit card usage, along with detailed monthly summary tables for income, expenses, and credit cards.

A collage showcasing four key sections of a Google Sheets expense tracker: the Settings tab for customization, the Annual Dashboard for yearly summaries, the Monthly Dashboard for monthly overviews, and the Transaction Log for recording all financial activities.

The 'Settings' tab of a Google Sheets expense tracker, allowing users to enter currency, add up to 20 credit cards and bank accounts, define income sources, and customize expense categories. It also includes credit card utilization targets.

Expense Tracking in Google Sheets ✨

Why to expense track in #googlesheets : - helps you take control of your finances and stay on budget - You can organize your expenses into categories like fixed, periodic, and variable spending - regularly review your expense tracking on a per-project or time-frame system #techfinds #

568 likes

pregnancy cheat sheets

hello ◡̈ The first step to motherhood is often simply "surviving" pregnancy! Those nine months can be a continuous cycle of changing, growing and evolving! From morning sickness to sleep problems already beginning, it can be overwhelming. But don't worry, mama, you're not alone! W

391 likes

See more