Kyle Pew

Microsoft Certified Trainer
 https://www.officenewb.com/

Kyle Pew is a Microsoft Certified Trainer (MCT) and has been teaching and consulting for the past 18+ years across various applications including Microsoft Excel. Kyle believes that students best learn through the application of real-life business situations and exercises. Allowing students to guide the class with their specific situations allows for the quickest and easiest adaptation to new technology and skills. He currently guides 700k+ students across 19 courses on www.udemy.com.

Kyle enjoys spending time with his family (6 children). When he’s not busy entertaining his kids, you’ll find him cheering on his favorite hockey team, the San Jose Sharks.

Social Profiles

All Sessions by Kyle Pew

  • The Academy (Day 1)

    (Beginner & Intermediate)

  • 10:00  - 13:30
    ✔︎ Entering and Editing Text Formulas ✔︎ Working with Basic Excel Functions ✔︎ Modifying an Excel Worksheet ✔︎ Formatting Data in an Excel Worksheet ✔︎ Inserting Images and Shapes into an Excel Worksheet ✔︎ Creating Basic Charts in Excel ✔︎ Printing an Excel Worksheet ✔︎ Working with Excel Templates
    (FREE) Visitor Ticket
    Delegate Ticket
    Master Delegate Ticket
    Where
    Academy Room

  • 14:00  - 18:00
    ✔︎ Working with an Excel List ✔︎ Excel List Functions ✔︎ Excel Data Validation ✔︎ Importing and Exporting Data ✔︎ Excel PivotTables ✔︎ Working with Excel's PowerPivot Tools ✔︎ Working with Large Sets of Excel Data
    (FREE) Visitor Ticket
    Delegate Ticket
    Master Delegate Ticket
    Where
    Academy Room

  • The Academy (Day 2)

    (Advanced & VBA)

  • 10:00  - 13:30
    ✔︎ Working with Excel's Conditional Functions ✔︎ Working with Excel's Lookup Functions ✔︎ Working with Excel's Text Based Functions ✔︎ Auditing an Excel Worksheet ✔︎ Protecting Excel Worksheets and Workbooks ✔︎ Mastering Excel's "What If?" Tools ✔︎ Automating Tasks in Excel with Macros
    (FREE) Visitor Ticket
    Delegate Ticket
    Master Delegate Ticket
    Where
    Academy Room

  • 14:00  - 18:00
    ✔︎ Using Excel's Macro Recorder Tool ✔︎ Excel VBA Concepts ✔︎ Moving Beyond the Basics and into VBA ✔︎ Preparing and Cleaning Up Data with a little VBA ✔︎ Using VBA to Automate Excel Formulas ✔︎ Bringing it All Together and a Weekly Report ✔︎ Working with Excel VBA User Forms ✔︎ Importing Data from Text Files
    (FREE) Visitor Ticket
    Delegate Ticket
    Master Delegate Ticket
    Where
    The Academy Room




Share

Kyle Pew