OfficeNewb.com
🚀 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!
Перестаньте повторять формулы! Используйте функцию MAP в Excel.
Функция SCAN в Excel: динамические массивы стали проще
Обновление Excel, которое вы не используете: именованные LAMBDA-функции
Перестаньте исправлять поврежденные диапазоны Excel — используйте вместо этого ссылки на таблицы!
Перестаньте копировать и вставлять в Excel — сделайте это!
НАКОНЕЦ-ТО — сводные таблицы Excel стали умнее — теперь есть функция автоматического обновления!
Use the DOT Operator in Excel Formulas - You'll Thank Me Later
Excel AI Formula MAGIC - How to Use the Excel COPILOT() Function
Excel Can Translate Languages?! Try These 2 Game-Changing Functions!
Rearrange Excel Data Effortlessly with the CHOOSECOLS & CHOOSEROWS Functions
Excel PivotBy Function: 3 Powerful Examples
Stop Doing It Manually! Calculating Comma-Delimited Numbers in Excel
Transform Your Excel Data: Simple Steps to Stunning Charts!
Make Excel Work for You: Dynamic Titles & Filters Using the CELL Function
4 Essential Microsoft Excel Tricks You’ll Wish You Knew Earlier
Create a Dynamic Gantt Chart in Excel Using Conditional Formatting
Mastering the DGET Function in Excel: A Hidden Gem for Powerful Data Lookups!
5 Excel VBA Procedures to Save You Time Like a Pro
Master Excel with VLOOKUP and IF: A Must-Know Technique for Professionals
Create Dynamic Excel Reports Using Simple Excel Shapes
Harnessing Microsoft Excel’s Paste Special - Multiply Feature: Practical Use Cases
Unlocking the Power of PowerPoint Designer and CoPilot: Create Stunning Presentations with Ease
Microsoft Excel Lesser-Known Shortcuts Saving You Time
Microsoft Excel - Single Excel List with Multiple Excel PivotCharts
Introduction to Microsoft Power BI for Excel Users
Microsoft Excel - Summarize Data with the GROUPBY Function
REGEXEXTRACT - Microsoft Excels New Regular Expression Function
Microsoft Excel Interactive Checkboxes (New Feature)
Microsoft Excel - 5 Most Common Excel Functions
Apply Conditional Formatting to Microsoft Excel Charts