Automatically translated.View original post

40.3K followers

1/11

300 saved

284

9 Excel technique allows faster running x10

# microsoft # Good techniques tell # Excel # Excel formula works # Excel formula

2025/9/19 Edited to

นอกจากเทคนิคต่างๆ ที่แนะนำในบทความนี้ ผมได้ลองใช้สูตร Excel เพื่อคำนวณเปอร์เซ็นต์สำหรับวิเคราะห์ยอดขายและกำไร ซึ่งช่วยให้การประเมินผลเป็นไปอย่างรวดเร็วและถูกต้องมากขึ้น เช่น การใช้สูตร =A2/B2*100 เพื่อให้ได้เปอร์เซ็นต์ง่ายๆ นอกจากนี้ การเลือกแสดงข้อมูลสถิติผ่าน Status Bar ด้านล่างของ Excel ก็ช่วยให้เห็นภาพรวมข้อมูลได้ชัดเจนทันทีโดยไม่ต้องพิมพ์สูตรเพิ่ม ผมยังพบว่า การสร้างชื่อกำหนด (Defined Name) ใน Excel ช่วยให้การเขียนสูตรยากๆ ที่มีค่าคงที่หรือพารามิเตอร์ซับซ้อน เข้าใจง่ายและแก้ไขได้สะดวก เช่น กำหนดชื่อ "สูง" และ "ฐาน" ก่อนนำไปใช้ในสูตร =1/2*สูง*ฐาน เพื่อคำนวณพื้นที่สามเหลี่ยมอย่างรวดเร็ว ในส่วนของการใช้รูปแบบโปรแกรม Excel ที่เหมาะสม การตั้งค่า Quick Access Toolbar ให้มีคำสั่งที่ใช้บ่อยช่วยให้เปิดใช้งานเครื่องมือได้สะดวก พร้อมกับการใช้คีย์ลัดเช่น Ctrl+C, Ctrl+V ลดเวลาในการทำงานซ้ำๆ ได้มาก นอกจากนี้ คำสั่ง Paste Special โดยเฉพาะการคัดลอกความกว้างคอลัมน์ (Column widths) ทำให้ตารางดูเรียบร้อยและประหยัดเวลาจัดรูปแบบอีกด้วย สุดท้าย การเรียนรู้และใช้งานฟังก์ชัน FILTER กรองข้อมูลเฉพาะที่ต้องการ ทำให้งานวิเคราะห์ข้อมูลเป็นระบบและรวดเร็วขึ้น ไว้ผมจะมาแชร์ประสบการณ์เพิ่มเติมในการประยุกต์ฟังก์ชันนี้ในงานจริงภายหลังครับ

A study setup featuring a tablet displaying apps, a pink drink in a clear cup, pens, and a notebook with handwritten notes. The image is overlaid with the text 'Lazy Girl COLLEGE HACKS' and 'GET A HIGH GPA WITHOUT TRYING SO HARD'.

A student in a lecture hall, seen from behind, attentively listening to a professor. Yellow arrows point from the student's head towards the professor, emphasizing focus on the lecture.

An open spiral-bound textbook with colorful tabs and highlighted sections, illustrating the concept of skimming. A yellow arrow points to a specific page.

Lazy Girl College Hacks: 9 Tips for a Higher GPA📚🎓

Yes, I know “why is Chalie posting college content?” I’m here mainly for fitness advice and everything health-related, but I’m also a lifestyle account—and a big part of my life is being a college student and let’s be real—college can be overwhelming, especially when it feels like there’s a never-e

7470 likes

A glass bottle of "Morning Energy Water" filled with lemon and orange slices, and fresh mint leaves. Surrounding images show sliced lemon, sliced orange, fresh mint, and a bowl of sea salt, illustrating the ingredients for this gentle, caffeine-free drink.

Morning Energy Water Lemon 🍋orange mint & salt

Morning Energy Water Lemon + orange + mint + pinch of sea salt The Recipe • 16–20 oz Filtered Water (Room temp or slightly warm is best for digestion) • ½ Lemon (Squeezed fresh) • ½ Orange (Sliced or squeezed for natural sweetness and Vitamin C) • 3–5 Fresh Mint Leaves (Clap them between yo

6081 likes

A person is on a StairMaster, viewed from behind, with text overlay '10 mins of BURN For Big 🍑 & sexy Stomach Summer Glow Up Guide STAIR MASTER ROUTINES'. The image promotes StairMaster routines for glute and stomach transformation.

A text graphic outlining a 10-minute StairMaster Warmup routine with increasing levels (8 to 15) and duration, along with tips on consistency, avoiding handrail reliance, breathing control, and adjusting levels.

A text graphic detailing a 15-minute StairMaster Cool Down routine with varying levels (5 to 15) and duration, providing tips on maintaining consistent steps, not skipping cooldown, breathing, and level adjustment.

Transform Your 🍑 BOOTY & ABS 🔥 One Step at a Time🥵

✨Tips✨ 🩻Posture: Keep your back straight, core engaged, and avoid leaning on the handrails. 💧Hydration: Always stay hydrated, especially during intense workouts. Drink water before, during, and after your exercise. 🦶Foot Placement: Step evenly on each pedal, ensuring you’re using the full

8085 likes

A woman in a green bikini stands on a balcony overlooking the ocean, holding a pineapple. Overlay text reads "5 Exercises You NEED for a Big Booty Thick Thighs," with arrows highlighting her glutes and thighs, promoting a workout guide.

The image details "Barbell Squats" with instructions and rep ranges. An anatomical illustration shows a woman performing the exercise, highlighting the engagement of her quads and glutes.

The image describes "Leg Press" with instructions and rep ranges. An anatomical illustration depicts a woman using a leg press machine, emphasizing the quad muscles.

5 Best Exercises for Juicy Glutes & Thick Quads🍑🔥🍖

Why You Shouldn’t Neglect Your Quads – Even If You're Glute-Obsessed ❤️‍🔥Let’s be real: quads don’t always get the love and attention they deserve, especially if you're anything like me and more focused on building those glutes. Personally, I’ve always been about growing and shaping

2578 likes

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

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

Glute Gains 101: Anatomy, Workouts, and Tips🍑🎯

🍋Before you can start to grow your booty nice and big, you gotta know the muscles that make up your glutes to be able to target 🎯 them! (see slide 9 for visual) ❤️Gluteus Maximus: This is the largest muscle of the three and is located at the back of the hip. It's responsible for hip exten

8726 likes

A person in gray activewear performs a leg curl exercise on a gym machine. Overlay text reads "Thick Thighs Workout Routine 9 WORKOUTS TO GROW QUADS," indicating a guide for building quads and glutes.

Text outlining the anatomy of quads and glutes, listing the four quadriceps muscles (Rectus femoris, Vastus lateralis, Vastus medialis, Vastus intermedius) and the three gluteal muscles (Gluteus maximus, Gluteus medius, Gluteus minimus).

Text detailing key principles for muscle growth, including progressive overload, proper form and range of motion, adequate rest and recovery, and nutrition guidelines for protein and calories.

QUICK Workouts For THICK THIGHS & BIG GLUTES🍑

How to Grow Your Quads and Glutes: The Ultimate Deep Dive Developing strong, well-defined quads and glutes is about more than aesthetics—it’s about creating a powerhouse of lower body strength, improving athletic performance, and enhancing overall functionality. My guide will take a comprehe

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

✨ The French Art of Self-Care: 9 Daily Rituals 🦢

True elegance begins from within, cultivated through the intentional daily rituals we curate for ourselves. Here is your guide to elevating your mind, body, and style with effortless French sophistication. • Write Down Nightly Wins Neuroscience shows that celebrating small achievements stimulat

152 likes

A woman in pink workout attire stretches on a sandy beach with ocean waves in the background. Text overlays read "How I'm Preparing My Body for Summer," "Summer Ready," and "Health & Fitness Tips," with a drawn bikini and sun icon.

A step-by-step guide outlining five key areas to achieve summer body goals: Optimize Nutrition, Effective Workouts, Prioritize Sleep, Stay Hydrated, and Track Progress, with brief explanations for each.

An illustration of a hand demonstrating portion control using different hand measurements for various food types, including fingertip for oils, thumb for nut butter, fist for cereal, cupped hand for nuts, two cupped hands for chips, and palm for protein.

How To Get A Summer Body (Step-by-Step Guide)

It's time to ramp up for that beach-ready body! 🏖️ As the seasons transition and the days grow warmer, shedding those winter layers becomes a top priority for some. If the thought of slipping into a bikini or going shirtless leaves you feeling a bit uneasy, fear not – there's still ample

336 likes

A woman performs a glute bridge exercise with a kettlebell on a mat, with text overlay 'Get Snatched From Home' and 'Sweat It Out at Home'.

An illustration of various glute exercises including Goblet Squat, Weighted Glute Bridge, Bulgarian Split Squat, Fire Hydrants, Wall Sit, and Dumbbell Side Lunge, with sets and reps indicated.

Illustrations of glute exercises like Barbell Squat, Barbell Step-up, Donkey Kicks, Side Leg Raise, and Single Leg Glute Bridge, with a note about alternative workouts and bodyweight exercises.

Snatch your Body from Home by Summer 🤩🍑

Hey ladies, I understand! Not everyone has the luxury of hitting the gym or feels at ease working out in that environment all the time. So, in today's post, I'll provide you with workout examples that you can easily do from the comfort of your home. I'll break it down into full-body

802 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

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

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

7041 likes

A man, Dan Koe, is featured on a dark background with text overlay: "this is how you increase your value FAST" and "You're Supposed To Feel Overwhelmed (How To Learn Any Skill 10x Faster)". It prompts viewers to swipe for 9 takeaways.

The first takeaway states: "Embrace feeling overwhelmed as a sign of growth." It explains that overwhelm indicates expanding your comfort zone, which is essential for learning and personal development.

The second takeaway advises: "Persist through confusion to achieve 'aha' moments." It clarifies that continuing to learn despite confusion leads to sudden insights and understanding.

How To Learn Any Skill 10x Faster

9 key takeaways from Dan Koe’s latest content. 1) Embrace feeling overwhelmed as a sign of growth. - Repetition in uncomfortable situations builds mental muscle like physical training. - Avoiding discomfort hinders growth and understanding in various domains. - Overcoming overwhelm leads to

5 likes

A woman in athletic wear performs a lunge in a gym, with text overlay "PILATES BODY How to Get it Without Pilates".

Text comparing Pilates and weight training, defining weight training, and listing benefits like building muscles and burning calories faster.

Line drawings illustrate six exercises: Ab Crunch Machine, Swiss Ball Leg Lifts, Kneeling Cable Crunch, Seated Bench Leg Pull-In, Weighted Glute Bridge, and Weighted/Russian Twist.

Achieve the Pilates Body with Weights: Get Toned🍑🥵

🍋What is Pilates? Pilates is a form of low-impact exercise that focuses on strengthening muscles while improving postural alignment and flexibility. It was developed by Joseph Pilates in the early 20th century and emphasizes controlled movements, core strength, and body awareness. Pilates ca

507 likes

A screenshot of the uBlock Origin Chrome extension page, showing its features, ratings, and user count, with a red overlay highlighting "1. Ad blocker duhhh."

A screenshot of the NaturalReader - AI Text to Speech Chrome extension page, detailing its features, ratings, and user count, with a red overlay stating "2. Natural Reader too lazy to read lol."

Top 6 Chrome extensions I can't live without! 👩‍💻

If you are using chrome without these extensions..... wyd??? 💻 1. Ad Blocker EVERYBODY needs ad blocker! This one even seems to work on YouTube, but I also have second ad blocker just in case. 💻 2. Natural reader Has anyone ever sent you a BORING document, and you're thinking...

1625 likes

A person in pink leggings and a white top stands in a gym, looking down at their midsection. Overlay text asks, "Let's Talk Cardio Or Weights? Which is better for weight loss?" and lists options like Weights, Treadmill, Jump rope, Elliptical, and More.

Text discusses calorie burn differences between cardio and weight training, noting that cardio burns more calories per session, while weight training boosts metabolism and offers a significant post-workout calorie burn for up to 38 hours.

Text explains that HIIT burns 25-30% more calories than other exercises and that combining cardio with weights is most effective for weight, fat loss, and muscle gain, as weight training alone is not as effective.

❤️‍🔥Ways to Lose Weight and Burn Fat❤️‍🔥

Research suggests that relying solely on weight training isn’t as effective as incorporating cardio into your fitness routine. It's disheartening to see some "fitness experts" on this app pushing weightlifting as the exclusive solution, only to promote their own programs. As someone

1433 likes

A woman in white athletic wear runs along a waterfront path with a city skyline in the background, featuring the title "3 Ways to Get Faster at Running."

A first-person view of a runner in pink and orange athletic wear on a path, with a green field and cloudy sky, displaying the first tip: "Take your easy days easy!"

Two women in athletic tops and shorts run together on a boardwalk by a river, with city buildings in the background, illustrating the second tip: "1-2 speed runs per week!"

How to Run Faster

If you are wanting to run faster these are 3 important tips! Take your easy days EASY! Majority of your runs should be at a slow pace because it’s easier on your body and will allow your body to recover properly. It also allows you to run for longer and have a higher weekly mileage. Speed runs 1-2

297 likes

A woman in grey athletic wear stands with her back to the camera, showcasing her physique. Overlay text reads "That Girl Hobbies," "HIGH ENERGY LOW ENERGY," and "Becoming a Better You."

A person with a backpack and hiking poles is seen from behind on a trail. A white box lists "HIGH ENERGY HOBBIES" including running, CrossFit, cycling, and martial arts.

A blue sky with white clouds forms the background for a white box listing "LOW ENERGY HOBBIES" such as yoga, meditation, gardening, and reading.

50 Hobbies To Become Healthier & More Feminine ✨🌸🍋

✨Allocate 20% of Your Time for Hobbies✨ It's crucial to dedicate a portion of your day to engaging in interesting hobbies. It's good for your personal growth and happiness. ✨Tips for Choosing Hobbies✨ Just start doing something: Its importance to take action and experiment with var

2343 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 person in a gym, holding a phone, showcasing their muscular arm. Overlay text reads "Progressive Overload Techniques HOW TO FORCE MUSCLE GROWTH WHEN IT'S JUST NOT GROWING."

Text defining "Progressive Overload" as gradually increasing stress on muscles, achievable by increasing weight, reps/sets, reducing rest time, improving form, or using advanced techniques.

Text titled "Start with a Baseline" outlining steps: determine starting weights, track numbers, and assess technique. A barbell is shown at the bottom.

BEST Ways to Progressive Overload for Huge Gains💪🔥

✨Progressive overload✨ is a principle in strength training where you gradually increase the demands placed on your muscles over time to continually challenge them 😌 This can involve increasing the weight lifted, the number of repetitions performed, or the intensity of the workout. ✨The goal✨ is

295 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

Trainer Approved Tips for Glute Growth 💡

Want stronger, fuller glutes? These tips will help you see faster results. 1️⃣ Train glutes 2–3 times per week. This allows for optimal stimulation and enough recovery between sessions. 2️⃣ Mix heavy, low-rep lifts (like hip thrusts and deadlifts) with high-rep glute isolation exercises (like d

80 likes

4 Exercises you NEED for Building Your Best Glutes

If you're looking to build strong, shapely glutes, focusing on the right exercises and perfecting your form is key. In this post, Ill go over the four essential exercises for building glutes, complete with examples, tips, and tricks. I also cover the optimal order for your workout and p

171 likes

A dark, stylized image featuring a woman in black, with text overlayed that reads "NEW YEAR NEW ERA GLOW UP 2025." It serves as an introductory slide for a glow-up guide.

A '2025 Glow Up Plan: Mindset Edition' outlining actions for shifting to an abundance mindset, practicing self-compassion, believing in your vision, and staying grateful, accompanied by four small lifestyle photos.

A text-based image detailing 'Step 2: Declutter your phone' for the new year. It provides tips for managing social media, deleting old photos and emails, and organizing phone content.

New Year, New You Glow Up 2025 😏🖤

As we approach the new year, many of us start thinking about ways we can improve our appearance and health. Luckily, there are a few small changes we can make that can have a big impact. Here are seven tips to help you get started on your glow up journey for the new year: • Drink More Water:

1598 likes

The image features the title 'HOW TO BUILD YOUR MIND MUSCLE CONNECTION' with a pink brain and a highlighted glute muscle, emphasizing the link between mind and body in fitness.

This image explains the mind-muscle connection for bicep growth, illustrating concentric, eccentric, and isometric contractions with bicep curl examples to achieve increased strength and faster muscle growth.

The image describes 'Mindset Shift' and 'Visualization Techniques' as crucial methods to improve mind-muscle connection, focusing on engaging targeted muscles and mentally picturing muscle work.

Big Gains & Glutes = Strong🧠Mind-Muscle💪Connection

Let's talk about the all-important 🧠 mind-muscle💪connection. It's not just about going through the motions; it's about really tuning in to the muscles you're working. So, when you're hitting those squats or curls, focus your mind on the muscle you're targeting. Feel the

1081 likes

Why God allows us to suffer…

Romans 5:3-5 "We also glory in our sufferings, because we know that suffering produces perseverance; perseverance, character; and character, hope" James 1:2-4 "Consider it pure joy, my brothers and sisters, whenever you face trials of many kinds, because you know that the testing of

1803 likes

A smiling image of Jeff Bezos with a smaller circular inset of his face. The text overlay reads "10 SECRET WEBSITES THAT FEEL LIKE THEY ARE ILLEGAL."

A screenshot of the Decktopus AI website, an all-in-one AI slide generator for creating professional presentations, proposals, and microsites quickly.

A screenshot of the AskYourPDF website, an AI-powered chat system that allows users to interact with PDF documents efficiently.

10 SECRET WEBSITES THAT FEEL LIKE THEY ARE ILLEGAL

#lemon8careers #lemon8business #lemon8challenge #follow #share

4 likes

Best Note Taking Tips! (For All Note Takers) 📝

Hello! Im back with more tips for a successful school career! 📓 Summary: To effectively take notes, try: - Using colors - Using visuals - Mark important info - Use well known note taking techniques - Set your environment Taking notes by hand has been found to be more effective than ty

30 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.$