top of page
Search

Kyle Pew
- 21 hours ago
- 1 min
Mastering Your Finances: The Snowball Debt Strategy
Take control of your Debt with The Snowball Debt Strategy! The term "snowball debt" typically refers to a debt repayment strategy aimed...
205 views0 comments

Kyle Pew
- Sep 7
- 1 min
New "FEATURE" Coming SOON to Excel!
CLICK FOR MICROSOFT LINK DOWNLOADABLE RESOURCES
395 views0 comments

Kyle Pew
- Aug 25
- 1 min
Microsoft Excel's Pretty New "TOCOL" Function
The TOCOL Function takes an array of data and turns it into a Column of data. You can also nest the TOCOL function with other functions...
355 views0 comments


Kyle Pew
- Jun 22
- 1 min
Microsoft Excel - Double a Penny for 30 Days: How Much Would You Have?
Watch as we attempt to answer the question of "Would you rather have $1,000,000 upfront or would you take a penny that doubled every day...
612 views0 comments

Kyle Pew
- May 18
- 1 min
Mini Calendar Add-In for Excel and a little VBA code
How to Add-In the Mini Calendar option into Excel. Use it to quickly select a date to insert into a cell. Also, a little VBA code to have...
1,189 views0 comments


Kyle Pew
- May 11
- 1 min
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...
2,391 views0 comments
Kyle Pew
- Apr 27
- 1 min
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.
156 views0 comments

Kyle Pew
- Mar 24
- 1 min
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,317 views0 comments

Kyle Pew
- Mar 16
- 1 min
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...
392 views0 comments


Kyle Pew
- Mar 9
- 1 min
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...
564 views0 comments


Kyle Pew
- Feb 23
- 1 min
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...
386 views0 comments

Kyle Pew
- Dec 16, 2022
- 1 min
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...
923 views0 comments


Kyle Pew
- Dec 1, 2022
- 1 min
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,...
540 views0 comments


Kyle Pew
- Nov 17, 2022
- 1 min
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...
245 views0 comments

Kyle Pew
- Oct 27, 2022
- 1 min
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...
566 views0 comments

Kyle Pew
- Sep 14, 2022
- 1 min
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,249 views0 comments

Kyle Pew
- Aug 19, 2022
- 1 min
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...
369 views0 comments

Kyle Pew
- Jul 29, 2022
- 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...
301 views0 comments

Kyle Pew
- Jul 21, 2022
- 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...
857 views0 comments

Kyle Pew
- Jul 14, 2022
- 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...
360 views0 comments
bottom of page