top of page
Search
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...
60 views0 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...
323 views0 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...
774 views0 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...
524 views0 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...
976 views0 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,130 views0 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,523 views0 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...
2,918 views0 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,083 views0 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...
784 views0 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
603 views0 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...
2,882 views0 comments
Kyle Pew
Sep 7, 20231 min read
New "FEATURE" Coming SOON to Excel!
CLICK FOR MICROSOFT LINK DOWNLOADABLE RESOURCES
628 views0 comments
Kyle Pew
Aug 25, 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...
732 views0 comments
Kyle Pew
Jun 22, 20231 min read
Microsoft Excel - Double a Penny for 30 Days: How Much Would You Have?
Watch as we attempt to answer the question of "Would you rather have $1,000,000 upfront or would you take a penny that doubled every day...
742 views0 comments
Kyle Pew
May 18, 20231 min read
Mini Calendar Add-In for Excel and a little VBA code
How to Add-In the Mini Calendar option into Excel. Use it to quickly select a date to insert into a cell. Also, a little VBA code to have...
6,967 views0 comments
Kyle Pew
May 11, 20231 min read
Keyboard Shortcuts that make it easier to work in Excel!
Summing large set of data with the help of just 2 Keys! Creating a Chart with 1 Function key! Making a Table with the help of just 2...
6,538 views0 comments
Kyle Pew
Apr 27, 20231 min read
Microsoft Excel Tip - ALT + =
Check out this super quick Microsoft Excel tip. Use the ALT + = shortcut key to perform an AutoSum for all your data.
234 views0 comments
Kyle Pew
Mar 24, 20231 min read
Use ChatGPT to Help Solve Excel Formulas
Having a hard time finding the correct Formula to use in Excel? Ask ChatGPT ChatGPT is an artificial intelligence chatbot ChatGPT is a...
1,532 views0 comments
Kyle Pew
Mar 16, 20231 min read
How to use Excels New IMAGE Function
The IMAGE function inserts images into cells from a source location along with alternative text. You can then move and resize cells, sort...
426 views0 comments
bottom of page