top of page
Search
Kyle Pew
Jan 26, 20221 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...
81 views0 comments
Kyle Pew
Jan 26, 20221 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:...
64 views0 comments
Kyle Pew
Jan 26, 20221 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...
48 views0 comments
Kyle Pew
Jan 26, 20221 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...
34 views0 comments
Kyle Pew
Jan 23, 20221 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...
66 views0 comments
Kyle Pew
Jan 23, 20221 min
Microsoft Excel TEXTJOIN() Function
TEXTJOIN() FUNCTION DEFINITION =TEXTJOIN(delimiter, ignore_empty, text_1, [text_2], [text_3], …) BENEFITS The TEXTJOIN function combines...
28 views0 comments
Kyle Pew
Jan 23, 20221 min
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...
209 views0 comments
Kyle Pew
Jan 23, 20221 min
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...
38 views0 comments
Kyle Pew
Jan 18, 20221 min
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...
14,545 views0 comments
Kyle Pew
Jan 18, 20221 min
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...
37,511 views0 comments
Kyle Pew
Oct 29, 20191 min
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...
399 views0 comments
Kyle Pew
Oct 29, 20191 min
Microsoft Excel Running Total with SUM and SUMIF Functions
(Watch the video for a demonstration) The Microsoft Excel function, SUM, is the most used function in all of Excel. We typically use the...
176 views0 comments
Kyle Pew
Oct 29, 20191 min
Top Time Saving Excel Techniques in Microsoft Excels Power Query
Experience true Excel power by using Microsoft Excels Power Query (GET AND TRANSFORM - Excel 2016+) feature. In this video I will...
314 views0 comments
bottom of page