Excel Champs

A Full Course on Using ChatGPT with Excel

2 days ago | [YT] | 6

Excel Champs

Power Query can save you 20 hours every single week and completely change the way you work in Excel.

Most Excel users spend 80% of their time just cleaning and managing data instead of actually analyzing it.

In this masterclass, I'll help you flip that ratio so you can spend your time on analysis, not on wrestling with messy data.

1 week ago | [YT] | 1

Excel Champs

Full Course on 10X Your Excel Skills

4 months ago | [YT] | 1

Excel Champs

Still Not using New Checkboxes?

Well, they are not new now but, recent than the old one and far better, I’d say.

With these checkboxes, you can make dynamic reports really easily.

If you look at the report I have here, I can easily filter inventory data using he checkboxes.

Even though I have used FILTER function to get the mechanism that filter this data, but, checkboxes give a smooth filtration to data.

Let me know, if you need this file.

And do share with me if you using checkboxes already and how creatively you are using it.



- Puneet Gogia

4 months ago | [YT] | 4

Excel Champs

Which Keyboard Shortcut Opens the Search Bar in Excel?

5 months ago | [YT] | 1

Excel Champs

🎯 Excel Formula Challenge 🎯

Who made the highest total sale for the product "Laptop"?

If you look at the data in the image below, we have sales with the salesperson’s name, and now here the idea is to find the name (ONLY NAME) of the salesperson who did the highest sales (TOTAL SALES) for the LAPTOP.

Like everything in Excel, we have multiple solutions; we can use multiple ways to write a formula to get the name of that salesperson, which is what we need to find.

You can drop your answer or your formula in the comments. 😊

11 months ago (edited) | [YT] | 6

Excel Champs

🧠 QUIZ TIME!


OK, Excel Heros. Tell Me. If you had to pull out data from the last N days.

Which method would be your best choice?

1 year ago | [YT] | 2

Excel Champs

🚨 (New Video)

In the last few years, Microsoft has introduced some of the most amazing functions in Excel. With these functions, the dependence on complex formulas has decreased.



Now, you have a single function that can restructure your data, extract data based on conditions, or allow you to summarize your data quickly.



In this video, I have shared seven new-age functions that can help you in a big way.



As I said, you might be using some complex formula, and these functions can do that super-easily, so make sure to check out all of these functions.

1 year ago | [YT] | 0

Excel Champs

🚨 NEW VIDEO ALERT

Whether you're presenting data to your boss, trying to speed up your workflow, or just want to impress your team, this one's for you.

1 year ago | [YT] | 0

Excel Champs

What you want to learn the most in Excel

1 year ago | [YT] | 3