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

3 days ago
1 min

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

93 views0 comments

Kyle Pew

Sep 6
2 min

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

120 views0 comments

Kyle Pew

Aug 10
1 min

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

381 views0 comments

REGEXEXTRACT - Microsoft Excels New Regular Expression Function

Kyle Pew

Jul 3
2 min

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

960 views0 comments

Interactive Check Boxes Coming Soon to Excel!

Kyle Pew

Dec 7, 2023
1 min

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,284 views0 comments

Kyle Pew

Nov 2, 2023
1 min

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,696 views0 comments

Apply Conditional Formatting to Microsoft Excel Charts

Kyle Pew

Oct 24, 2023
1 min

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,016 views0 comments

Kyle Pew

Oct 17, 2023
1 min

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

719 views0 comments

Kyle Pew

Oct 5, 2023
1 min

Microsoft Excel's IF function lookup!

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

573 views0 comments

Mastering Your Finances: The Snowball Debt Strategy

Kyle Pew

Sep 28, 2023
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...

2,182 views0 comments

Kyle Pew

Sep 7, 2023
1 min

New "FEATURE" Coming SOON to Excel!

CLICK FOR MICROSOFT LINK DOWNLOADABLE RESOURCES

597 views0 comments

Microsoft Excel's Pretty New "TOCOL" Function

Kyle Pew

Aug 25, 2023
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...

672 views0 comments

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

Kyle Pew

Jun 22, 2023
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...

709 views0 comments

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

Kyle Pew

May 18, 2023
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...

5,355 views0 comments

Keyboard Shortcuts that make it easier to work in Excel!

Kyle Pew

May 11, 2023
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...

5,172 views0 comments

Kyle Pew

Apr 27, 2023
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.

219 views0 comments

Use ChatGPT to Help Solve Excel Formulas

Kyle Pew

Mar 24, 2023
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,496 views0 comments

Kyle Pew

Mar 16, 2023
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...

426 views0 comments

Kyle Pew

Mar 9, 2023
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...

628 views0 comments

Learn to use an AMAZING feature in Excel! FLASH FILL

Kyle Pew

Feb 23, 2023
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...

427 views0 comments