top of page
Search


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,847 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,538 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


Kyle Pew
Mar 9, 20231 min read
Google Sheets for Excel Users!
Learn How to use Excel Functions in Google Sheets! We understand that Excel and Google Sheets are very similar, and Google Sheets has a...
645 views0 comments


Kyle Pew
Feb 23, 20231 min read
Learn to use an AMAZING feature in Excel! FLASH FILL
Flash Fill automatically fills your data when it senses a pattern. For example, you can use Flash Fill to Combine first and last names...
436 views0 comments

Kyle Pew
Dec 16, 20221 min read
Introducing a NEW Course - Microsoft Excel Pivot Tables
Grouping data in a PivotTable can help you show a subset of data to analyze. For example, you may want to group an unwieldy list of...
993 views0 comments


Kyle Pew
Dec 1, 20221 min read
Learn how to use the REPT(repeat) Function in Excel
Use the REPT function to show any type of Rating based on a percentage The REPT function in Excel helps users repeat a text string,...
610 views0 comments


Kyle Pew
Nov 17, 20221 min read
Top 5 YouTube Video's Created by Kyle Pew
Check out the Top 5 most watched YouTube Video's Created by Kyle Pew (OfficeNewB) Click on each link below to watch the Video! #1 Create...
283 views0 comments

Kyle Pew
Oct 27, 20221 min read
Using Page Breaks and Section Breaks in Word
Using Page Breaks and Section Breaks to manage and maintain large documents Use page breaks to control where a page ends and where a new...
615 views0 comments

Kyle Pew
Sep 14, 20221 min read
Using Excel Functions to return Multiple Values
Nesting Functions like Index, Small, IF, Row & Column when using Excel 2016 and Older. Also Nesting Functions like Textjoin & IF when...
1,537 views0 comments

Kyle Pew
Aug 19, 20221 min read
Working with Macros inside of Microsoft Word
In Word, you can automate frequently used tasks by creating and running macros. A macro is a series of commands and instructions that you...
531 views0 comments

Kyle Pew
Jul 29, 20221 min read
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...
402 views0 comments

Kyle Pew
Jul 21, 20221 min read
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...
897 views0 comments

Kyle Pew
Jul 14, 20221 min read
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...
1,841 views0 comments

Kyle Pew
Jul 6, 20221 min read
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...
897 views0 comments

Kyle Pew
May 13, 20221 min read
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...
1,412 views0 comments

Kyle Pew
May 6, 20221 min read
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...
3,477 views0 comments

Kyle Pew
Apr 14, 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...
1,983 views0 comments

Kyle Pew
Apr 7, 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...
1,270 views0 comments
bottom of page