OfficeNewb.com

@UCbCHkRl8AGEVmdF369Er7VQ - 34.3K subscribers

🚀 Subscribe for weekly videos on Excel tricks, Microsoft 365 updates, and AI-powered tools like CoPilot! Welcome to OfficeNewb! 🎯 I'm Kyle Pew, a Microsoft Certified Trainer and Udemy Instructor Partner with over 2 million students worldwide. I’ve been teaching Microsoft Excel, Office 365, and productivity tools for 20+ years. On this channel, I share Excel tips, formulas, shortcuts, PivotTables, Power Query, VBA, Power BI, and automation with Power Automate—all designed to help you work smarter, not harder. Let’s master Office together!

Home Videos Live Playlists

This Excel Function Instantly Reshapes Lists - WRAPROWS Function

This Excel Function Instantly Reshapes Lists - WRAPROWS Function OfficeNewb.com

533 views - 2 days ago

Stop Fixing Excel Ranges — Use Spill References (#)

Stop Fixing Excel Ranges — Use Spill References (#) OfficeNewb.com

1K views - 1 week ago

This Excel Function Changes How You Combine Data (VSTACK)

This Excel Function Changes How You Combine Data (VSTACK) OfficeNewb.com

1.9K views - 1 week ago

You’re Importing CSV Files in Excel the Hard Way (New IMPORTCSV Function)

You’re Importing CSV Files in Excel the Hard Way (New IMPORTCSV Function) OfficeNewb.com

2.5K views - 2 weeks ago

Advanced Excel: Build a Fully Automated Task Calendar with One Formula

Advanced Excel: Build a Fully Automated Task Calendar with One Formula OfficeNewb.com

5.7K views - 4 weeks ago

Clean Messy Excel Data Fast (3 Tools You Should Know)

Clean Messy Excel Data Fast (3 Tools You Should Know) OfficeNewb.com

2.8K views - 4 weeks ago

The Microsoft Excel Power Query Trick You Aren't Using (But Should!)

The Microsoft Excel Power Query Trick You Aren't Using (But Should!) OfficeNewb.com

3.6K views - 4 weeks ago

Excel AI for Beginners: How to Use 'Analyze Data' (2026 Guide)

Excel AI for Beginners: How to Use 'Analyze Data' (2026 Guide) OfficeNewb.com

2.4K views - 4 weeks ago

Stop Using Helper Columns in Excel (Do This Instead)

Stop Using Helper Columns in Excel (Do This Instead) OfficeNewb.com

26.7K views - 1 month ago

Why Excel Pros Use the Double Dash Operator --

Why Excel Pros Use the Double Dash Operator -- OfficeNewb.com

9.4K views - 1 month ago

The Excel Function That Makes VLOOKUP Obsolete

The Excel Function That Makes VLOOKUP Obsolete OfficeNewb.com

5.1K views - 1 month ago

I Built a Fully Automatic Excel Report Using 3 Functions… Watch This!

I Built a Fully Automatic Excel Report Using 3 Functions… Watch This! OfficeNewb.com

5.7K views - 1 month ago

Why Excel Pros Love the TAKE Function (and You Will Too)

Why Excel Pros Love the TAKE Function (and You Will Too) OfficeNewb.com

28.8K views - 1 month ago

5 Excel Shortcuts EVERY Office Worker Should Know (Stop Wasting Time!)

5 Excel Shortcuts EVERY Office Worker Should Know (Stop Wasting Time!) OfficeNewb.com

4.3K views - 3 months ago

Stop Repeating Formulas! Use Excel’s MAP Function Instead

Stop Repeating Formulas! Use Excel’s MAP Function Instead OfficeNewb.com

89.3K views - 3 months ago

Excel SCAN Function: Dynamic Arrays Made Easy

Excel SCAN Function: Dynamic Arrays Made Easy OfficeNewb.com

43.8K views - 3 months ago

The Excel Upgrade You’re Not Using: Named LAMBDA Functions

The Excel Upgrade You’re Not Using: Named LAMBDA Functions OfficeNewb.com

2.9K views - 3 months ago

Stop Fixing Broken Excel Ranges — Use Table References Instead!

Stop Fixing Broken Excel Ranges — Use Table References Instead! OfficeNewb.com

9.3K views - 3 months ago

Stop Copying & Pasting in Excel — Do This Instead!

Stop Copying & Pasting in Excel — Do This Instead! OfficeNewb.com

56.3K views - 4 months ago

FINALLY - Excel PivotTables Just Got Smarter — Auto Refresh Is Here!

FINALLY - Excel PivotTables Just Got Smarter — Auto Refresh Is Here! OfficeNewb.com

2K views - 4 months ago

Use the DOT Operator in Excel Formulas - You'll Thank Me Later

Use the DOT Operator in Excel Formulas - You'll Thank Me Later OfficeNewb.com

2.8K views - 5 months ago

Excel AI Formula MAGIC - How to Use the Excel COPILOT() Function

Excel AI Formula MAGIC - How to Use the Excel COPILOT() Function OfficeNewb.com

2.1K views - 5 months ago

Excel Can Translate Languages?! Try These 2 Game-Changing Functions!

Excel Can Translate Languages?! Try These 2 Game-Changing Functions! OfficeNewb.com

1.7K views - 9 months ago

Rearrange Excel Data Effortlessly with the CHOOSECOLS & CHOOSEROWS Functions

Rearrange Excel Data Effortlessly with the CHOOSECOLS & CHOOSEROWS Functions OfficeNewb.com

3.3K views - 9 months ago

Excel PivotBy Function: 3 Powerful Examples

Excel PivotBy Function: 3 Powerful Examples OfficeNewb.com

5.5K views - 10 months ago

Stop Doing It Manually! Calculating Comma-Delimited Numbers in Excel

Stop Doing It Manually! Calculating Comma-Delimited Numbers in Excel OfficeNewb.com

1.7K views - 11 months ago

Transform Your Excel Data: Simple Steps to Stunning Charts!

Transform Your Excel Data: Simple Steps to Stunning Charts! OfficeNewb.com

2.4K views - 11 months ago

Make Excel Work for You: Dynamic Titles & Filters Using the CELL Function

Make Excel Work for You: Dynamic Titles & Filters Using the CELL Function OfficeNewb.com

10.8K views - 11 months ago

4 Essential Microsoft Excel Tricks You’ll Wish You Knew Earlier

4 Essential Microsoft Excel Tricks You’ll Wish You Knew Earlier OfficeNewb.com

2.8K views - 11 months ago

Create a Dynamic Gantt Chart in Excel Using Conditional Formatting

Create a Dynamic Gantt Chart in Excel Using Conditional Formatting OfficeNewb.com

10.9K views - 1 year ago

Mastering the DGET Function in Excel: A Hidden Gem for Powerful Data Lookups!

Mastering the DGET Function in Excel: A Hidden Gem for Powerful Data Lookups! OfficeNewb.com

8.9K views - 1 year ago

5 Excel VBA Procedures to Save You Time Like a Pro

5 Excel VBA Procedures to Save You Time Like a Pro OfficeNewb.com

2.8K views - 1 year ago

Master Excel with VLOOKUP and IF: A Must-Know Technique for Professionals

Master Excel with VLOOKUP and IF: A Must-Know Technique for Professionals OfficeNewb.com

5.1K views - 1 year ago

Create Dynamic Excel Reports Using Simple Excel Shapes

Create Dynamic Excel Reports Using Simple Excel Shapes OfficeNewb.com

3.1K views - 1 year ago

Harnessing Microsoft Excel’s Paste Special - Multiply Feature: Practical Use Cases

Harnessing Microsoft Excel’s Paste Special - Multiply Feature: Practical Use Cases OfficeNewb.com

1.6K views - 1 year ago

Unlocking the Power of PowerPoint Designer and CoPilot: Create Stunning Presentations with Ease

Unlocking the Power of PowerPoint Designer and CoPilot: Create Stunning Presentations with Ease OfficeNewb.com

2.4K views - 1 year ago

Microsoft Excel Lesser-Known Shortcuts Saving You Time

Microsoft Excel Lesser-Known Shortcuts Saving You Time OfficeNewb.com

2.2K views - 1 year ago

Microsoft Excel - Single Excel List with Multiple Excel PivotCharts

Microsoft Excel - Single Excel List with Multiple Excel PivotCharts OfficeNewb.com

5.9K views - 1 year ago

Introduction to Microsoft Power BI for Excel Users

Introduction to Microsoft Power BI for Excel Users OfficeNewb.com

2.3K views - 1 year ago

Microsoft Excel - Summarize Data with the GROUPBY Function

Microsoft Excel - Summarize Data with the GROUPBY Function OfficeNewb.com

8.3K views - 1 year ago

REGEXEXTRACT - Microsoft Excels New Regular Expression Function

REGEXEXTRACT - Microsoft Excels New Regular Expression Function OfficeNewb.com

3.1K views - 1 year ago

Microsoft Excel Interactive Checkboxes (New Feature)

Microsoft Excel Interactive Checkboxes (New Feature) OfficeNewb.com

4.4K views - 2 years ago

Microsoft Excel - 5 Most Common Excel Functions

Microsoft Excel - 5 Most Common Excel Functions OfficeNewb.com

11K views - 2 years ago

Apply Conditional Formatting to Microsoft Excel Charts

Apply Conditional Formatting to Microsoft Excel Charts OfficeNewb.com

26.3K views - 2 years ago

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

Microsoft Excel - Dynamic Drop-Down Menus (NO VBA) OfficeNewb.com

8.6K views - 2 years ago

Microsoft Excel's IF() Function Lookup

Microsoft Excel's IF() Function Lookup OfficeNewb.com

2.1K views - 2 years ago

Mastering Your Finances: The Snowball Debt Strategy in Excel

Mastering Your Finances: The Snowball Debt Strategy in Excel OfficeNewb.com

9.7K views - 2 years ago

New Python Feature Coming SOON to Excel!

New Python Feature Coming SOON to Excel! OfficeNewb.com

1.8K views - 2 years ago

Microsoft Excels New TOCOL() Function

Microsoft Excels New TOCOL() Function OfficeNewb.com

4.5K views - 2 years ago

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

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

10.7K views - 2 years ago

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

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

39.2K views - 2 years ago

Keyboard Shortcuts that make it easier to work in Excel!

Keyboard Shortcuts that make it easier to work in Excel! OfficeNewb.com

3.7K views - 2 years ago

Use ChatGPT to Help Solve Excel Formulas

Use ChatGPT to Help Solve Excel Formulas OfficeNewb.com

8.3K views - 2 years ago

How to use Excels New IMAGE Function

How to use Excels New IMAGE Function OfficeNewb.com

1.2K views - 2 years ago

Google Sheets for Excel Users

Google Sheets for Excel Users OfficeNewb.com

4.6K views - 2 years ago

Learn to use an AMAZING feature in Excel! FLASH FILL

Learn to use an AMAZING feature in Excel! FLASH FILL OfficeNewb.com

1.7K views - 3 years ago

Working with Pivot Tables in Excel - Groups

Working with Pivot Tables in Excel - Groups OfficeNewb.com

2.6K views - 3 years ago

Learn how to use the REPT (repeat) Function in Excel

Learn how to use the REPT (repeat) Function in Excel OfficeNewb.com

17.6K views - 3 years ago

Using Page Breaks and Section Breaks in Word

Using Page Breaks and Section Breaks in Word OfficeNewb.com

7.1K views - 3 years ago

Using Excel Functions to return Multiple Values

Using Excel Functions to return Multiple Values OfficeNewb.com

7.3K views - 3 years ago