#PivotTables
LightNews LightNews
excelguru.ca
Check out what's new this month in #Excel, including these 2 features in the Windows version:
🟢 #PivotTables #SPILL! (similar to the experience in Dynamic Arrays)
🟢 Formula by Example (previously only in the Web version)
What's New in Excel (October 2025) | Microsoft Community Hub
This month, look for Agent Mode in Excel (Frontier) in the Tools menu of Copilot for Excel. Additionally, PivotTable #SPILL and accessibility assistant...
techcommunity.microsoft.com
October 30, 2025 at 6:46 PM
excelguru.ca
Today was the Day 1 of my in-person #SelfServiceBI Boot Camp in Munich. 👨‍🏫 We began with an overview of the #BusinessIntelligence ecosystem, then reviewed #Excel #PivotTables, and wrapped up the day by beginning the dive into #PowerQuery.
Photo of a meeting room set up awaiting the attendees for Day 1 of Ken Puls' Self Service BI Boot Camp in Munich, Germany. There is a long table with chairs around, and a flip chart and screen at the far end of the room. Which Technology Gets Used Where? Image of 5 bubbles indicating the various stages of the business intelligence ecosystem. The bubbles arranged in a circle with arrows pointing from one bubble to the next and labels of which technology is used at each stage: - Get & Transform Data (Power Query) - Relate Tables into a “Model” (Power Pivot Data Model) - Generate Measures & Analytics (PivotTables and Formulas) - Create Visuals (Tables, Pivots, Charts & More...) - Share & Explore (Email, SharePoint & Power BI)
October 27, 2025 at 7:54 PM
excelguru.ca
I love hearing from happy students! 😁
In my #Excel Fundamentals Academy at @skillwave.training, you’ll learn all the core skills needed by a #DataAnalyst, including #ExcelFormulasAndFunctions, #PivotTables, #DataVisualization, and #PowerQuery. Level up your Excel skills, go to skw-t.com/excelfun
Testimonial "Great content overall, topped with some solid gold nuggets! I also love Ken's teaching style and rather dry sense of humour. Last but not least, I posted a question which was responded to in no time. Not only that, Ken went above and beyond to have it resolved. I was absolutely blown away by the level of service!" Mark S. (5 stars) Excel Fundamentals Academy (Caricature of Ken Puls) Developed and delivered by Microsoft MVP and Chartered Professional Accountant, Ken Puls (Skillwave Training logo)
October 16, 2025 at 7:27 PM
mtholfsen.bsky.social
A tutorial video showing 8 new features in Excel for Fall 2025 📊 Updates include:

💬 Copilot Chat for all M365 users
🔄️ Auto Refresh for PivotTables
✍️ Drawing Tools updates
🧠 REGEX functions
➕ Lots more

YouTube 📺 youtu.be/N4gOi_ijVks?... #Excel
8 new features in Microsoft Excel for Fall 2025
YouTube video by Mike Tholfsen
youtu.be
October 13, 2025 at 12:47 PM
artfulscientist.bsky.social
fuck sliced bread, PivotTables are the greatest invention known to mankind.
March 28, 2024 at 9:49 PM
excelguru.ca
In this Monkey Shorts, I show how you can get your #PivotTable to show dates, even if there are no values present for the chosen Fact/Measure column. It's easy with #PowerPivot backed PivotTables, but regular pivot tables involve a little magic. ✨ https://buff.ly/42xaJsE

#ExcelTricks #ExcelTips
Show Missing Dates in PivotTables - Monkey Shorts Episode 009
In this episode, Ken shows how you can get your PivotTables to show dates, even if there are no values present for the chosen Fact/Measure column. It's easy...
buff.ly
January 31, 2025 at 6:01 PM
playleft.bsky.social
COWARDS.
Excel pop up window: "A new PivotTable cannot be generated using another PivotTable as a source or a source range that contains one of more PivotTables or parts of them."
October 13, 2023 at 9:01 PM
daveondata.bsky.social
1) Don't make PivotTables your hammer and every problem a nail.

PivotTables are like any other data analysis technique.

They have pros and cons.

Tables are good primarily at two things:

Looking up exact values
Comparing exact values

This alone is not enough for most analyses.
January 29, 2025 at 3:28 PM
softwaretrainer.bsky.social
💰 Want to take control of your expenses? Check out my latest video on how to use Pivot Tables in Excel to consolidate your expense list easily! Learn how to categorize and analyse your spending like a pro. Don't miss it! https://www.rfr.bz/b48dff1
#Excel #Finance #PivotTables #ExpenseTracking
- YouTube
Enjoy the videos and music you love, upload original content, and share it all with friends, family, and the world on YouTube.
www.rfr.bz
June 23, 2025 at 9:10 AM
softwaretrainer.bsky.social
💰 Want to take control of your expenses? Check out my latest video on how to use Pivot Tables in Excel to consolidate your expense list easily! Learn how to categorize and analyse your spending like a pro. Don't miss it! https://www.rfr.bz/bccdb5c
#Excel #Finance #PivotTables #ExpenseTracking
- YouTube
Enjoy the videos and music you love, upload original content, and share it all with friends, family, and the world on YouTube.
www.rfr.bz
May 26, 2025 at 9:06 AM
owenboswarva.bsky.social
Police Service of Northern Ireland (PSNI) 'cannot afford' to pay staff compensation over major data breach www.bbc.co.uk/news/article...

Edwards Solicitors update edwardssolicitors.com/blog/psni-da...

#dataprotection #databreaches #pivottables
The High Court has been told there is currently no money to pay Police Service of Northern Ireland (PSNI) staff any compensation over the major data breach two years ago. The PSNI has already accepted liability for the incident and talks to settle claims have been taking place for a year. The incident involved the accidental release of some personal details of all 9,400 officers and staff. Edwards Solicitors, a law firm representing many of those involved, said it is "extremely disappointed and frustrated" by developments.
September 11, 2025 at 6:49 AM
blackcheeseburger.bsky.social
Now taking applications for an intern.

Must be very organized and an expert on Excel PivotTables and Microsoft Paint.
October 31, 2024 at 3:44 AM
jmgeduld.bsky.social
My parents got to go on a surprise hot air balloon ride this morning. (Unexpected invitation.) I am learning about PivotTables via recorded video at work. One of those things sounds like *way* more fun...
November 3, 2023 at 10:11 PM
theexcelcookbook.bsky.social
Thank you to everyone who participated in yesterday's PivotTable party! I hope you found it helpful and it sparked ideas. For those who missed it, I'm next running my Mastering Excel PivotTables course on October 30.
July 18, 2024 at 8:28 AM
theexcelcookbook.bsky.social
As a reminder, the Excel Cookbook includes chapters on PivotTables and Power Pivot. You can read these on the O'Reilly learning platform if you have a subscription. Alternatively, you can buy the book from Amazon and elsewhere.
July 18, 2024 at 8:28 AM
techkeysx.bsky.social
Slicer in Excel Part 54:
A Slicer in Excel is a visual filter tool that lets you quickly and interactively filter data in PivotTables or Pivot Charts.
#ExcelTips #ExcelSlicer #PivotTable #DataAnalysis #ExcelMadeEasy #LearnExcel #ExcelFilter #ProductivityHacks
September 9, 2025 at 12:48 PM
darealq.bsky.social
Triff mich im Büro, wenn ich mit 103 Jahren Immer noch Pivottables....
April 15, 2024 at 5:47 AM
skillwave.training
Not satisfied with Compact Form for your #Excel #PivotTables? Tired of changing it to your preferred format every time you create one? 😔
There's a better way! In this video, @excelguru.ca shows you how to modify your PivotTable defaults.
Setting PivotTable Defaults - Monkey Shorts Episode 008
Not satisfied with Compact Form for your Excel PivotTables? Tired of changing it to your preferred format every time you create one? There's a better way! I...
buff.ly
January 23, 2025 at 5:02 PM
softwaretrainer.bsky.social
💰 Want to take control of your expenses? Check out my latest video on how to use Pivot Tables in Excel to consolidate your expense list easily! Learn how to categorize and analyse your spending like a pro. Don't miss it! https://www.rfr.bz/b1799e2
#Excel #Finance #PivotTables #ExpenseTracking
- YouTube
Enjoy the videos and music you love, upload original content, and share it all with friends, family, and the world on YouTube.
www.rfr.bz
October 10, 2025 at 9:28 AM
ur-is.bsky.social
LinkedIn Learning: Excel PivotTables for Beginners

This powerful Excel feature cuts the time you spend on formulas in half.

Course Duration: 26 minutes
Course Link: sl.richmond.edu/z4
April 1, 2025 at 4:28 PM
excelguru.ca
⁉️If you need help with #Excel, #PowerQuery, M Code, #DAX, #PowerBI, and more, our Help Forums have you covered! Sign up for FREE and post your question at xlguru.ca/forums
Stuck on a spreadsheet issue? Can’t get a formula to work? At the FREE Excelguru Help Forums, our supportive community of users answer each other’s questions related to: - Excel - Formulas - Power Query - Power BI - PivotTables - Power Pivot - DAX - VBA - and more! (Image of a man in a suit in front of a laptop holding his head in frustration) Excelguru forums.excelguru.ca
May 8, 2025 at 8:29 PM
latimer.dog
Now you can stare at PivotTables with more detail than ever before!!
March 3, 2025 at 7:08 PM
daveondata.bsky.social
My experience is that overestimating data skills is far too common:

"I know how to analyze data."

"What techniques do you use?"

"Excel PivotTables."

"Anything else?"

"No."

Want to build serious data skills?
👇
January 16, 2025 at 7:22 PM
excelguru.ca
I love hearing from happy students! 💚
And I'm excited to be welcoming a new batch of students today - next kick-off date is July 9. If you want to brush up on formulas and functions, and learn about #PivotTables, #PowerQuery, and more, why don't you join me? skw-t.com/excelfun
skillwave.training Skillwave Training @skillwave.training · Jun 11
Woo hoo - another 5⭐️ of @excelguru.ca's #Excel Fundamentals Academy! Learn all the essential #DataAnalytics skills through on-demand videos and downloadable examples. Plus, get direct coaching and support from Ken himself.

Ready to take your Excel skills to the next level? Go to skw-t.com/excelfun
Testimonial "I loved that each lesson had the option to open the Excel file you were working on and follow along while implementing everything you were talking about. Based on the information provided and the price of the course I felt that I received what I paid for." J.K. (5 stars) Excel Fundamentals Academy (Caricature image of Ken Puls, standing with arms crossed) Developed and delivered by Microsoft MVP and Chartered Professional Accountant, Ken Puls (Skillwave logo)
June 11, 2025 at 9:36 PM
pax.dog
my god

if you show me your PivotTables i will absolutley lose it

god, what has working helpdesk done to me I swear
April 25, 2024 at 4:54 PM