top of page
Search

Kyle Pew
11 minutes ago2 min read
Master Excel Automation: Dynamically Update Titles & Filter Data Like a Pro!
Are you tired of manually updating report titles or filtering data every time you create a new worksheet? Microsoft Excel’s CELL function...
0 views
0 comments

Kyle Pew
Mar 51 min read
4 Essential Excel Tricks You’ll Wish You Knew Earlier
Are you ready to supercharge your productivity in Microsoft Excel (and beyond)? In my latest YouTube video, I share 4 game-changing tips...
242 views
0 comments

Kyle Pew
Feb 262 min read
Create a Dynamic Gantt Chart in Excel Using Conditional Formatting
Gantt charts are a fantastic way to visualize project timelines. Did you know you can create a dynamic Gantt chart in Microsoft Excel...
331 views
0 comments


Kyle Pew
Feb 202 min read
Mastering the DGET Function in Microsoft Excel: A Hidden Gem for Database Lookups
Are you tired of using complex formulas like XLOOKUP or VLOOKUP to find specific records in a dataset? If so, it’s time to introduce you...
355 views
0 comments

Kyle Pew
Feb 134 min read
5 Quick Excel VBA Tricks to Boost Your Productivity
If you work with Excel regularly, you know how time-consuming repetitive tasks can be. But with VBA (Visual Basic for Applications), you...
234 views
0 comments

Kyle Pew
Feb 62 min read
Master Excel with VLOOKUP and IF: A Must-Know Technique for Professionals
Are you ready to take your Excel skills to the next level? In our latest YouTube video, we dive deep into two essential functions—...
339 views
0 comments

Kyle Pew
Jan 301 min read
Create Dynamic Excel Reports Using Shapes
Do you want to take your Microsoft Excel reports to the next level? In my latest YouTube video , I show you a powerful but often...
235 views
0 comments

Kyle Pew
Jan 232 min read
Harnessing Microsoft Excel’s Paste Special - Multiply Feature: Practical Use Cases
Microsoft Excel’s Paste Special tool is a powerful feature that can save you time and effort when manipulating data. One lesser-known...
204 views
0 comments

Kyle Pew
Jan 92 min read
Unlocking the Power of PowerPoint Designer and CoPilot: Create Stunning Presentations with Ease
Creating a visually appealing and impactful presentation can be challenging, especially when time is limited. Fortunately, Microsoft...
136 views
0 comments

Kyle Pew
Jan 32 min read
5 Lesser-Known Microsoft Excel Shortcut Keys to Boost Your Productivity
If you're looking to work smarter in Microsoft Excel, shortcut keys are your best friend. They save time, reduce mouse clicks, and make...
739 views
0 comments


Kyle Pew
Sep 17, 20241 min read
How to Create Multiple PivotCharts from a Single Excel List
Are you looking to get more insights from your data using PivotCharts in Excel? In this guide, I’ll show you how to create multiple...
888 views
0 comments

Kyle Pew
Sep 6, 20242 min read
Getting Started with Power BI for Excel Users: 4 Essential Steps
If you're an Excel user looking to dive into the world of data visualization and reporting, Microsoft Power BI is an excellent tool to...
577 views
0 comments

Kyle Pew
Aug 10, 20241 min read
Master Excel Like a Pro: Announcing Our New Course!
Are you ready to take your Excel skills to the next level? We’re thrilled to announce the launch of our brand-new course, " Master...
1,017 views
0 comments

Kyle Pew
Jul 3, 20242 min read
REGEXEXTRACT - Microsoft Excels New Regular Expression Function
Microsoft has recently introduced a new function within Microsoft Excel called REGEXEXTRACT() (Regular Expression). Check out the video...
1,177 views
0 comments

Kyle Pew
Dec 7, 20231 min read
Interactive Check Boxes Coming Soon to Excel!
This amazing new feature coming soon to Microsoft Excel! Interactive Check Boxes! Easy to use check list! Can be used with many different...
3,581 views
0 comments

Kyle Pew
Nov 2, 20231 min read
5 Most Common Excel Functions
Microsoft Excel contains 450+ built-in functions. These functions range from simple mathematical functions such as SUM() to more complex...
3,014 views
0 comments

Kyle Pew
Oct 24, 20231 min read
Apply Conditional Formatting to Microsoft Excel Charts
By combining an Excel IF() function with the LARGE() function you can quickly apply "Conditional Formatting" to an Excel Chart. EXERCISE...
1,114 views
0 comments
Kyle Pew
Oct 17, 20231 min read
Microsoft Excel - Dynamic Drop-Down Menus (NO VBA)
Check out the video below on how to create Dynamic, Cascading Drop-Down Menus in a Microsoft Excel list. This method of creating Dynamic...
812 views
0 comments

Kyle Pew
Oct 5, 20231 min read
Microsoft Excel's IF function lookup!
Microsoft Excel's IF function to lookup values with multiple criteria. DOWNLOADABLE RESOURCES
614 views
0 comments

Kyle Pew
Sep 28, 20231 min read
Mastering Your Finances: The Snowball Debt Strategy
Take control of your Debt with The Snowball Debt Strategy! The term "snowball debt" typically refers to a debt repayment strategy aimed...
3,118 views
0 comments
bottom of page