Excel website & blog by Debra Dalgleish @ddalgleish Excel MVP
Canada
Joined November 2008
- Tweets3.8K
- Following104
- Followers4.6K
- Likes204
Contextures retweeted
I have pleasure to share with you the interview we made with Mike Koss - one of the Original Minds behind #Microsoft #Excel creation, part of the first team of programmers developed Excel 1.0 in 1985
He was the Honorary Guest of Bulgaria Excel Days 2025.
youtu.be/nWy5RMVoAwo?si=bhlm…
Contextures retweeted
An hour to go until today's Vancouver #PowerBI and Modern #Excel meet-up gets underway! Spreadsheet enthusiast Alison Pollecutt is willing to bet that there are things you're doing manually that "Go To Special" could help you do a lot quicker. 😲
RSVP at meetup.com/vancouver-power-b…
Contextures retweeted
A new student joined my last AKA session with a familiar #Excel headache: “Every month I download new CSVs from our billing system – and every month I spend hours cleaning them up.” 😭 I walked her through how #PowerQuery can automate every step in a single refreshable query.
ALT Goodbye Manual Cleanup, Hello Power Query! (Image of a woman sitting at a desk in front of a laptop with a big grin on her face) (Skillwave Training logo)
Contextures retweeted
I had a great time today leading a masterclass as part of #BulgariaExcelDays on the awesomeness of #PowerQuery! If you spend time manually gathering, cleaning and transforming data, you know how tedious it can be. PQ will change your work forever, saving hours of time & effort.😎
ALT Photo taken from the back of the classroom for Ken's Power Query Masterclass for Bulgaria Excel Days 2025. Students are setting up their laptops on the tables and getting water bottles up front, where there is a screen with a slide saying "Master Your Data: Live Edition. A Skillwave Product with content from Excelguru". There is a man peaking into the photo frame in the lower left corner with fist pumping in the air and he's cheering.
ALT The Classic Excel Answer 5 Step Process: Import data > Make contiguous range > Sort > Filter and cull > Cleanup Drawbacks: - Tedious - Complicated - Have to re-live it every time
ALT Dealing with Data in Modern Excel (Icons grouped on the left representing various data types, including databases, websites, documents, file folders, and emails) --> Rich array of transformation tools in one place (Icons of various tools) Worksheet + One-click Refresh = Smiley Face
Contextures retweeted
📣We've just launched a new product to our @skillwave_ catalog: the "Ask Ken Anything" subscription!
Join my interactive coaching calls held 2x each month for help with your questions on #Excel, #PowerQuery, #PowerBI, #DAX, #DataModelling, and more. Go to skw-t.com/aka
Contextures retweeted
In this episode we learn about @AndrewDGordon's work including the origins of (>>=), introducing lambdas in Excel, and delve into his current work at Cogna using AI to allow non-programmers to write apps using natural language.
haskell.foundation/podcast/6…
Contextures retweeted
Check out some of the updates to #Excel this month, including:
➡ Chart data task pane in Excel for Web
➡ Images and data types in PivotTables in Excel for Web
➡ New default theme for Office in Excel for Windows and Mac
techcommunity.microsoft.com/…
Contextures retweeted
#ExcelTips 📹 | These tiny charts can make a big difference in your reports! 📊
📌Want to dive deeper into sparklines? Or learn more about #Excel charts and dashboards? Boost your data visualization skills with our Microsoft Excel Dashboards course: goskills.com/Course/Excel-Da…
Contextures retweeted
There's still time to RSVP for tonight's Vancouver #PowerBI and Modern #Excel meet-up! @notaboutthecell will be presenting on how to get started with #MicrosoftFabric as a Power BI user. Sign up here to join us at 5pm Pacific Time: meetup.com/vancouver-power-b…
Contextures retweeted
Happy #SpreadsheetDay! For a bit of creative inspiration, check out the work of Tatsuo Horiuchi, a 77-Year-Old Artist Who ‘Paints’ Japanese Landscapes With Excel thisiscolossal.com/2017/12/t… via @colossal
Contextures retweeted
🌏I'm excited to be a part of the #Excel Virtually Global Summit next week. Experts from around the world will be sharing their knowledge! My session on Oct 11 will introduce you to Monkey Tools and and show you how it can help boost your Excel efficiency. excelvirtuallyglobal.com/
Contextures retweeted
With Copilot in Excel, you can create advanced visualizations, generate forecasts, and save time sorting through data with Python.
Take a look: msft.it/60139iZiv #AI #Microsoft365
Contextures retweeted
For our Vancouver #PowerBI and Modern #Excel meet-up on Thus, Oct 5, Excel super-nerd 🤓 @ExcelRobot is discussing his favorite subject: Microautomations! Sign up here to join us starting at 5pm PDT: meetup.com/vancouver-power-b…
Contextures retweeted
On Sept 21, @KolokolovAlex will be sharing some best practices for KPI cards in your #PowerBI reports - how to carefully design them, how to group them into meaningful blocks of cards, and how to add additional indicators. We start at 10am PDT, RSVP here: meetup.com/vancouver-power-b…
Contextures retweeted
After last week's video, let's look at one potential "gotcha" that can happen when converting a #PivotTable into CUBE functions, the array formula. Learn how you can identify an array, and how to break it so that you can make your formulas dynamic again: youtube.com/watch?v=XU5uKZ9G…
Contextures retweeted
Join us on Thus, Sept 7 to learn some nifty tips and tricks for creating interactive #Excel charts using Dynamic Arrays from Microsoft MPV Carlos Barboza. Things get started at 5pm Pacific Time - sign up here: meetup.com/vancouver-power-b…
Contextures retweeted
If you are working in #Excel at a beginner or intermediate level, this course will help you become a better #DataAnalyst! The next kick-off is Aug 9, but if you register before Aug 8 you can save 15% with this coupon code: DATAPRO15
👉 Details and reg at skw-t.com/excelfun-15
📈 So, you want to become a #DataAnalyst? In this #Excel Fundamentals Boot Camp, @kpuls will teach you the core #DataAnalytics skills needed in today's world.
🚀Save 15% with this code: DATAPRO15
Register today at skw-t.com/excelfun-15
Contextures retweeted
While #PowerQuery can't read a filter from an #Excel table natively, I have a cool little trick that you can do to flow that information through. Read how to do it here: excelguru.ca/use-excel-table…
Contextures retweeted
I LOVE teaching in person, and I'm really excited to be teaming up with @Jon_Peltier for these live #DataVisualization and #BusinessInteligence boot camps in Portland and Boston in Sept.
Save 15% if you register by Aug 8 with code DATAPRO15
👉 Details at skw-t.com/livebootcamps-15
🥵 Do you spend hours every week preparing reports for your boss?
🤩 Over 4 days of LIVE training, @kpuls and @Jon_Peltier will show you how to change your company’s reporting game forever in #Excel and #PowerBI!
Save 15% with code DATAPRO15
See options at skw-t.com/livebootcamps-15
Contextures retweeted
There's some cool new things that have come to #Excel this month:
✅ Sharing just a section of a workbook (available to all users in the current channel)
✅ Inserting images into cells (currently available to Insiders only)
Learn about all the updates: techcommunity.microsoft.com/…