🚀 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!

Excel Can Translate Languages?! Try These 2 Game-Changing Functions!
7:05
Excel Can Translate Languages?! Try These 2 Game-Changing Functions!
Rearrange Excel Data Effortlessly with the CHOOSECOLS & CHOOSEROWS Functions
10:54
Rearrange Excel Data Effortlessly with the CHOOSECOLS & CHOOSEROWS Functions
Excel PivotBy Function: 3 Powerful Examples
19:34
Excel PivotBy Function: 3 Powerful Examples
Stop Doing It Manually! Calculating Comma-Delimited Numbers in Excel
3:20
Stop Doing It Manually! Calculating Comma-Delimited Numbers in Excel
Transform Your Excel Data: Simple Steps to Stunning Charts!
18:28
Transform Your Excel Data: Simple Steps to Stunning Charts!
Make Excel Work for You: Dynamic Titles & Filters Using the CELL Function
15:04
Make Excel Work for You: Dynamic Titles & Filters Using the CELL Function
4 Essential Microsoft Excel Tricks You’ll Wish You Knew Earlier
12:40
4 Essential Microsoft Excel Tricks You’ll Wish You Knew Earlier
Create a Dynamic Gantt Chart in Excel Using Conditional Formatting
25:07
Create a Dynamic Gantt Chart in Excel Using Conditional Formatting
Mastering the DGET Function in Excel: A Hidden Gem for Powerful Data Lookups!
15:50
Mastering the DGET Function in Excel: A Hidden Gem for Powerful Data Lookups!
5 Excel VBA Procedures to Save You Time Like a Pro
17:53
5 Excel VBA Procedures to Save You Time Like a Pro
Master Excel with VLOOKUP and IF: A Must-Know Technique for Professionals
8:59
Master Excel with VLOOKUP and IF: A Must-Know Technique for Professionals
Create Dynamic Excel Reports Using Simple Excel Shapes
16:53
Create Dynamic Excel Reports Using Simple Excel Shapes
Harnessing Microsoft Excel’s Paste Special - Multiply Feature: Practical Use Cases
8:48
Harnessing Microsoft Excel’s Paste Special - Multiply Feature: Practical Use Cases
Unlocking the Power of PowerPoint Designer and CoPilot: Create Stunning Presentations with Ease
14:52
Unlocking the Power of PowerPoint Designer and CoPilot: Create Stunning Presentations with Ease
Microsoft Excel Lesser-Known Shortcuts Saving You Time
8:54
Microsoft Excel Lesser-Known Shortcuts Saving You Time
Microsoft Excel - Single Excel List with Multiple Excel PivotCharts
7:57
Microsoft Excel - Single Excel List with Multiple Excel PivotCharts
Introduction to Microsoft Power BI for Excel Users
34:28
Introduction to Microsoft Power BI for Excel Users
Microsoft Excel - Summarize Data with the GROUPBY Function
4:41
Microsoft Excel - Summarize Data with the GROUPBY Function
REGEXEXTRACT - Microsoft Excels New Regular Expression Function
19:48
REGEXEXTRACT - Microsoft Excels New Regular Expression Function
Microsoft Excel Interactive Checkboxes (New Feature)
17:00
Microsoft Excel Interactive Checkboxes (New Feature)
Microsoft Excel - 5 Most Common Excel Functions
18:10
Microsoft Excel - 5 Most Common Excel Functions
Apply Conditional Formatting to Microsoft Excel Charts
9:25
Apply Conditional Formatting to Microsoft Excel Charts
Microsoft Excel - Dynamic Drop-Down Menus (NO VBA)
10:47
Microsoft Excel - Dynamic Drop-Down Menus (NO VBA)
Microsoft Excel's IF() Function Lookup
7:49
Microsoft Excel's IF() Function Lookup
Mastering Your Finances: The Snowball Debt Strategy in Excel
13:46
Mastering Your Finances: The Snowball Debt Strategy in Excel
New Python Feature Coming SOON to Excel!
17:47
New Python Feature Coming SOON to Excel!
Microsoft Excels New TOCOL() Function
11:45
Microsoft Excels New TOCOL() Function
Microsoft Excel - Double a Penny for 30 Days: How Much Would You Have?
4:24
Microsoft Excel - Double a Penny for 30 Days: How Much Would You Have?
Mini Calendar Add-In for Excel and a little VBA code
8:25
Mini Calendar Add-In for Excel and a little VBA code
Keyboard Shortcuts that make it easier to work in Excel!
6:55
Keyboard Shortcuts that make it easier to work in Excel!