Automatically translated.View original post

476 followers

28 saved

Customized Date the way we want in simple Excel

# Excel easily # Excel the basics # Excel # excelhacks # TheNerdsy

2025/12/20 Edited to

การปรับแต่งวันที่ใน Excel ไม่ได้จำกัดแค่การเปลี่ยนรูปแบบพื้นฐานเท่านั้น คุณสามารถสร้างรูปแบบวันที่ที่เป็นเอกลักษณ์ได้ด้วยรหัสฟอร์แมต (number format code) ที่ Excel รองรับ เช่น การใช้คำสั่ง "dd-mmmm-yyyy" เพื่อแสดงวันที่เต็มรูปแบบ พร้อมชื่อเดือนอย่างเป็นทางการ ประสบการณ์ส่วนตัวที่ผมพบคือ เมื่อทำงานกับข้อมูลจำนวนมากที่มีวันที่ Excel แสดงค่าไม่ตรงตามที่ต้องการ การใช้ฟังก์ชัน Customized Date ช่วยเพิ่มประสิทธิภาพอย่างมาก ทั้งยังช่วยลดข้อผิดพลาดเมื่อต้องนำข้อมูลไปใช้ในระบบอื่นๆ นอกจากนั้น การตั้งค่า Page Layout และการใช้ Developer Tools สามารถช่วยตรวจสอบและปรับแต่งวันที่ให้ออกมาตรงตามความต้องการ โดยที่ไม่ต้องพึ่งพาโปรแกรมเสริมภายนอก หากคุณกำลังค้นหาวิธีเปลี่ยนวันที่ใน Excel ให้ตอบโจทย์การใช้งานของคุณเอง แนะนำให้ทดลองสร้างรหัสฟอร์แมตที่ต่างจากมาตรฐานดู แล้วจะเห็นว่า Excel ยืดหยุ่นและช่วยให้ทำงานของคุณง่ายขึ้นจริงๆ

A vibrant graphic titled 'USEFUL EXCEL FORMULAS' in green, overlaid on a spreadsheet displaying various charts, data tables, and financial figures. The image includes 'Career | Lemon 8' branding and a 'SWIPE' indicator.

A laptop screen showing code, with a text box explaining the 'VLOOKUP' Excel formula. It defines its function for searching large datasets and provides a detailed example. The image is branded 'Career | Lemon 8 | Yun Jung'.

A text box on a wooden desk with a laptop, smartphone, and coffee cup, explaining 'SUMIF & SUMIFS' Excel formulas. It defines their use for adding cells based on conditions and provides a SUMIF example. The image is branded 'Career | Lemon 8 | Yun Jung'.

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

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

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

14 likes

An iPad and an Apple Pencil are displayed on a floral patterned surface, with the text overlay 'how to CUSTOMIZE YOUR IPAD' and sparkling accents.

An iPad shows a lock screen with a black and white star wallpaper from Pinterest. An Apple Pencil and a black Amazon case are also visible on a floral background.

An iPad home screen displays various customized widgets from Wowkit and Widgetsmith, along with images sourced from Pinterest, all set against a star-patterned wallpaper.

how i customized my ipad ⭐️

i love using my ipad and i’m getting more into the customization and ACTUAL practicality part of it all! these are some of the things that i’ve purchased and/or used to make my ipad more me and more fun for me to use :) ⭐️ APPS - Widgetsmith - Wowkit - Pinterest - Procreate ⭐️ TIPS - fi

2187 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

A MacBook and two iPads display a minimal pink aesthetic with the time 10:52, showcasing a customized tech setup.

A MacBook screen shows the Touch ID & Password settings, highlighting the option to add multiple fingerprints for unlocking the device.

The MacBook App Store displays search results for "iwallpaper," showing options to download live wallpaper applications.

how i customized my macbook

how i customized my macbook air — i try to mix it around but love a minimal pink aesthetic apps mentioned: • iwallpaper • desktop flip clock • flow - focus • widgetter • widget wall #macbook pro #macbookcustomization #macbook #macbookrefresh #techfinds #lemon8challenge #ip

2945 likes

A car's infotainment screen displays the Apple CarPlay home screen with various app icons, including Phone, Music, Maps, and Settings, under the title "Clear Apps Apple CarPlay iOS26".

The Apple CarPlay settings menu is shown on a car's screen, highlighting options like "Driving Focus," "Appearance," and "Customize Icons," with instructions to "GO TO SETTINGS AND CLICK CUSTOMIZE ICONS."

A car's infotainment screen shows Apple CarPlay with a pop-up menu offering icon customization choices such as "Default," "Dark," "Clear," "Light," and "Auto," with the text "MAKE YOUR CHOICE FROM THERE."

Customized apps for Apple CarPlay 🤎✨ iOS 26

The new iOS update for Apple CarPlay lets you customize your app appearances! 🤩 seriously obsessed #applecarplay #iPhone #car #ios26 #custom

1649 likes

A refrigerator filled with meal-prepped food, including jars of yogurt with berries, containers of various meals, and fresh produce like spinach, cucumbers, and citrus. Text overlay reads "never struggle with meal prep ideas again."

A smartphone displaying the ChatGPT app icon on its screen, with text instructing to "download & open the chat gpt app." Illustrations of an avocado, cherries, and pomegranate are scattered around.

A smartphone screen shows a ChatGPT prompt asking for a weekly meal prep grocery list for Lidl, specifying high fiber, protein, healthy fats, and under 2000 calories. Explanations for crafting the prompt are provided on the sides.

Customized Meal Prep + Grocery List in Minutes❤️🛒

Are you tired of running out of ideas for breakfast lunch and dinner? Are you trying to hit weight loss goals for the new year? Does making a grocery list overwhelm you? Let me put you on real quick to my favorite app that NEVER runs out of ideas🤏🏽 #chatgpt #mealprepideas #groceryessential

583 likes

Level Up Your Excel Game with VLOOKUP Function! 📈🌟

👉 Welcome to Our Excel Mini-Class! 💡 Today's session is all about VLOOKUP Function in Excel! Ever feel like searching for specific data in a huge spreadsheet is like finding a needle in a haystack? 🧐 VLOOKUP is here to help! With a simple setup, you can make it simple to locate exactly what

8 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

6 likes

HOW I CREATE SPARK-LINES IN EXCEL

What is a sparkline? A sparkline is a small, simple, data-intense graphical representation typically used in line with text to show trends, variations, or patterns in data at a glance. Creating a sparkline in excel is pretty simple. I highlight a range of horizontally organized data and go into

319 likes

A flat lay shows an iPad and an Apple Pencil on a floral patterned surface, with the title 'how to CUSTOMIZE YOUR IPAD' in bold white text, indicating a customization guide.

An iPad lock screen displays a black star wallpaper, date, and time. An Apple Pencil and the iPad's case are labeled, indicating the wallpaper is from Pinterest.

The iPad home screen features various custom widgets from Wowkit and Widgetsmith, including a to-do list, clock, and inspirational quotes, with images sourced from Pinterest.

how i customized my ipad ⭐️

2425 likes

A person holds an AYN Thor handheld console with a customized interface. The top screen displays 'Star Rail,' and the bottom screen shows a grid of app icons. The image has a pink border and text overlay 'How I Customized My AYN Thor'.

Instructions titled 'INSTALL COCOON LAUNCHER' detail how to download and install the .apk file from GitHub, with numbered steps and corresponding screenshots of the GitHub page and file downloads.

Instructions titled 'ADD APPS TO HOME SCREEN' show how to add applications to the AYN Thor's home screen. Screenshots illustrate selecting an empty box, choosing apps, and then adding them to the home screen.

How I customized My AYN Thor 🫧

How I customized my AYN Thor ✨ Finally showing you how I did this! — so here's the full breakdown! Swipe through to see the full process. If you have any questions, comment below. Have you customized your AYN Thor? Drop your pictures in the comments 👇 #aynthor #handheldgaming #coz

146 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

Fast Task Tracking in Excel! 🏃‍♂️✅❌

✨ Welcome to Our Excel Mini-Class! ✨ Hey productivity champs! 🙌 If you’re juggling multiple tasks and need a simple, fast way to track your progress, I’ve got the perfect Excel trick for you! 📊✨ Let’s set up a Done/Not Done Tracker that will keep your tasks organized and help you stay on top

4 likes

Create a Scrolling Data List in Excel Like a Pro💡

✨ Welcome to Our Excel Mini-Class! ✨ Hey, Excel lovers! 🙌 Want to take your spreadsheets to the next level? It’s time to create a scrolling data list—an easy way to manage long data entries without cluttering your sheet!📝💼 Why use a scrolling list? 💫 Save space: Keep your data organized and

1 like

🍒Cherry blossom customized drinks 🍒

All drinks ingredients are tags on each drink‼️‼️ #starbucksorderideas #springbreak #lemon8challenge #starbucksdrinkorder

1041 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

107 likes

A MacBook Pro displays a lock screen with a Golden Gate Bridge wallpaper, showing the time as 6:20 on Thursday, June 27. Text overlays read "My MacBook Pro Setup!" with decorative hearts and sparkles.

A MacBook Pro desktop shows customized folder icons, a battery widget, and a sticky note app. The top bar displays the date, time, and weather, with text annotations pointing to these features.

A MacBook Pro screen displays the "juliakcrist.com/design-freebies" website, showcasing various free design assets for Apple devices, including MacBook and iPad screensavers.

HOW I CUSTOMIZED MY MACBOOK 🌸💻 ✨

This is how I customized my MacBook! I have a neutral/minimal theme going on right now, but I will probably change it soon since we are now in summer! I also like to keep my pointer and highlight color pink of course, but I love how much you can customize everything! I also highly recommend get

433 likes

Excel time stamps

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

54 likes

A laptop displays a Notion dashboard featuring customized headers like "Daily To Dos" and a date, set against a background of a plant and a white tray. The image highlights the aesthetic appeal of personalized Notion pages.

A laptop screen shows the Canva interface, where custom Notion headers are being designed with dimensions of 960x100 pixels. Various header examples like "Projects & Priorities" and "Daily To Dos" are visible, demonstrating creative design options.

A laptop displays the Notion application with a pop-up menu showing media options, specifically highlighting the "Image" selection for uploading or embedding files. This illustrates the step of adding custom-designed headers into a Notion dashboard.

Customized Notion headers?! 💛

I'm in the process of learning all the ins and outs of Notion, but one of the first things I wanted to create was a dashboard template. Essentially a place for anything and everything from to do lists and my weekly schedule to upcoming projects and goals. To organize my dashboard, I wanted t

100 likes

Excel Spreadsheet & Google Sheets Template

Most businesses lose money and time because they forget renewals, licenses, and subscriptions. This template helps you stay fully organized: ✔ Track all expiration dates ✔ Assign renewal owners ✔ Avoid missed deadlines ✔ See everything in one dashboard Built for Excel & Google Sheets.

1 like

Customized Safety Belt follow me!!!

#lanborgini #car #supercar #facebook #instagram If you want this follow me

3 likes

Excel Power Trick: The Magic of Ctrl + Shift! 💡🔥

✨Welcome to Our Excel Mini-Class! 📈 In this session, we’re unlocking the magic of Ctrl + Shift combo to supercharge your Excel workflow! 🚀 Ever found yourself needing to quickly format time, date, currency and percentage? 🙋‍♀️ Ctrl + Shift is your secret weapon! With just a few simple keys, you

5 likes

A green and white graphic titled 'Master Simple Excel Operations', listing five basic Excel tasks: creating a workbook, entering data, adjusting column/row size, inserting/deleting cells, and using functions.

A graphic titled 'Keyboard Function Key Identification' showing a white keyboard layout and a table identifying common keys like Esc, Tab, Caps Lock, Shift, Ctrl, Alt, Enter, Backspace, Sleep, and Wake Up.

Getting Started with Excel: It's Really Simple!

We'll start with the basics, learning about Excel's interface, toolbar, cells, and other fundamental operations. Then, we'll move on to common office shortcuts, as well as some frequently used functions and formulas. #ExcelBasics #ProductivityTips #SpreadsheetSkills #Exce

40 likes

Excel permanent timestamp

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

23 likes

How I customized my Google Drive for school

I used to just throw all my class files into one giant folder labeled “School” and then wonder why I couldn’t find anything when I needed it 😭 But once I finally took time to customize my Google Drive, my life got SO much easier. Here’s how I set it up to make it actually cute and functional:

31 likes

How I customized my phone

iOS 26 ideas #iphoneaesthetic #phoneasthetic

703 likes

5 element customized bracelet. The energy tool to

5 element customized bracelet. The energy tool to healing! #fengshuitips #fengshuilifestyle #energyhealing #5element #5elementbracelet #bracelet #braceletmaking #fengshuisofia

14 likes

3 Powerful Tips to Excel as a Social Worker

Transform lives with these 3 simple tips to thrive as a social worker! 🌟 #SocialWorkSuccess #MakeADifference #makeadifference #empowercommunities

7 likes

Simple ingredient cheesy bread🍕🍕🍕

Yallll this is a go to appetizer - it only takes 3 main ingredients but can easily be customized, ~20 mins start to finish & is sooooo good!! Fill recipe below: Ingredients - 1 ball of pizza dough (my fav is the garlic herb from @Trader Joe’s ) - A drizzle of olive oil & whatever kin

81 likes

How to get customized app icons in 5 seconds ⏱️✨

Give your iPad a personal touch by using the home screen customization feature! Easily swap app icons to match your style, organize your layout, and create a setup that feels uniquely you. It’s so quick and simple! Make your iPad as aesthetic as your vibe. #lemon8partner #ipadhomescreen #

16 likes

Unlock Excel Secrets: Use AVERAGE Like a Pro!

✨ Welcome to Our Excel Mini-Class! 💫 Need to quickly find the average of a range of numbers in Excel? It's easier than you think! Let’s dive into the simple formula to get that mean value in no time. 🙌 Whether you’re crunching data for a project or just organizing your personal stats, th

8 likes

A digital spreadsheet displaying a 'MONTHLY DASHBOARD' for April 2026, showing total net income, expenses, net profit, and profit goal with percentage. It includes pie charts for income and expense overviews and detailed tables of income and expense categories.

A digital spreadsheet showing an 'ANNUAL OVERVIEW P&L' with year-to-date totals for net income, expenses, net profit, and profit goal. It features charts for monthly net profit trends and income vs. expenses, along with a monthly breakdown of income and expenses.

A digital spreadsheet titled 'INCOME TRACKER' displaying a list of income transactions. It includes columns for date, income category, total income, tax, net income, and account, with options to filter by category and showing total income and tax.

US small business bookkeeping made simple

Track income, expenses and taxes in one place. US small business bookkeeping made simple. Excel + Google Sheets. Link in bio. #excel #googlesheets #bookkeeping #smallbusiness #businesstemplate

5 likes

Five smartphone screens display a digital vacation itinerary for Bora Bora, June 15-19, showing sections for main cover, couple, itinerary, outfits, and restaurants, against a tropical beach background.

A smartphone screen shows the main cover of a 'Baccation Getaway Itinerary' for Bora Bora, June 15-19, with a tropical overwater bungalow background.

A smartphone screen displays the 'The Couple' section of the itinerary, featuring circular photos of 'Brittany Renae' and 'Clifford James' against a tropical backdrop.

Want a template customized specifically for you?🥰

NEW LISTING📣 Digital Vacation Itinerary or Birthday Weekend, Girls Trip Template that can be access on Canva🌴🍍What better way to plan your next vacation! WHAT CHANGES CAN YOU BABES MAKE ? ⬇️ - Move/ Resize Text, Images and Elements - Change Fonts + Colors - Remove Images Upload Your Own

19 likes

A MacBook screen displays an Apple Music interface with multiple custom playlist covers, each featuring a unique aesthetic. The text 'customizing my playlists' is overlaid at the bottom, showcasing the personalized look of the music library.

A MacBook screen shows the Canva interface with a new square project open, featuring a cloud and landscape frame. Overlaid text instructs to 'open canva,' 'create new square project,' and 'play around with frames to customize the cover.'

A MacBook screen displays the Pinterest website, showing various images like cars and motorcycles. Overlaid text advises to 'find images for the playlist covers' and suggests using 'own photos, or photos from pinterest!'

how i customized my playlist covers using canva! ✨

hi friends! i recently had the urge to customize all my playlist covers. i really wanted to make them all match so they’d look pretty in my apple music collection and i’m honestly obsessed with the outcome. i used canva to achieve this, and i also have canva pro. these features are all availab

860 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

$An infographic details Excel Custom Formatting, covering its definition, access methods, and syntax for positive, negative, and zero values. It illustrates various operators like numbers, colors, and symbols, alongside examples for formatting dates, conditional formatting, fractions, scientific notation, percentages, custom text, number abbreviations, and using symbols.$