top of page
Search


Break the Language Barrier in Excel: Translate Any Text Instantly!
If you’ve ever worked with international teams or global datasets in Excel, you’ve probably come across reviews, comments, or content...
Kyle Pew
May 212 min read
155 views
0 comments


Reshape Your Data Instantly in Excel with CHOOSECOLS & CHOOSEROWS
If you’ve ever found yourself spending way too much time manually moving columns around or using complex formulas to extract specific...
Kyle Pew
May 161 min read
235 views
0 comments


Mastering Excel's PIVOTBY Function – 3 Real-World Examples You Need to See
Are you looking to level up your data summarization game in Excel? Microsoft has rolled out a new dynamic function that’s turning heads:...
Kyle Pew
Apr 161 min read
596 views
0 comments


Stop Doing It Manually! How to Calculate Comma-Delimited Numbers in Excel
Ever received data imported from an external system, only to find multiple numeric values crammed into a single Excel cell? For example,...
Kyle Pew
Mar 241 min read
249 views
0 comments


Excel Charts Made Easy: Data to Stunning Visuals
Creating impactful charts in Microsoft Excel doesn't have to be complicated! In my latest YouTube tutorial, you'll learn step-by-step how...
Kyle Pew
Mar 191 min read
393 views
0 comments


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...
Kyle Pew
Mar 132 min read
399 views
0 comments


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...
Kyle Pew
Mar 51 min read
438 views
0 comments


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
890 views
0 comments


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
734 views
0 comments


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
304 views
0 comments


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
446 views
0 comments


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
388 views
0 comments


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
225 views
0 comments


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
231 views
0 comments


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
1,113 views
0 comments


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
947 views
0 comments


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
662 views
0 comments


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
1,062 views
0 comments


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
1,221 views
0 comments


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
3,680 views
0 comments
bottom of page