top of page
Search


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...
Kyle Pew
Feb 262 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...
Kyle Pew
Feb 202 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...
Kyle Pew
Feb 134 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—...
Kyle Pew
Feb 62 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...
Kyle Pew
Jan 301 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...
Kyle Pew
Jan 232 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...
Kyle Pew
Jan 92 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...
Kyle Pew
Jan 32 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...
Kyle Pew
Sep 17, 20241 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...
Kyle Pew
Sep 6, 20242 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...
Kyle Pew
Aug 10, 20241 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...
Kyle Pew
Jul 3, 20242 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...
Kyle Pew
Dec 7, 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...
Kyle Pew
Nov 2, 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...
Kyle Pew
Oct 24, 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...
Kyle Pew
Oct 17, 20231 min read


Microsoft Excel's IF function lookup!
Microsoft Excel's IF function to lookup values with multiple criteria. DOWNLOADABLE RESOURCES
Kyle Pew
Oct 5, 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...
Kyle Pew
Sep 28, 20231 min read


New "FEATURE" Coming SOON to Excel!
CLICK FOR MICROSOFT LINK DOWNLOADABLE RESOURCES
Kyle Pew
Sep 7, 20231 min read


Microsoft Excel's Pretty New "TOCOL" Function
The TOCOL Function takes an array of data and turns it into a Column of data. You can also nest the TOCOL function with other functions...
Kyle Pew
Aug 25, 20231 min read
bottom of page





