Professor Excel

Tired of updating multiple reports one by one?
Let Power Query do the heavy lifting for you!

In this tutorial, we’ll show you how to combine multiple Excel files in one folder — automatically!

Perfect for Virtual Assistants, analysts, and freelancers who want to save time and impress clients with smarter reporting.

🎥 Watch the full tutorial here

https://youtu.be/L5dCzwbS07Y

Lesson No 50: Automate Your Monthly Reports with Power Query – No More Manual Work! Tired of manually updating your Excel reports every month? In this tutorial, we’ll show you how to use Power Query to automate your monthly reporting process...

Virtual Assistants ka ba and lagi kang nauubusan ng oras kaka-linis ng spreadsheet?

Time to meet your new bestie — Power Query!

Ito ang secret tool sa Excel na mag-a-automate ng data cleaning, merging, at organizing mo — in just a few clicks!

Work smarter, not harder!

Watch my tutorial and see how Power Query can make your tasks 10x easier!

Lesson No. 49 INTRODUCTION TO POWER QUERY Welcome to this beginner-friendly tutorial on Power Query in Excel!If you're tired of manually cleaning and organizing your data in Excel, this video is for ...

See you this Saturday, Participants!

Day 2 of our Advanced Excel journey!

Who knew data cleaning could actually be fun?

Power Query = less manual work, more coffee time ☕💻

Our latest project para sa mga small offices... Budget tracker...

www.youtube.com

Madalas ay nakakasira ng result ng ating report ang mga duplicate data na hindi natin namamalayan... Kaya kailangan talaga ay tanggalin natin ito...

Lesson No 47 Handling Duplicates Learn How to Handle Duplicates in Excel | Step-by-Step TutorialDo you have duplicate data messing up your Excel sheet? In this tutorial, I’ll show you simple...

The Three Pillars of Excel Reporting

In today's fast-paced business environment, a report is only valuable if it's both timely and insightful. This seminar will teach you how to go beyond just crunching numbers to create reports that are truly on point.

We'll focus on the three pillars of effective reporting using Microsoft Excel:

- Data Integrity:
- Visual Clarity:
- Actionable Insights:

Equip your team with the essential tools to create reports that are not just on time, but impactful.

Message now for booking details.

I’m truly grateful for the opportunity to conduct my very first seminar on the Basics of Microsoft Excel. It was an incredible experience sharing knowledge and seeing participants gain confidence in using Excel for their daily tasks.

A big thank you to everyone who joined and made the session engaging and productive!

If your company, organization, or team wants to level up their Excel skills—from basic functions to advanced tools—I’d be glad to bring this seminar to you.

Message us today to book a session for your group. Let’s make Excel less intimidating and more empowering!

— Professor Excel

Need to convert any amount into words (Philippine Peso)? I'm giving away a FREE and super useful template just for you!

✅ Perfect for receipts, invoices, accounting, and official documents
✅ Automatically converts any number into words (₱)

How to get it:
1️⃣ Subscribe to our YouTube channel
2️⃣ Send me a message here on our page with a screenshot of your subscription

That's it! Get your free template in minutes. 💻📩
Don't miss out – it's completely FREE!

Mini Project No 6: "Amount in words" I'm giving away this template for FREE Hey everyone!I’ve created a simple yet powerful template that lets you automatically convert any numeric amount into words — perfect for invoices, receipts, ...

Struggling with Excel printouts that don’t show your headers on every page?
We’ve got you covered!

Check out our latest YouTube tutorial on how to use “Print Titles” in Excel — a simple trick to repeat your headers across all printed pages!

Perfect for reports, long tables, and clean data presentation.

📺 Watch it here:
https://youtu.be/ehJpZCSH5HI?si=_rOQhXB5GOcmovUK

Lesson No 36 Print Title - Repeat Headers on every page In this tutorial, you’ll learn how to set Print Titles in Excel so your column or row headers automatically repeat on every printed page. This is especially ...

Tired of complex formulas? Let ChatGPT inside Excel do the thinking for you!
✅ Generate formulas with plain English
✅ Explain functions like XLOOKUP & INDEX-MATCH
✅ Summarize data, auto-create tables & charts
✅ Build smart templates in minutes!

Follow us for more tutorials about AI inside Excel.