Automatically translated.View original post

EazyIT by Patrick

6967 followers

Follow

Follow

Follow

107 saved

149

How to split date to date on Excel

How to split dates into days and months on Excel 🥳

# Excel # Excel formula # Excel the basics # exceltips # Lemon 8 Howtoo

2025/10/18 Edited to

นอกจากสูตรพื้นฐานแยกวัน เดือน ปี ใน Excel แล้ว ยังมีฟังก์ชันที่ช่วยให้คุณจัดการกับข้อมูลวันที่ได้ยืดหยุ่นขึ้น เช่น การใช้สูตร TEXT เพื่อแสดงวันในรูปแบบชื่อวัน เช่น พฤหัสบดี หรือใช้งานฟังก์ชัน DATE และ YEAR เพื่อนำวันที่ที่แบ่งแยกแล้วมาประกอบเป็นวันที่ใหม่ หนึ่งสิ่งที่ผมชอบใช้บ่อย ๆ คือการใช้ฟังก์ชัน DATE ผ่านสูตร =DATE(ปี,เดือน,วัน) ซึ่งช่วยให้ง่ายต่อการบวกลบวัน เดือน หรือปีในช่วงเวลาที่ต้องการ นอกจากนี้ยังมีเคล็ดลับการเลือกใช้ตัวจัดรูปแบบวันที่ (Format Cells) เพื่อให้แสดงผลวันที่ตามรูปแบบที่ต้องการ ทั้งแบบ วัน/เดือน/ปี หรือ เดือน วัน ปี ตามแต่การใช้งาน เทคนิคการใช้ปุ่ม Fill Handle เพื่อกรอกวันที่ต่อเนื่อง และการตั้งค่า Date and Time Picker Add-in ฟรีสำหรับ 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

1175 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

363 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

2718 likes

Excel formatting tips

Excel formatting tips #tutorials #excel #excelforbeginners #exceltraining

153 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

868 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

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

528 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 cheat sheet

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

14 likes

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

4938 likes

100 Excel Shortcuts

#excelshortcuts #excelformulas #exceltips

744 likes

A person sitting on the floor, holding a phone and wearing headphones, with the text overlay 'How to make A COLLEGE Assignment Master List' and an arrow pointing right.

A screenshot of a Notion 'Applied Linear Algebra Schedule' table showing assignments, dates, types, topics, and weights, with text indicating it was made in Notion using a 'Course Schedule' template and suggesting Google Sheets or Excel as alternatives.

A detailed view of the Notion assignment master list, highlighting columns for 'Assignment name', 'Due date', 'Type of assignment', 'Topics covered', and 'Points or weight'.

How To Make An Assignment Master List!!

🦋You might be wondering how some people stay so organized and on top of their assignments! This is one of the tools that I create for myself at the beginning of every semester. My assignment master list is the single thing that keeps me on track throughout the whole semester! Before I got in the

2976 likes

Project timeline using excel

Project timeline how to using excel #projectmanagement #excel #exceltricks #exceltutorial #tutorials

11 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

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

295 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 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

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 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 #

4400 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

Must-Know Excel Tip for Busy Days! ⏰ 🥰

✨ Welcome to Our Excel Mini-Class! 📈 In this session, we’re unveiling the magic of Text to Columns! 🤓 Have you ever had a long list of data all in one cell and wished you could separate it into neat, organized columns? Well, now you can—with just a few clicks! 🔥 No more messy data or manual cutt

4 likes

RANDBETWEEN() Function in Excel

How to use RANDBETWEEN() Function in Excel #excel #exceltips #exceltipsandtricks #exceltutorial #microsoftexcel

0 likes

Excel list comparison 🌸

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

128 likes

A young woman wearing headphones and glasses, holding a phone, sits on the floor. The image has a text overlay "THE BEST TIPS FOR STUDENTS TO GET A 4.0".

A laptop screen shows a daily schedule, next to white headphones and a notebook on a bed. An overlay advises to "Plan out your day, every day" for studying, breaks, hobbies, and socializing.

A person wearing headphones studies at a desk with a computer, tablet, and a small timer. An overlay suggests to "Set a timer for your study session and practice the pomodoro technique."

Best Tips For Students To Get A 4.0!!

Here are some of my best tips as a dean's list student, to get a 4.0 in college!! 🗓️Plan out your day - this is something that I try to do every single day. I schedule my study sessions, classes, breaks, and even my meals so I know exactly how much time I have in the day. Even on my days off

957 likes

How to insert a time stamp in a spreadsheet

How to insert a time stamp in a spreadsheet #tutorials #spreadsheet #work #google sheets #hacked

171 likes

How to Find Cube Roots in Excel

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

0 likes

Excel signature

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

176 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

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

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

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

Lock excel down

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

25 likes

Master Totals in Excel: SUM, SUMIF & SUMIFS! 📊✨

✨ Welcome to Our Excel Mini-Class! 👋 In today’s quick Excel class, we’re diving into three must-know functions for fast and accurate totals! 🧮 Whether you’re summing up expenses, grades, or any data, these functions will save you serious time! ⏱️💼 Whether it's a simple question, a specific c

4 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

A Google Sheets-based 2025 content calendar for January and February, displaying an annual summary, monthly summaries for various platforms, and a published posts breakdown, with the overlay text "effective content planning tips."

A close-up of the 2025 content calendar setup for January, overlaid with the text "1. Use answerthepublic.com to brainstorm content ideas" and a screenshot of the answerthepublic.com website showing search results for "google sheets."

A close-up of the 2025 content calendar setup for January, with the text "2. Record your ideas so you don't forget!!!" and "I use Google Sheets & this is me setting up my content calendar," showing a dropdown list of items.

How I Content Plan In Google Sheets 🤌

(and post consistently while staying motivated) When I first started posting on L8, I had tons of idea for creating content but would hit a sluggish period like having a writers block when deciding what content should I post & when. A lot of it was trial and experimenting to understand what

101 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

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

331 likes

How to Create an Email ID using CONCAT in Excel

How to Create an Email ID using CONCAT Function in Excel #exceltraining #exceltricks #exceltutorial #excelsheets #msexcel

1 like

How to use PRODUCT Function in Excel

How to use PRODUCT Function in Excel #excel #exceltips #exceltricks #exceltutorial #microsoftexcel

0 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

Why use SQL/Python for Data Analysis, (not excel?)

Hello everyone! SQL and Python are favored over Excel for data analysis due to their efficiency with large datasets and automation capabilities. Python, using libraries like Pandas, ensures reproducible workflows, while SQL handles complex data manipulations with ease in relational databases. Pytho

90 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

74 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

Back To SchoolTips / How to use Google Sheets

I’m such a nerd for google sheets I literally love making them :( If you don’t know how to use excel or sheets i HIGHLY recommend looking up a tutorial because it’s actually a really useful skill. #BackToSchool #lemon8challenge #collegestudent #schooltips #googlesheets

111 likes

See more