Automatically translated.View original post

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

7387 followers

Follow

Follow

Follow

102 saved

39

How to prepare a table using format [Excel convenient technique]

@ wako _ pc _ work ← Overtime will be reduced by following!

Today, I introduced [How to arrange tables using formats] ✨

I would be happy if you could send your requests and comments to comments / DM 😊

- - - - - - - - - - - - - - -

[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

- - - - - - - - - - - - - - -

2025/12/3 Edited to

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

1175 likes

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

4938 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

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

1429 likes

A flat lay image featuring a pink notebook, gold heart-shaped dish with paperclips, and a gold pen, alongside a keyboard and pink flowers. The text overlay reads "5 FREE ONLINE CERTIFICATIONS to Boost YOUR RESUME."

5 Free Online Certifications to Boost Your Resume

Hi, lemons! In today's competitive job market, having a standout resume is crucial. Employers seek candidates with not only relevant experience but also a commitment to continuous learning. Fortunately, the digital age offers a wealth of free online certifications that can enhance your skill se

742 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 signature

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

176 likes

How to get the excel Cheatsheet pdf?

I just made my own website : valder.org A lot of free data resources will share on it. If you are a student in college you can follow to get more.

58 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

2586 likes

Excel interview tips

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

17 likes

Excel tip to fix row sizing 🌸

Just pause before you send a file like this. It takes 3 seconds to fix it. #exceltips #tutorial #exceltraining #exceltraining #exceltricks

54 likes

Excel cheat sheet

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

14 likes

A study desk with an iPad, highlighter, textbook, and notes, featuring the title "How to get a 4.00 GPA Based on your Major" and "All majors included!".

Strategies for Business & Management Majors (Business Management, Accounting, Finance, Economics), including Active Participation, Case Study Analysis, Practice Financial Modeling, and Utilize Study Groups, with mentions of MarketingSherpa and GroupMe.

Strategies for Communications & Education Majors (Communications, Education), including Create Multimedia Presentations, Peer Teaching, Reflective Journaling, and Attend Workshops, with mentions of Canva and Notion.

Major-Specific Strategies to Achieve a ✨4.0 GPA✨🎓🧠

🎓1. Business & Management Majors (Business Management, Accounting, Finance, Economics) ✅Active Participation: Example: In a Marketing class, when discussing a case study like Coca-Cola’s rebranding, share your analysis of the marketing mix (4Ps). This not only engages you in the materi

6986 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 permanent timestamp

Time stamps DO NOT update when you close and reopen #excel #exceltips #templates #tutorial #exceltraining

23 likes

Excel org chart

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

32 likes

How to subtract hours and format time in excel

How to subtract hours using Excel. Format time with this excel tip. #excel #exceltips #exceltricks #tutorial #exceltraining

39 likes

Excel data cleaning tools

🧹🧼 Clean it up with these 3 excel data cleaning tricks #tutorial #exceltips #exceltricks #exceltutorial #excel #business

22 likes

Separate words in excel

Separating text in excel #exceltricks #exceltips #tutorials #takemyclass #fyp

21 likes

Excel Hacks: 4 Quick Ways to Fill Serial!

📈 Welcome to Our Excel Mini-Class! 💫 In this session, we're unveiling the magic of fill serial! Ready to save time on your Excel spreadsheets? Here's 4 super fast ways to fill serial numbers like a pro! 💼✨ Get ready to level up your Excel skills! 🙌 #wps #fillserial #exceltips

7 likes

Separate tab for excel notes

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

33 likes

Excel signature

Handwritten signature in Excel #tutorials #excel #excelforbeginners #exceltraining #exceltips

8 likes

Excel projects with a Gantt chart

Auto populate the Gantt style chart with name and color #template #excel #tutorial #friday #exceltips

11 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

Excel drop it function

Remove columns and rows using drop in excel. #exceltips #excel #exceltutorial #businesstips #business #tutorial #boss #spreadsheet

20 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

Excel time stamps

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

53 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

105 likes

Excel Time-Saver: Text Formatting 🔄 🔠

💡 Welcome to Our Excel Mini-Class! 🥳 In this session, we're unlocking the power of Text Case Transformations in Excel! 🚀 Ever needed to quickly change all your text to uppercase, lowercase, or proper case? Whether you're fixing names, titles, or data entries, Excel’s UPPER, LOWER, and PROP

4 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

41 likes

Excel tip to remove chart backgrounds

Get rid of the background and outline on Excel charts #tutorials #excel #exceltips #exceltricks #businesstips

6 likes

The image displays a laptop, a lit candle, and a lamp on a bedside table, with a mirror reflecting a bed. Overlay text reads "Changing Axis Colors in Excel" and "SWIPE," indicating a tutorial.

This image presents an Excel bar chart titled "Actual" showing monthly data from May to September. The Y-axis, representing percentages, has the "5%" label highlighted in red, demonstrating a custom axis color. Text asks how to achieve this effect.

The image shows a screenshot of the Excel "Format Axis" pane, focusing on the "Number" section. It illustrates selecting "Custom" category and entering a format code like "[Red][=0.05]0%;0%;0%" to color a specific percentage value on the axis.

HOW I CHANGE AXIS COLORS IN EXCEL

In my search for more dynamic and visually impactful data representation, I found a powerful feature in Excel – the Format Axis Number Custom Format Code option. This tool allows me to not only present numerical data but also customize the display to highlight specific values. The ability to chang

64 likes

Excel percent format issue trick

Excel percent format issue trick. Fix percentage issues. #tutorial #exceltips #excel #excelpro #exceltricks #exceltutorial #exceltraining

12 likes

Let’s break these excel habits

Do you consider this proficient in Excel?? I can tell you it’s not. My office survival course is for you and can be done in as little as a weekend or during lunch for a week. #exceltraining #tutorial #excel #exceltips #exceltipsandtricks #exceltricks #onlinecourse

36 likes

Lock excel down

BEFORE sharing excel files review which cells allow edits #exceltricks #tutorial #excel #exceltraining #fyp #exceltips #business

25 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

40 likes

Excel list comparison 🌸

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

129 likes

Excel meeting agenda

Whip up a meeting agenda real quick using excel #exceltips #excel #exceltricks #exceltraining #tutorial

27 likes

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

Compare lists in excel

Excel list comparison help #excel #tutorials #exceltips #exceltraining #fyp

6 likes

Excel differences in columns

Find the differences between these columns in Excel with these Excel tricks #excel #exceltraining #exceltips #excel _learning #tutorial #excel_learning #excelforbeginners #fyp

36 likes

Excel tips and tricks

Who is in both columns? Find out which items are on both lists. #exceltips #excel #tutorial #exceltricks #templates

36 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 tip to create a search function

Excel search function #tutorials #excel #exceltraining #exceltricks #exceltips

13 likes

Excel CTRL Shortcuts

Here are the top Excel CTRL Shortcuts! I hope you enjoy this guide and use it to save time at work :) If you want to learn the best time-saving Excel tips, check out my instagram: @excel.withgrant

17 likes

See more