LightNews — News, ranked by scholars

TechKeysX

@techkeysx.bsky.social

Merge Tables Without VLOOKUP Part 80:
"Merge Queries in Power Query combines data from two or more tables into one based on a matching column."
#powerqueryeditor #exceltipsandtricks #DataMerge #exceltutorial #dataanalysis #MergeQueries #excelpowerquery

October 8, 2025 at 9:24 AM

Ken Puls, FCPA, MS MVP

@excelguru.ca

There's still time to RSVP for today's Vancouver #PowerBI and Modern #Excel meet-up! Join us starting at 1pm PDT to grow your essential Excel skills with Lee Becker. She'll be sharing practical #ExcelTipsAndTricks (no formulas!) to increase your productivity. Sign up here:

Excel Quick Tips - Not a Formula in Sight! | Lee Becker, Thu, Jul 10, 2025, 1:00 PM | Meetup

**SESSION TRACK:** Excel **SESSION OUTLINE:** Grow you essential Excel skills with Lee Becker! This session is intended to help the average Excel business user by focusing

www.meetup.com

July 10, 2025 at 5:11 PM

Ken Puls, FCPA, MS MVP

@excelguru.ca

Here's a quick reporting trick I like to use in complex #Excel workbooks. It allows you to collapse a range, but provide a message which only shows up while the range is collapsed, inviting the reader to open it and see the data. 🤓https://www.youtube.com/watch?v=m413vFZ2pEg

#ExcelTipsAndTricks

Dynamic Expand Collapse Messages in Excel - Monkey Shorts Episode 020

In this episode of Monkey Shorts, Ken shows a quick reporting trick he likes to use in complex workbooks. It allows you to collapse a range, but provide a message which only shows up while the range…

www.youtube.com

April 3, 2026 at 4:42 PM

Ken Puls, FCPA, MS MVP

@excelguru.ca

During an AKA session, I walked attendees through the five core rules I use when teaching spreadsheet design to finance professionals - principles I've refined over years of consulting and cleaning up other people's messes. 🧵

#ExcelTipsAndTricks #SpreadsheetSkills #SpreadsheetTips #ExcelForFinance