Search
Kyle Pew
- Jul 29
- 1 min
Part 2 - Create an Interactive Crossword Puzzle with Microsoft Excel
In Part 2 of creating an Excel Crossword Puzzle we use Excel Functions, Conditional Formatting and little bit of VBA In this video I will...
70 views0 comments
Kyle Pew
- Jul 21
- 1 min
SUM Excel Range with Conditions
Use SUMIF, SUMIFS or SUMPRODUCT to SUM a range of cells Conditionally =SUMIF(range, criteria, [sum_range]) The SUMIF function syntax has...
451 views0 comments
Kyle Pew
- Jul 14
- 1 min
Microsoft Excel Filter Function
The FILTER function allows you to filter a range of data based on criteria you define. =FILTER(ARRAY,INCLUDE,[IF_EMPTY]) ARRAY = THE...
178 views0 comments
Kyle Pew
- Jul 6
- 1 min
Create an Interactive Crossword Puzzle with Microsoft Excel
With just a little bit of cell formatting, a pinch of Excel function magic and Excel conditional formatting, you can create an...
174 views0 comments
Kyle Pew
- May 13
- 1 min
Announcing New Microsoft Excel TEXT Functions (TEXTSPLIT, TEXTBEFORE, TEXTAFTER)
Microsoft is releasing a handful of TEXT based functions that make splitting column values into multiple columns, super easy to do. For...
887 views0 comments
Kyle Pew
- May 6
- 1 min
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...
776 views0 comments
Kyle Pew
- Apr 14
- 1 min
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...
1,584 views0 comments
Kyle Pew
- Apr 7
- 1 min
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...
939 views0 comments
Kyle Pew
- Mar 3
- 1 min
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...
3,098 views0 comments
Kyle Pew
- Feb 17
- 1 min
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...
1,665 views0 comments
Kyle Pew
- Feb 10
- 1 min
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...
1,084 views0 comments
Kyle Pew
- Feb 3
- 1 min
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...
697 views0 comments
Kyle Pew
- Jan 26
- 2 min
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;...
173 views0 comments
Kyle Pew
- Jan 26
- 2 min
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...
107 views0 comments
Kyle Pew
- Jan 26
- 1 min
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...
41 views0 comments
Kyle Pew
- Jan 26
- 1 min
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:...
30 views0 comments
Kyle Pew
- Jan 26
- 1 min
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...
18 views0 comments
Kyle Pew
- Jan 26
- 1 min
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...
15 views0 comments
Kyle Pew
- Jan 23
- 1 min
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...
28 views0 comments
Kyle Pew
- Jan 23
- 1 min
Microsoft Excel TEXTJOIN() Function
TEXTJOIN() FUNCTION DEFINITION =TEXTJOIN(delimiter, ignore_empty, text_1, [text_2], [text_3], …) BENEFITS The TEXTJOIN function combines...
13 views0 comments