top of page
Search
Microsoft Excel - Extract a Unique List of Values from a Column
How can you take a column with duplicate values and extract just the unique values? Follow along as I demonstrate four techniques you can...
Kyle Pew
May 6, 20221 min read
Introduction to Working with Microsoft Excel PivotTables
Microsoft Excel PivotTables are one of the most popular features of Excel. Take a look at the videos below to find out why PivotTables...
Kyle Pew
Apr 14, 20221 min read
Microsoft Excels Power Query Append Operation with Multiple Data sets
Excel Power Query Microsoft Excel's Power Query feature allows you to append multiple data lists, creating a master list to user within...
Kyle Pew
Apr 7, 20221 min read
Microsoft Excel 4 Lesser-Known Shortcut Keys
Microsoft Excel contains loads of Shortcut keys to help you become more efficient and save time while working with your Excel data. Below...
Kyle Pew
Mar 3, 20221 min read
Brand New Microsoft Excel Feature - Searchable Drop-Down Lists
***** This feature has been introduced to Microsoft Office Beta users and will be made available to the public soon. Microsoft is...
Kyle Pew
Feb 17, 20221 min read
Microsoft Excel - Custom List for Sorting
Have you ever needed to sort Excel data in a specific order other than alphabetical, Ascending/Descending? For example, if you have a...
Kyle Pew
Feb 10, 20221 min read
Microsoft Excel Relative VS Absolute Cell References (Formulas)
Check out the differences between Microsoft Excel Relative and Absolute Cell references in Excel formulas. DOWNLOAD EXERCISE FILE TO...
Kyle Pew
Feb 3, 20221 min read
Microsoft Excel Dynamic Validation Lists
QUESTION: “Is it possible to make one validation column dependent upon choices from another validation column?” Here’s an example;...
Kyle Pew
Jan 26, 20222 min read
Microsoft Excel - Dynamic VLOOKUP() with MATCH() Function
A student, in my Excel Beginner to Advanced course on Udemy, recently asked an excellent question on Excel's VLOOKUP function. I thought...
Kyle Pew
Jan 26, 20222 min read
Microsoft Excel Array Formulas
Below is a quick video demonstration on Microsoft Excel Array Formulas. Arrays, simply put, are a collection of data. For example you may...
Kyle Pew
Jan 26, 20221 min read
Creating an Excel Balance Sheet Using Format as Table
Another great question from a student in my Complete Excel training course on Udemy. Download the example file to try yourself:...
Kyle Pew
Jan 26, 20221 min read
How to Create a Microsoft Excel Timeline (Gantt Chart)
I got another excellent question from a student in my Complete Microsoft Excel course. Take a look at the video below on how to create a...
Kyle Pew
Jan 26, 20221 min read
WOW!!! New Microsoft Excel Functions Coming Soon
Microsoft recently announced a handful of new Microsoft Excel Functions. And, they are blowing my mind!! "Note: September 24, 2018: The...
Kyle Pew
Jan 26, 20221 min read
Microsoft Excel Power Query Pivot Column
I recently got a question about cleaning up a list of addresses in order to make it useable for a mail merge. The original data looks...
Kyle Pew
Jan 23, 20221 min read
Microsoft Excel TEXTJOIN() Function
TEXTJOIN() FUNCTION DEFINITION =TEXTJOIN(delimiter, ignore_empty, text_1, [text_2], [text_3], …) BENEFITS The TEXTJOIN function combines...
Kyle Pew
Jan 23, 20221 min read
Excel LOOKUP Functions
I recently recorded a handful of videos for my Complete Microsoft Excel course and thought I would share these videos. I've placed them...
Kyle Pew
Jan 23, 20221 min read
Microsoft Excel Power Query Cleaning Nested Data with Conditional Columns and Fill Command
Excel Power Query makes transforming and cleaning up data a breeze. By using Conditional Columns and Excel Power Query Fill Command...
Kyle Pew
Jan 23, 20221 min read
Microsoft Excel Common Shortcuts for MAC users
Microsoft Excel is full of keyboard shortcuts that will speed up your production. Below is a link to the Microsoft site with loads of...
Kyle Pew
Jan 18, 20221 min read
Microsoft Excel Common Shortcuts for Windows users
Microsoft Excel is full of keyboard shortcuts that will speed up your production. Below is a link to the Microsoft site with loads of...
Kyle Pew
Jan 18, 20221 min read
Microsoft Announces a New XLOOKUP Function for Excel
Microsoft announced a brand new function for Microsoft Excel called the XLOOKUP(). This function provides an enhanced method of looking...
Kyle Pew
Oct 29, 20191 min read
bottom of page