Activity
Mon
Wed
Fri
Sun
Feb
Mar
Apr
May
Jun
Jul
Aug
Sep
Oct
Nov
Dec
Jan
What is this?
Less
More

Owned by Mark

Spreadsheet Mastery

113 members โ€ข Free

A community to simplify Excel. From basics to advanced tools, discover tips and tutorials to work smarter and achieve mastery.

8 contributions to Spreadsheet Mastery
Excel SOS: comment FIX and Iโ€™ll solve yours (first 5)
Got an Excel problem? Comment FIX and paste either: - a screenshot, or - 10 rows of sample data (fake is fine) Include 2 lines: 1. what you want the result to be 2. which Excel youโ€™re on (365 / 2019 etc) Iโ€™ll pick the first 5 and reply with:โœ… the exact formula and where to put itโœ… a cleaner version if your data is messy
0
0
Whatโ€™s your #1 Excel headache right now?
Hey! ๐Ÿ‘‹ Whatโ€™s the one thing in Excel thatโ€™s slowing you down this week? Reply with: 1. The task (e.g., โ€œmatching names across sheetsโ€) 2. What youโ€™ve tried 3. A tiny sample (just column names is fine)Iโ€™ll pick a few and post quick fixes for everyone. ๐Ÿ™Œ
0
0
Micro-Automations in Excel โ€” Small tricks, big time-saves
This week, letโ€™s share the tiny Excel wins that save us HOURS over a month. Post one thing youโ€™ve automated or streamlined and show the before/after. Starter ideas: - Swap VLOOKUP โ†’ XLOOKUP with multiple criteria - Replace copy-paste with a Power Query โ€œGet & Transformโ€ refresh - Use TEXTSPLIT/TOCOL/TAKE to tidy messy exports - Add a Pivot + Slicer for a one-page KPI view Engage: - Drop your win below. - Comment on someone elseโ€™s post with one improvement tip.
0 likes โ€ข Oct '25
Thought would drop this little explainer video on how to use XLOOKUP for multiple criteria. Hope it helps https://www.loom.com/share/9440aa445413436fb084e07711ffcca3?sid=051152df-001c-4d91-91f3-48a33c8da08f
Formula Focus Week
This week weโ€™re diving into the world of Excel formulas.Formulas are the backbone of everything in Excel โ€” from simple calculations to powerful automations. Throughout the week, weโ€™ll cover things like: - Writing your first formulas - Understanding relative vs. absolute references - Using common functions like SUM, AVERAGE, MIN/MAX, and more ๐Ÿ‘‰ To kick things off:Whatโ€™s the one formula you find yourself using the most (or the one that always confuses you)? Drop your answer below ๐Ÿ‘‡ and letโ€™s see which formulas are community favorites!
0 likes โ€ข Oct '25
@Janice Yarbrough HI Janice if you look in the classroom section up at the top you should see some excel lessons and in there I have previously made some average and min and max lessons too which I hope will help. If you have any other questions though do let me know
1-8 of 8
Mark Andrews
1
3points to level up
@mark-andrews-7974
Learn to master Excel with simple, practical lessons that save time, boost confidence, and unlock the full power of spreadsheets.

Active 10d ago
Joined Aug 29, 2025
East Riding of Yorkshire