Hi ,

How are you doing?

There’s a point where a normal Pivot Table stops being helpful.

Not because Pivot Tables are bad, but because the question you’re asking is a little more layered than what drag-and-drop can handle neatly.

That’s what this week’s video is about.

I’ve covered two types of tricks in it - 

• One is around formulas, where I show how Power Pivot and DAX can help solve more layered Pivot Table problems.
  
• The second is around formatting, where I share a few simple ways to make Pivot Tables cleaner, easier to read, and nicer to use.

Watch the Video





Nifty Trick to Calculate Fiscal Quarters in Excel

Don’t settle for calendar quarters.

If your business follows a different financial year, this simple formula helps you calculate fiscal quarters correctly and use them in your reports or pivot tables.

Just adjust the month shift to match your own fiscal year.





Use REGEX to Pull Useful Things from Messy Text

Most people use Excel for simple formulas. But if you’re on Microsoft 365, there’s a much more powerful side to it.

With REGEX, you can pull out things like numbers, dates, phone numbers, and emails from messy text.

AI looks unstoppable…

until it meets that one Excel file carrying a decade of real work, weird exceptions, and “don’t touch this” formulas