Office Hours with Amber

Every Monday at 7PM EST – Weekly YouTube livestream dedicated to continuous improvement, Microsoft Office, and data analytics.

https://www.youtube.com/@officehourswithamber

Season 2: Engineering Improv

Season 2: Engineering Improv

13 Videos

Season 2 • Office Hours with Amber • Engineering Improv

0:18

How a piece of paper saves us 100s of hours in Inventory Counting || Peachy Profitability

1:01:20

#1 - How to copyright / watermark your excel sheets - #EngineeringImprov

1:01:40

#2 - Mapping Sales Process #EngineeringImprov

1:05:40

#3 - Good Idea Categorization - Goals vs Projects vs Tasks - #EngineeringImprov

1:04:07

#4 - Consulting "Portal" #EngineeringImprov

1:02:14

#5 - Finding a new recurring habit / task tracker - EngineeringImprov

1:16:37

Trying xTiles - Click Around and Find Out #CAFO

2:27:27

#6 - Building Cost Estimator Template #EngineeringImprov

1:00:51

#7 - Continue Building Cost Estimator Template #EngineeringImprov

1:52:56

#8 - Data Obfuscation - #EngineeringImprov

1:06:46

realistically, a stream for burnt out women in business

59:16

#10 - Task Sub Characteristics and Music Production?? #engineeringimprov

1:01:20

Season 1: Office Hours with Amber (Excel)

Season 1: Office Hours with Amber

52 Videos

2025 Office Hours with Amber

0:37

1x2 - Building Quoting Tool using Dynamic Arrays in Excel

58:56

2x1 - A tale of technical difficulties - Back to Basics of Power Query

1:01:11

2x2 - Utilizing Power Query for Growth Ramp Innovation Forecasting

1:00:09

2x3 - Body Double Working Session x Power Query

59:36

3x1 - Learning PowerApps

1:01:03

3x2 - Creating Basic WMS with PowerApps

1:03:14

3x3 - PowerApps Guidance from Ashleigh Roberts (fps fixed @ 27min)

58:27

3x4 - Community Call

1:00:15

AMBER'S 30th BIRTHDAY STREAM!!

1:01:58

March Week 2 - Creating Basic WMS with PowerApps

1:02:49

4x1 - Learning Basics of =LET() Function in Excel

1:01:08

4x2 - Implementing =LET() Function

59:59

4x3 - Iterative Feedback on LET() Function Tool with Emilie Williams

1:03:38

4x4 - Community Call

58:00

5x1 - Learning Basics of =LAMBDA() (bad audio lag)

1:02:00

5x2 - Implementing =LAMBDA() Function in Excel

1:02:22

5x3 - Feedback with Freelove on Lambdas in Excel

1:18:18

5x4 - Community Call - PURE TECHNICAL CHAOS.

57:57

6x1 Learning Micro Automations with OA Robot in Excel

1:03:32

6x2 Lambda Robot with @excelrobot

1:05:37

6x3 Applying what I've learned about OA Robot

1:00:48

6x4 Community Call || Perfectionism

1:05:35

6x5 - What even is Peachy Profitability?

1:03:01

7x1 - Python in Excel - When is it really the right tool to use?

1:00:13

7x2 - Python in Excel - Applying PY to a real work problem

58:42

7x3 - Ultimate Excel User Sin Confessional (so sorry about the camera wiggling)

40:51

7x4 Community Call || Accountability

1:03:02

8x1 - Intro to Financial Modelling x @FullStackModeller

1:02:16

8x2 - pt.2 Intro to Financial Modelling x @FullStackModeller

1:08:21

8x3 - Interview + Feedback with @TheHumbleMVP Giles Male

1:09:30

8x4 Community Call

1:05:22

Battle VIII Live Attempt - @msexcelesports starts at 35:09

1:06:01

9x1 - Excel e-Sports Back to Basics Training x @msexcelesports

1:00:18

9x2 - Live Attempt: Potions Master Case x @msexcelesports

1:00:52

9x3 - Live Attempt: Ship the World x @msexcelesports

59:38

9x4 - Live Attempt: Deep Sea Diving x Community Call x @msexcelesports

1:00:58

9x5 -Behind the Rebrand x @kzoomcreative

1:04:26

10x1 - PowerPoint like a Pro (Technical Updates, Morph, Ctrl+Drag)

1:06:17

10x2 - PowerPoint like a Pro (Presentation Frameworks)

1:00:55

10x3 - PowerPoint like a Pro (Building the Presentation)

1:04:06

10x4 - Community Call

1:04:52

2025 Qualification Round Live Attempt - ⁨@msexcelesports⁩ 15:33 Start

1:17:00

2025 Round 1 (30:59) & 2 (1:11:15) Live Attempt - ⁨@msexcelesports⁩

1:59:20

11x1 - Learning Business Budget Creation Strategies for 2026 Planning (Starting 7:51)

1:01:43

11x2 - Building 2026 KPI and Financial Budgets

59:55

11x3 - Building 2026 KPI and Financial Budgets

1:01:10

11x4 - I Failed! Chaotic Amber Brain Rot + Getting Ready for The Active Cell Conference!

59:46

12x2 - Recap: Microsoft Excel World Championships, Collegiate Challenge, Active Cell Conference

1:39:14

12x3 - Vegas Recap v2

1:01:06

12x3 - 2026 Plan

2:10:36

12x4 - 2025 Review

1:16:39