top of page
Search
Kyle Pew
- Jan 23, 2022
- 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...
60 views0 comments
Kyle Pew
- Jan 23, 2022
- 1 min
Microsoft Excel TEXTJOIN() Function
TEXTJOIN() FUNCTION DEFINITION =TEXTJOIN(delimiter, ignore_empty, text_1, [text_2], [text_3], …) BENEFITS The TEXTJOIN function combines...
29 views0 comments
Kyle Pew
- Jan 23, 2022
- 1 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...
195 views0 comments
Kyle Pew
- Jan 23, 2022
- 1 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...
30 views0 comments
bottom of page