Automatically translated.View original post

オハル｜事務職０年目🔰の攻略家

2798 followers

Follow

Follow

Follow

2 saved

3

Easy Excel 🔰 Rainy day Christmas tree🎄

← Easy Excel time saving technique (@ oharu _ work)

Thank you for watching 😊

🎙️ Sound Ali Recommended

Even people at work

People who spend time with someone

Some people spend their time

To everyone who watched this

I wish you a little happy time

How to make a Christmas tree

Ctrl + A

👇

Column width 25 pixels

👇

Row height 67 pixels

H11: Select L11

👇

Paint it brown

👇

B10: Select R10

👇

Hold down Ctrl and select while shifting inward one line at a time

👇

paint green

👇

= randbetween (1, 10)

👇

Ctrl + Enter

👇

Center alignment

👇

Conditional Format

👇

Icon set

👇

Circle icon selection

👇

Insert

👇

Figure

👇

Star

👇

to make a star

👇

paint yellow

👇

Works with F9

* It may not work depending on the version or specification

Next time, we will shorten the time to make your daily life easier

i will deliver it, so please save it and look back

*********************************************

Make some free time /

Mac 17 years | Windows 2 years

We are sending the struggle story of Excel de beginner 🔰.

Please like and follow me if you like

▶️ _ work

Please feel free to DM and comment

********************************************* "

# Excel Excel Time Shortening # excel _ beginner Time Shortening # excel _ usefulness

2025/12/22 Edited to

Excelでクリスマスツリーを作る際に気をつけたいポイントをいくつかご紹介します。まず、セルのサイズを調整することで見た目が整い、ツリーの形がきれいに仕上がります。記事でも紹介されているように、列の幅は25ピクセル、行の高さは67ピクセルに設定するとバランスが良いです。次に、条件付き書式の「アイコンセット」機能は、数字の大小を視覚的に分かりやすく表現できるので、ツリーの装飾としても効果的です。何度か操作してみることで、どの範囲にどの条件を設定するのが良いか感覚がつかめてきます。さらに、画像や図形の挿入は、Excel内でも簡単に行えるので、星などの飾りを作る際はぜひ活用しましょう。色塗りは「テーマの色」や「標準の色」などから選べ、デザインを工夫できる点も魅力です。私はExcel初心者の頃、このような装飾的なデザインを作るのは難しいと思っていましたが、今回の方法で意外と手軽にできて感動しました。クリスマスだけでなく、季節のイベントや社内資料の工夫にも活かせるので、ぜひ試してみてください。最後に、Excelのバージョンによっては一部の機能が使えない場合があるので、その際は他の似た機能や代替の操作方法を探しながらチャレンジすると良いでしょう。時短テクと併せて覚えれば、普段の作業も快適になりますよ。

Related posts

Excel shortcuts every student should know! 👩🏻‍💻

Stop Wasting Time: Master These Excel Formulas for Maximum Efficiency! 🕒 If you’ve ever struggled with Excel, mastering formulas can seriously up your game. Here’s a breakdown of the essentials that’ll make you look like a pro 1.Core Calculation Formulas 🧮 These are the basics you can’t live

1178 likes

A laptop displays an Excel spreadsheet with charts and data, while a hand interacts with the trackpad. The image features text overlay "Excel shortcuts cheat sheet" and "SWIPE FOR MORE," indicating a guide to Excel shortcuts.

This image lists four essential Excel shortcuts: Autosize Columns (Alt + H + O + I), AutoSum (Alt + =), Display formula in cells (Ctrl + ~), and Insert Current Date (Ctrl + ;). It is part of a multi-page guide.

This image presents four more Excel shortcuts: Insert Hyperlink (Ctrl + K), Freeze Rows & Columns (Alt + W + F + F + F), Fill Down / Fill Right (Ctrl + D and Ctrl + R), and Paste Special - Values (Alt + E, S, N).

Excel shortcuts every student should know! 👩🏻‍💻

Excel shortcuts can significantly improve your efficiency and productivity when working with spreadsheets. Here are some powerful Excel shortcuts that everyone should know. These shortcuts can save you a lot of time and make working with Excel more efficient. Practice using them regularly to become

2717 likes

Excel import magic

Excel magic at its finest. Import data from picture whether it’s a photo from your phone or a screenshot. #tutorial #exceltips #exceltricks #exceltraining #exceltutorial

365 likes

Blank EXCEL template for school nurses!

As a school nurse this isn’t perfect but I wanted to share it anyways. It is a BLANK excel template for students with health conditions. Just click and request access. Is there any other templates you’d like to have access to or need ? 1. Click my link tree in my bio!!! Click on drop down arrow

45 likes

Things that helped me excel as an online student

How to excel as an online student: planner📚: Keep a physical or online copy of a planner with you!! Planning out each day or writing down what classes you have at what time or what assignments are due each week will help you be prepared. Since you’re doing school online you won’t have a professor

42 likes

Excel shortcuts are easy to remember with cheat sheets like the ABC’s. These are some of the most common shortcuts to use. #excel #exceltraining #exceltips #exceltricks #excelpro #alwayslearning

33 likes

Useful Excel Formulas to save your time at work!

Hey everyone! Excel formulas are awesome for speeding up calculations and analyzing data. They range from simple math stuff to more complex tasks like searching and matching data. Learning these formulas can make your work easier and help you get more done in less time. Try out online tutorials and

872 likes

5 easy tech careers for anyone

1. IT Support Specialist - Role: Troubleshoot and resolve basic hardware, software, and network issues. - Why It’s Easy to Start: Requires minimal technical skills, and many entry-level positions provide on-the-job training. - Getting Started: Certifications like CompTIA A+ or Google IT Support

637 likes

Excel quick search tabs instead of scrolling trick

Excel quick search tabs instead of scrolling trick #tutorial #exceltips #exceltricks #excel _learning #exceltraining #learn #excelforbeginners #fyp

18 likes

Excel at the toughest premed classes! ✨

If you talk to any student who has completed their degree, with a premed major, there is a common three most difficult courses: Anatomy and physiology Organic chemistry Physics Across-the-board, these classes seem to be the ones that give students the most grief and require the most

28 likes

Excel list comparison 🌸

So we have to use something called Planbook at work (Teacher). I think this will make me want to actually use it more, and I can see me changing it again before second semester begins lol. How cute is this?! I’d usually do random colors, but love the pink & green combo. #Planbook #

4436 likes

Excel formatting does the same thing as many people using Word #tutorial #exceltips #exceltricks #exceltutorial #exceltraining #worktips #alwayslearning

4947 likes

100 Excel Shortcuts

#excelshortcuts #excelformulas #exceltips

744 likes

A smiling woman in a black puffer jacket, white scarf, and earmuffs holds a book and coffee cup in front of a festive market stall. Overlaid text reads: "MUST HAVE SCHEDULE FOR LAZY STUDENT."

A woman wearing headphones works on a laptop, illustrating the morning study block. Overlaid text details "Morning (9-11am)", "Wake up and hydrate", and "Do 1 focused study block (max 1hr)" on a priority topic.

A woman relaxes on a couch, reading a book, with a small dog on the windowsill. Overlaid text describes the "Afternoon (1-3pm)" activities: "Rest / scroll / vibe" and "Passive learning" via media.

How you can excel at school (the lazy way)

This one’s for my fellow lazy-but-ambitious besties 💅 You want good grades, but motivation? Rare. Energy? Inconsistent. Attention span? Fighting for its life. LOL. So I made a schedule that actually works when you’re low-effort but still want to see results. Here’s the lazy but it works ro

51 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

Save these Useful Excel Shortcuts!

Hey everyone! Excel shortcuts are super helpful for getting things done faster and smoother. They range from simple tricks for moving around your spreadsheet to more advanced ones for formatting and data manipulation. Mastering these shortcuts can really save you time and make you more efficient! I

296 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

100 Excel Tips The best Shortcuts, Formulas, Formatting & Advanced Tips Bookmark this, you'll save 1,000 of hours! A list of tips that all professionals need. Here is a preview: ⌨️ Shortcuts 1. How to hide a column? Ctrl + 0 2. How to hide a row? Ctrl + 9 3. How to

1428 likes

excel Cheatsheet 8/20:most common excel formulas

Struggling with spreadsheets for my studies? Not anymore! 📚 These Excel formulas saved me so much time and reduced my stress. Sharing my go-to formulas that make data management a breeze. Hope they help you as much as they've helped me! #excelsheets #dataanalytics #excelformulas

75 likes

A detailed Excel Cheat Sheet page covering 'Edit a Workbook', 'Basic Formatting', 'Insert Objects', 'View and Manage Worksheets', and 'Basic Formulas' with instructions and examples.

1/3: Ultimate Excel Cheatsheet You Should Know

Hey there, I've got just the right boost for your Excel game. 🌟 📝 The Journey from Junior to Senior: My Excel Cheatsheet Chronicles I've been there, struggling with the basics and wondering how to climb the Excel ladder. But fear not, because I've distilled my journey into a one-p

536 likes

ANALYZE DATA - EXCEL TOOL

Excel's Analyze Data Tool is a game-changer, simplifying the way you work with data. Say goodbye to the days of laboriously creating tables and charts and struggling with formatting intricacies. This tool automates the process, making data analysis and visualization effortless. With just a f

251 likes

Copy paste unique only in excel trick

Copy just the unique values in excel #exceltraining #exceltips #exceltricks #tutorials #excelforbeginners

12 likes

Excel tip to remove grid lines

Fill white is NOT the way to remove grid lines in excel. It will take forever and possibly cover other data. Go to the view menu and uncheck the grid line box anytime you have a dashboard or any other reason they aren’t needed. #tutorial #excel #exceltips #exceltricks #exceltraining

11 likes

Excel Cheatsheet: 7/20:the ultimate excel shortcut

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

183 likes

Excel Trick:Create an Interactive Project Tracker😎

✨ Welcome to Our Excel Mini-Class! ✨ Hey Excel Pros!😉 Want to take your project management skills to the next level? Want to stay organized and on top of your projects like a true professional? Let's create a super simple yet interactive project tracker in Excel that'll keep you focused

5 likes

Name cells in excel

Customize and store headings in Excel #exceltips #tutorial #exceltraining #exceltricks #exceltutorial #excelforbeginners #learn Takw my Excel class xecutethevision.com#onthisday

31 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

2582 likes

Study tips to help you excel in your exams 🍋

📝Daily affirmations - Straight A's are not negotiable - GPA reflection of my dedication - Study techniques that changed my life - From average to academic weapon - Transforming my grades completely - Study methods that actually work #StudyTok #studyWithMe #studyMotivation

6 likes

#excelspreadsheets #

1 like

An outdoor dining scene with people seated at tables, featuring the overlaid text "Freeze the Top Row in Excel." A purple glass is visible in the foreground on a black mesh table.

A light beige background with black text asking, "Do you ever have hundreds of rows of data and when scrolling down, you loose sight of the column header and forget which column/field is which?"

A light beige background with black text stating, "This is when freezing your top row is crucial! I will show you how!"

HOW I FREEZE THE TOP ROW IN EXCEL

The ability to freeze that first row of my column headers has been a lifesaver, allowing me to scroll through thousands of rows of data without losing sight of my column headers/fields. By simply selecting the row below the one you want to freeze, heading to the "View" tab, and clicking

105 likes

Excel dot trick

Do you know the DOT?? Excel trick using the dot to remove extra zeroes #exceltraining #excel #exceltricks #exceltraining #exceltutorial #business #businesstips

102 likes

Excel org chart

Tab your way to an org chart in excel #exceltricks #tutorial #exceltutorial #excel #exceltraining #fyp #spreadsheet

32 likes

Excel interview tips

Excel interview tips #exceltips #interviewtips #exceltraining #excel #business

17 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 time stamps

Yes, I said permanent time stamps #exceltips #excel #tutorial #worktips #exceltraining #exceltricks

53 likes

#excel #exceltips #technology #miami

#technologyineducation #excel #teacher #computer #office

1 like

My favorite apps for college 📱

📲 Canvas - Must have for me to submit my assignments! - If it’s not an essay, my professors encourage paperless use by posting the PDF of the assignment! 📲 Staffpad - My favorite music notation software! It’s pricy, but it runs well, the sounds of the instruments are nice (for the most par

50 likes

How to Find Cube Roots in Excel

How to Find Cube Roots in Excel #excel #exceltips #exceltricks #exceltutorial #msexcel

0 likes

Separate tab for excel notes

Keep your notes to yourself with excel camera #tutorial #excel #exceltraining #exceltricks #business #exceltutorial #exceltips

33 likes

Excel highlighting trick

CTRL+ Shift + arrow to highlight cells. #exceltips #tutorials #exceltraining #exceltutorial #excel #excelpro #onthisday

26 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

50 Excel Shortcut Keys

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

44 likes

Excel pdf button

Add a PDF button right to your Excel file #excel #tutorial #exceltips #exceltricks #spreadsheet xecutethevision dot com

41 likes

Document job instructions with a template in excel

Document job instructions and SOPs using Excel templates done for you. Find lever 5 on the site. #excel #templates #organize #worksmarternotharder

6 likes

Excel list comparison 🌸

Excel list comparison went viral save this for when you need it #exceltraining #excel #exceltutorial #exceltips #exceltricks

130 likes

Excel signature

Yes a handwritten signature imported in excel #exceltips #exceltricks #exceltraining #exceltutorial #excel

177 likes

Count the number of times an item appears in a column or list in excel #tutorial #exceltricks #excel #exceltips #exceltraining #fyp #onthisday

32 likes

5 PROVEN METHODS TO EXCEL AT WORK

Hey productivity bestie ☕✨ If you’ve been busy ALL day but still feel like you got nothing done… yeah, we fixing that TODAY 👀 Here’s your simple Productivity Glow-Up Blueprint (no overwhelm, just results 💼💅🏽): ✨ Set CLEAR goals (not “do work” be specific!) ✨ Prioritize what actually matte

2 likes

See more