Automatically translated.View original post

ไอทีฉบับคุณน้า

6607 followers

Follow

Follow

Follow

1/3

58 saved

53

Includes Excel commands that save time.

Works 10 times faster with basic Excel commands used by office people every day. 💻

Who is still typing by himself?..Let's use these formulas. 😉

# Excel working age # Excel easily # Total IT Trick # IT should know # IT omniscient

2025/11/11 Edited to

นอกจากคำสั่งพื้นฐานที่ช่วยประหยัดเวลาแล้ว อยากแนะนำให้ลองใช้คำสั่งลัดเหล่านี้บน Excel ที่ช่วยเพิ่มความสะดวกรวดเร็วได้อีกมาก เช่น - Ctrl + D เพื่อคัดลอกสูตรจากเซลล์บนลงมา ซึ่งช่วยลดเวลาการพิมพ์สูตรซ้ำๆ - Ctrl + Shift + L เป็นคำสั่งใส่ตัวกรอง (Filter) ที่ทำให้การกรองข้อมูลทำได้ง่ายขึ้นมาก - Alt + → เป็นคำสั่งที่จะช่วยใส่สูตร SUM อัตโนมัติโดยไม่ต้องพิมพ์เอง - Ctrl + ; (เซมิโคลอน) ใช้แทรกวันที่ปัจจุบันลงไปในเซลล์อย่างรวดเร็ว - Ctrl + Shift + $ เพื่อแปลงค่าตัวเลขในเซลล์เป็นหน่วยเงินตามรูปแบบที่กำหนด ผมลองใช้คำสั่งพวกนี้ในงานประจำดูแล้วรู้สึกว่าการทำงานเร็วขึ้นจริงๆ ไม่ต้องเสียเวลาพิมพ์หรือคลิกเมนูนานๆ ช่วยให้ชีวิตง่ายขึ้นมากสำหรับคนที่ใช้ Excel ทุกวัน ลองฝึกใช้ทีละคำสั่งและปรับให้เข้ากับงานของคุณ รับรองว่าสูตรและคำสั่งเหล่านี้จะช่วยประหยัดเวลาที่ทำงานอย่างเห็นผล

Related posts

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

1210 likes

A laptop screen displays code with the title 'Top Git Commands Every Developer Must Know!' and text 'Boost your coding workflow with these essential Git commands!'. The image highlights the importance of Git for software engineers and web development.

An illustration shows four people collaborating around a table, symbolizing teamwork. Text explains 'Why Git Matters?', detailing Git as a version control system that helps developers manage code, collaborate, and revert mistakes efficiently.

Top Git Commands Every Developer Must Know!

#github #programmingtips #softwareengineer #studymotivations #webdevelopment

53 likes

Excel time stamps

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

54 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

A title image for an article about 10 hidden Siri commands, featuring pink text on a background of pink floral walls and dark pink booth seating. It includes phrases like 'OWN YOUR MAGIC LADIES!' and 'BE POWERFUL'.

This image lists two Siri commands: 'HEY SIRI, REMEMBER THIS!' with brain and pin emojis, and 'HEY SIRI, READ MY LAST EMAIL' with email and ear emojis. It's set against a pink floral and booth background.

This image lists two Siri commands: 'HEY SIRI, TAKE A SELFIE!' with selfie stick and camera emojis, and 'HEY SIRI, WHAT PLANES ARE FLYING OVERHEAD?' with plane and globe emojis. It's set against a pink floral and booth background.

✨🍋10 Hidden Siri Commands You NEED NOW!!!😭🥳✨

We all know Siri can answer questions, set reminders, and tell us the weather, but did you know she can do a lot more? There are tons of hidden features that most people aren’t even aware of! Whether you’re trying to be more productive or just have some fun, here are 10 Siri commands that will tota

12.6K likes

Senior Tier 2 (Remote)

#momsoflemon8 #jobs #fyplemon #beauty #content

32 likes

A guide titled 'HOW TO GIVE CHATGPT COMMANDS PROPERLY' lists four key tips: be clear about what you want, give context, use a specific prompt formula (role, format, topic, audience, tone), and provide examples when possible. Each tip includes examples for effective ChatGPT prompting.

Giving ChatGPT proper commands (aka prompts)

✅ How to Give ChatGPT Commands Properly 1. Be Clear About What You Want ✅ Instead of: “Write something about content” 🔥 Try: “Write a 3-sentence Instagram caption about batching content as a busy mompreneur.” ⸻ 2. Give Context ✅ Add who it’s for, what your tone is, and what platform

261 likes

TWITCH CUSTOM COMMANDS 🧸

doing a Mac version next, but this is how you get twitch commands from your streamer account or a bot account with a custom name ☺️ #streamertips #mixitup #twitch

39 likes

A pink mechanical keyboard with glowing keys and colorful string lights, overlaid with text that reads "LEARN SOFTWARE DEV FOR FREE 6 RESOURCES," indicating a guide to free software development learning.

A guide titled "1. LEARN THE INTERNET" for beginners, listing key concepts like HTTPS and DNS. It recommends "Front End Masters - Sections 1-4" and shows the cover of "The Front End Developer/Engineer Handbook 2024."

A guide titled "2. LEARN HTML/CSS" for beginners, highlighting key concepts like web page structure and CSS Flexbox. It recommends "FreeCodeCamp - Responsive Web Design Course" and displays a screenshot of the course page.

Study to be a Frontend Dev - Roadmap (100% Free)

This is a study guide for becoming a Front End Developer! All resources mentioned are FREE. Don’t pay anyone for this info! Why am I not recommending a zero to job course? Two Reasons 1-There is no course that will teach you everything 2-You need to put in some sweat equity, only wat

683 likes

Separate tab for excel notes

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

37 likes

tips for a God honoring relationship

In this world we get a lot of mixed and confusing messages. Sometimes it is so overwhelming and we are at a loss for words for what we are supposed to do. That’s why following God is so awesome! His message is clear and easy to understand. Following God means striving to be a Christ like example to

23 likes

30 Spanish commands for speech therapy

Looking for an easy way to target **following directions** during play? These **30 Spanish commands** are designed to keep learning natural, engaging, and movement-based while supporting language development. Perfect for speech therapy sessions, bilingual classrooms, special education settings, and

3 likes

No excel? No worries, try out Google sheets!

Ive been using Google sheets to keep track of my spending habits for my vacation trips and it's been a great alternative. If you don't have excel, definitely check out google sheets. I love using google sheets since it's easy to share the file with my friends since most of them use gmai

21 likes

User management commands for Linux

Even on a single-user Linux system, multiple accounts keep root actions separate, run services with least privilege, and let you test things without breaking your main environment. Here are essential Linux commands for user management 😎👆 Find high-res pdf ebooks with all my Linux related info

2 likes

✨Guide to getting big sh*t done ✨ motivating people to action in low-trust, high-stakes environments. ✨ learn to make new and deeper connections to ourselves, to each other, and to the natural world around us. #read #recommendedbooks #learn #motivation

317 likes

A colorful title slide for a "ChatGPT Guide for Beginners" highlighting key terms, prompt structures, tones, and formats, with an instruction to "Slide to Learn" and a "1/5" indicator.

A slide detailing "Key Terms" for ChatGPT, such as MODEL, PROMPT, INPUT, OUTPUT, TOKEN, and TRAINING DATA, alongside "Key Uses" like summarizing, brainstorming, writing, and coding, with a "2/5" indicator.

A slide presenting various "Commands" and "Tones" for ChatGPT, including ACT AS, BRAINSTORM, PROFESSIONAL, FRIENDLY, and EMPATHETIC, to enhance AI versatility, with a "3/5" indicator.

Beginners guide to ChatGPT

Feeling stuck with ChatGPT or not getting the results you want? This 5-slide beginner guide breaks it all down for you in the simplest, most aesthetic way possible. From understanding key terms to using the right tones, formats, and prompt structures, this is your go-to cheatsheet to get smarter,

1120 likes

Luxury doesn’t ask for attention — it commands it.

SUVs that redefine class. Power, comfort, and style — all in one ride. 🚘✨ #BhuttaLimo #LuxuryOnWheels #ChicagoSUVs #RideInStyle #LuxuryLifestyle

1 like

Excel permanent timestamp

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

23 likes

Recover Deleted Files Using Terminal Commands

Accidentally wiped important files on Windows/macOS/Linux? This video shows how to use terminal and command-line recovery methods to restore deleted data before it gets permanently overwritten. #cmdanks #datarecovery #windows11 #linux #TechTips

4 likes

An open Bible displaying pages from Matthew 4 and 5, featuring handwritten notes, highlighting, and underlined text. The overlay text reads "THERE ARE PARTS IN MY BIBLE THAT LOOK LIKE THIS:".

There are parts in my Bible that look like this:

It’s okay! Don’t feel discouraged that your Bible isn’t completely covered on every page. It’s your pace and your journey with God. 💗 #readingmybible #readingthroughmybible #mybible #biblestudy #biblejournaling #christian #christiangirl #godisgood #Lemon8 #Lemon8Diary

71 likes

Just starting your nursing journey? 🩺

Are you a new nurse 👩🏽‍⚕️just starting out… or maybe your a Nursing Student needing extra resources to be successful. Whatever the case, check out some of these ONE OF A KIND resources you wont find anywhere else. 📚🩺 You can find them ALL at Nursebodyguard.org 📌Link in the bio! You wouldn’t go t

40 likes

Russian Commands respect lol

My dogs know and listen to the English language. If I was to give a command in Russian I would automatically Tump the English language. Lol. #Russian #Dogs #HelloLemon8 #dogtraining #petfriendly

3 likes

She commands the dead but at what cost?

🎧📚AudioBook Review…Mistress of Bones by Maria Z. Medina Narrated by: Frankie Corzo Azul del Arroyo is a necromancer with one goal: steal her sister back from Death. Literally. But nothing in this beautifully strange world is ever that simple. Between a seductive Emissary of Death, a witch who de

3 likes

A pink-themed desk setup with a computer displaying the Text Blaze extension interface, showing an email template. Overlaid text reads 'SWIPE TO VIEW' and 'Use this extension to save time'.

A screenshot of the Text Blaze extension interface, demonstrating how to create and use snippets like '/emailreminder' for repetitive text, with customizable fields for an email reminder template.

A detailed view of Text Blaze's dynamic commands, showcasing various customizable features like date/time insertion, clipboard content, cursor placement, and form fields (text, paragraph, dropdown, toggle, date/time).

the ultimate time-saving extension!

‧°𐐪♡𐑂°‧₊ ✨ This chrome extension is perfect for anyone who wishes they had a quick way to write repetitive text (reminder emails, meetings, etc)! It’s called “text blaze” where you can create snippets or shortcuts to create a small/large text snippet for you! For example, if you always need to wr

155 likes

Linux commands for hardware information

Knowing your hardware is essential for effective troubleshooting, system tuning, and performance optimization. That’s why it’s important to be familiar with the OS tools that let you examine different parts of your system’s hardware Here are a list of useful Linux commands for looking up hardwar

4 likes

Linux user management commands

Even on a single-user Linux system, having multiple user accounts is important for separating administrative tasks, securely running background services, and safely experimenting without affecting your main environment Here are essential Linux commands for user management 😎👆 #devops #softwar

5 likes

best networking commands to use

I use these networking commands to troubleshoot where my data and messages are going try these commands on a terminal windows Mac or Linux you might be surprised what you find follow share like and visit infotechmentor.com #informationtechnology #infotechmentor #techcareer #te

3 likes

A simple way to keep co-parenting records

Co-parenting can get complicated — especially when visits or phone calls don’t go as planned. This tracker helps you keep everything documented in one place: visits, phone calls, late arrivals, declined visits, and notes for each day. ✔️ Automatically updates for any year ✔️ Clear monthly &a

106 likes

Tips to save your life ‼️🙌🏾

Jesus is in every plan we make ‼️🌟 He’s literally our savior when we are ready for him to be. Most people believe praising him only when he’s gifting blessings is okay, but it’s not. He needs to be talked to you, and he needs to know that you love him with or without the blessings. 🌟🤎 Talk to him a

30 likes

A close-up image shows a person's tongue engulfed in flames and smoke, illustrating the powerful impact of words. The text overlay reads, "POWER OF THE TONGUE IS REAL, STOP CURSING YOUR OWN LIFE: SWIPE LEFT."

White background with black text stating, "Every time you say: 'I'm tired.' 'I'm broke.' 'I'm depressed.' ...your brain believes it."

White background with black text explaining, "Words are commands to your subconscious. You're programming your future without realizing it."

Good morning 🌸 This is For You🤩✨ Read below 👇🏿

Be careful what you say about yourself. Be careful what you speak over your life. Be careful what you confess—especially in moments of frustration, fear, and exhaustion. Because your mouth is not just talking… your mouth is planting seeds. So many of us are praying for breakthrough while s

2197 likes

✨ Building Two Paths, One Goal ✨

🚀 Changing careers doesn’t mean putting your business dreams on hold—it means learning how to balance both! Right now, I’m on a cybersecurity certificate journey 📚 while still growing Dunlap Signature And Notary Services, LLC. Every day, I’m proving that you can pivot into a new industry and sti

54 likes

"Grace commands the respect that force can't hold"

A Queen’s strength is not in fear or might, but in the quiet authority of grace. Respect given freely outlasts respect taken by force. #QueensJewels #Respect #Grace #QueenEnergy #Royalties

0 likes

Organize your shared custody in one place

A simple way to organize shared custody ✨ One spreadsheet with an auto-updating calendar, hours tracker, and monthly summary per co-parent. Link in bio 👆 Perfect for organized co-parents who want a clear, stress-free way to plan parenting time. Works for any month and any year — Excel & Google

2 likes

Justin Bieber Commands Coachella Weekend 2: Throwbacks, Star Guests

Justin Bieber Commands Coachella Weekend 2: Throwbacks, Star Guests, and Pure Connection Justin Bieber returned to the Coachella Stage on Saturday, April 18, for Weekend 2 and delivered a headline set that blended nostalgia with raw energy. Performing at 11:25 p.m. on the main stage, the pop star

0 likes

A pink aesthetic flat lay shows a laptop, notebook, pen, USB hub, a drink, and a bowl of food on a bed. Overlay text reads: 'back to school Discounts you need to know about!' with a Lemon8 username.

A graphic titled 'STUDENT DISCOUNTS' displays logos and discount percentages for various services including Amazon Prime, Spotify, Office 365, Walmart, Headspace, Notion, Apple, Adobe Creative Cloud, and Hulu.

A graphic titled 'STUDENT DISCOUNTS' lists fast-food and chain restaurants offering student discounts, such as Arby's, Burger King, Chick-fil-A, Chipotle, Dunkin', Domino's Pizza, Taco Bell, Subway, and Waffle House.

🎓STUDENT DISCOUNTS YOU NEED TO KNOW ABOUT 🎓

Because college is expensive and you deserve a win. Whether you’re heading to class, decorating your dorm, or just trying to survive off iced coffee and vibes—here’s your ultimate student discount cheat sheet 🔖👇 ⸻ 💻 Tech & Subscriptions Big brain energy, small price tags: 🧠 Adobe Creat

4818 likes

Voice Commands in Nioh 2

#Voicecontrol #Voicecommands #pcgaming

1 like

The image displays a keyboard with a yellow arrow pointing from the Alt key to the numeric keypad, illustrating how to use Alt codes. Below the keyboard, a list provides numerous Alt codes for various symbols, including trademark, copyright, degree, heart, diamond, arrows, music notes, and mathematical signs.

Master Keyboard Symbols: Easy Alt Commands 🔑ℹ️⬇️

Unlock the power of your keyboard with these simple Alt commands. Whether you’re crafting documents, designing graphics, or just having fun, knowing these shortcuts can save you time and add a touch of flair to your work. Dive into this guide and become a symbol-savvy pro! How to Make Symbols wi

6 likes

✨Core Commands of Jesus✨

55 likes

Jesus can save you 🫵🏾💞

The scriptures encourages us to become like Jesus Christ and “to walk, even as he walked” ( 1 John 2:6). But taking that first step can be difficult especially when you don’t know how to begin. You’ll find help by reading the Bible, studying the Bible, at Church, gospel songs, and etc,. Christ is c

26 likes

Prayers when flying | Save & Share

I flew for the first time since there has been an increase in aircraft accidents. The nervousness would come and go. I prayed a lot, not just for my flight but every time I saw a plane in the sky. The morning of my flight, I had peace. 🙌🏾 When I arrived at the airport, I prayed and thanked God

18 likes

So many Angular commands to remember lol

…That’s why I take notes! 😆 I refuse to act like I remember it all. Bc sometimes my brain is just too scattered to recall and time is too precious to sit there and think think think when it’s right in your notes! Cheers to notes📝🥂 #wfh #coding #angular #google #ipadpro #goodnotes

154 likes

“She commands the flames”

#witch #witchesoflemon8 #fantasy #witchesoflemon #witchcraft101

5 likes

Human anatomy notes 💋

I love making my notes cute 🥰 #studyinganatomy #notesforbiology #anatomyandphysiology #notes ✔️

30 likes

See more