Automatically translated.View original post

EazyIT by Patrick

7079 followers

Follow

Follow

Follow

73 saved

65

Create Excel file random New Year raffle✨

🎄 is nearing the new year. Let's see how to create Excel files. Randomly draw the new year. 🌟

# Excel formula # Lemon 8 Howtoo # Excel # Excel the basics # Teaching excel

2025/12/23 Edited to

นอกจากสูตร Excel ที่ใช้สุ่มจับฉลากแล้ว การจัดการรายชื่อผู้เข้าร่วมและการกำหนดหมายเลขจับฉลากอย่างเป็นระเบียบถือเป็นส่วนสำคัญที่จะทำให้การจับฉลากราบรื่นขึ้นมากครับ ผมแนะนำให้สร้างตารางที่มีคอลัมน์ “No.” เพื่อใส่หมายเลขจับฉลาก และคอลัมน์ "ชื่อ" สำหรับผู้ร่วมเล่น จากนั้นใช้ฟังก์ชัน =RANDBETWEEN() เพื่อสุ่มหมายเลข และ =VLOOKUP() เพื่อดึงชื่อผู้โชคดีออกมาอย่างแม่นยำ นอกจากนี้ควรตั้งค่าให้เครื่องมือกรองข้อมูล (Filter) ทำงาน เพื่อความสะดวกในการจัดการข้อมูลใหญ่ ในกรณีที่ต้องการแจกแจงของขวัญเป็นหมวดหมู่ คุณสามารถเพิ่มคอลัมน์สำหรับระบุประเภทของของขวัญได้ และใช้ Excel Conditional Formatting เพื่อช่วยเน้นหมายเลขหรือชื่อผู้โชคดีเมื่อจับได้ ทำให้การแจกของขวัญเป็นระบบและลดความสับสน สุดท้าย ผมแนะนำให้บันทึกไฟล์ไว้ในรูปแบบ Excel (.xlsx) และสำรองไฟล์ไว้ใน Cloud เพื่อให้สามารถเปิดใช้งานได้ทุกที่และแบ่งปันกับเพื่อนร่วมงานหรือสมาชิกในกลุ่มได้อย่างรวดเร็ว การใช้งานโปรแกรม 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

1180 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 formatting does the same thing as many people using Word #tutorial #exceltips #exceltricks #exceltutorial #exceltraining #worktips #alwayslearning

4948 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

366 likes

How to create a balanced study schedule

Here's a summary of the post, along with some bonus points <3 📚 Assess your courses and workload 🗓️ Determine your available study time ⏰ Set specific time blocks for each subject 🔄 Rotate subjects to maintain focus ☕ Include short breaks between study sessions 🏋️ Make time for e

1051 likes

How to Create a Pie Chart in Excel

How to Create a Pie Chart in Excel #excel #exceltips #exceltutorial #exceltipsandtricks #microsoftexcel

0 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

100 Excel Shortcuts

#excelshortcuts #excelformulas #exceltips

744 likes

A promotional image featuring a woman with text overlay that reads: 'Ultimate office software Cheat Sheet can leverage your career. Get PDF from valder.org'. The image also includes 'lemon8 @wuvalder' branding.

A 'Custom Guide Microsoft® Excel 2021 Basic Quick Reference Guide' cheat sheet, detailing the Excel program screen, keyboard shortcuts, general navigation, getting started, editing, and formatting options.

A 'Custom Guide Microsoft® Excel 2021 Intermediate Quick Reference Guide' cheat sheet, illustrating chart elements, chart options, various chart types, and instructions for creating, modifying, printing, and distributing charts.

my ultimate office software cheatsheet

Let me tell you a little secret: I used to be that person who Googled every single Excel formula, struggled with PowerPoint layouts, and spent way too much time formatting Word documents. Sound familiar? 😅 But then, I decided to take control. I printed out these Ultimate Cheat Sheets for Excel, Po

60 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

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

A computer screen displays Canva's 'Bulk Create' feature, showing how to add data to quickly generate multiple designs. The screen highlights the purpose of the tool for creating hundreds of pages from data sources.

This image illustrates the first two steps of Canva's Bulk Create: choosing a template from various Instagram post options and importing data into a table with fields like title, subtitle, and image.

The image shows the final steps of Canva's Bulk Create: linking imported data fields (title, subtitle, image) to design elements, and then generating multiple personalized designs, exemplified by two flower-themed posts.

Make multiple posts on Canva w/ 4 steps!

Hey content designers! 🎨 Did you know you can save tons of time by using Canva’s Bulk Create feature? Whether you're working on social media posts, invitations, or illustrations, this tool is a game-changer for making multiple designs with ease. Here’s how it works: 1️⃣ Choose Your Templa

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

4451 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

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

2583 likes

Excel formatting tips

Excel formatting tips #tutorials #excel #excelforbeginners #exceltraining

139 likes

3 Steps to Create Your Own Digital Template🍋

Want to start selling digital products? Here are 3 simple steps to create your own digital template—whether it’s for planners, resumes, or social media kits. 1. Pick a Niche & Tool Choose a template type that solves a problem (e.g., content calendar, invoice template). Then choose your to

97 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

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

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

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

44 likes

Excel percent format issue trick

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

11 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

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

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

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

How to create a business budget

Additional Tips: • you can’t excel your business if you’re not investing in it! • what you charge isn’t YOUR income it’s your business income! • do what you love, love what you do! #businessbaddies #budgeting #budgettravel #businessowner #businessgrowth

357 likes

Excel time stamps

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

53 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

How to succeed this school year 📚✏️🎓

With back to school season coming up, here are some tips, tricks, and hacks to help you succeed this year! These will help you excel not only in the classroom, but within different aspects of your life. Prioritizing yourself also contributes to academic success! Let’s have a great school year!! 💝💝💝

280 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

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

This image displays a Microsoft Excel Cheat Sheet covering basic skills, including the program screen, keyboard shortcuts, navigation, and formatting. It features a 'Swipe' overlay, indicating more content is available.

This image shows a Microsoft Excel Cheat Sheet focused on advanced skills, specifically detailing PivotTable elements, fields, layout, and charts. It provides a comprehensive guide to using PivotTables in Excel.

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.

59 likes

Excel signature

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

178 likes

Excel data cleaning tools

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

22 likes

The image displays the title slide for a presentation titled "Create Your First Digital Product," featuring "150 DIGITAL PRODUCT IDEAS" at the bottom. The text is in pink on a dark gray background, with "@DIGITALRICHGRL" at the top and Lemon8 branding at the bottom.

A list of digital product ideas from 1 to 20, including e-books, guides, checklists, templates, and trackers. The title "Digital Product Ideas" is at the top, and Lemon8 branding is at the bottom.

A list of digital product ideas from 21 to 40, such as craft patterns, templates for comics and flyers, gardening guides, and self-care routines. The title "Digital Product Ideas" is at the top, and Lemon8 branding is at the bottom.

Create your first Digital Product 🌸🍋✨✨🫶

#digitalproductideas #digitalskills #digitalsales #digitalopportunity #digitalcreativity

1944 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

A laptop screen displays "5 FREE MUST HAVE Online RESOURCES FOR STUDENTS" with pink flowers and desk organizers in the foreground. The image highlights essential online tools for students.

5 Free Online Must-Have Resources for Students ✨

Hi, lemons! In your student era, as a student navigating the academic landscape, having the right tools at your disposal can significantly glow up your productivity, creativity, and overall learning experience. In this comprehensive guide, I'll spoil the tea on six free and powerful resources t

339 likes

A dark desk setup with a large monitor displaying code and a laptop showing a dashboard, illustrating the concept of selling custom GPTs as AI receptionists to local businesses to make money creating custom voice agents.

A desk setup with a monitor and laptop, overlaid with text detailing 'Step 1: Identify Businesses in Need of an AI Voice Receptionist' and a ChatGPT prompt for generating a list of target businesses with contact information and notes.

A desk setup with a monitor and laptop, featuring text for 'Step 2: Create a Custom GPT in ChatGPT' and instructions to go to chat.openai.com/gpts, click Create, then Configure, for building an AI receptionist.

Selling AI Receptionist Agents To Local Businesses

Local businesses lose money daily from missed calls and no-shows. Here’s how I build and sell a 24/7 AI receptionist using ChatGPT — and charge $200–$500+ for setup and monthly hosting. All steps & prompts below ⤷ Step 1: Identify Businesses That Need an AI Voice Agent Target service bu

58 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

See more