Blog | New OfficeNewb

How to Create Multiple PivotCharts from a Single Excel List

Getting Started with Power BI for Excel Users: 4 Essential Steps

Master Excel Like a Pro: Announcing Our New Course!

Kyle Pew

Sep 171 min read

How to Create Multiple PivotCharts from a Single Excel List

Are you looking to get more insights from your data using PivotCharts in Excel? In this guide, I’ll show you how to create multiple...

551 views0 comments

Kyle Pew

Sep 62 min read

Getting Started with Power BI for Excel Users: 4 Essential Steps

If you're an Excel user looking to dive into the world of data visualization and reporting, Microsoft Power BI is an excellent tool to...

374 views0 comments

Kyle Pew

Aug 101 min read

Master Excel Like a Pro: Announcing Our New Course!

Are you ready to take your Excel skills to the next level? We’re thrilled to announce the launch of our brand-new course, " Master...

750 views0 comments

REGEXEXTRACT - Microsoft Excels New Regular Expression Function

Kyle Pew

Jul 32 min read

REGEXEXTRACT - Microsoft Excels New Regular Expression Function

Microsoft has recently introduced a new function within Microsoft Excel called REGEXEXTRACT() (Regular Expression). Check out the video...

1,085 views0 comments

Interactive Check Boxes Coming Soon to Excel!

Kyle Pew

Dec 7, 20231 min read

Interactive Check Boxes Coming Soon to Excel!

This amazing new feature coming soon to Microsoft Excel! Interactive Check Boxes! Easy to use check list! Can be used with many different...

3,437 views0 comments

Kyle Pew

Nov 2, 20231 min read

5 Most Common Excel Functions

Microsoft Excel contains 450+ built-in functions. These functions range from simple mathematical functions such as SUM() to more complex...

2,844 views0 comments

Apply Conditional Formatting to Microsoft Excel Charts

Kyle Pew

Oct 24, 20231 min read

Apply Conditional Formatting to Microsoft Excel Charts

By combining an Excel IF() function with the LARGE() function you can quickly apply "Conditional Formatting" to an Excel Chart. EXERCISE...

1,053 views0 comments

Kyle Pew

Oct 17, 20231 min read

Microsoft Excel - Dynamic Drop-Down Menus (NO VBA)

Check out the video below on how to create Dynamic, Cascading Drop-Down Menus in a Microsoft Excel list. This method of creating Dynamic...

768 views0 comments

Kyle Pew

Oct 5, 20231 min read

Microsoft Excel's IF function lookup!

Microsoft Excel's IF function to lookup values with multiple criteria. DOWNLOADABLE RESOURCES

594 views0 comments

Mastering Your Finances: The Snowball Debt Strategy

Kyle Pew

Sep 28, 20231 min read

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...

2,610 views0 comments

Kyle Pew

Sep 7, 20231 min read

New "FEATURE" Coming SOON to Excel!

CLICK FOR MICROSOFT LINK DOWNLOADABLE RESOURCES

620 views0 comments

Microsoft Excel's Pretty New "TOCOL" Function

Kyle Pew

Aug 25, 20231 min read

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...

720 views0 comments

Microsoft Excel - Double a Penny for 30 Days: How Much Would You Have?

Kyle Pew

Jun 22, 20231 min read

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...

731 views0 comments

Mini Calendar Add-In for Excel and a little VBA code

Kyle Pew

May 18, 20231 min read

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...

6,428 views0 comments

Keyboard Shortcuts that make it easier to work in Excel!

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,038 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.

230 views0 comments

Use ChatGPT to Help Solve Excel Formulas

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,516 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...

639 views0 comments

Learn to use an AMAZING feature in Excel! FLASH FILL

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...

433 views0 comments