Special ESPN Pricing:
https://www.mrexcel.com/news/special-ocho-deals-on-training-books-to-celebrate-excel-being-on-espn/

The Excel All Star Battle will air on ESPN2 at:
Friday August 5, 2022 at 5 AM Eastern. (2 AM Pacific. 10 AM in London.)
Sunday August 7, 2022 at 9AM Eastern. (6 AM Pacific, Noon in London.)
Monday August 8 (8/8!), 2022 at 11:30 PM Eastern. (8:30 PM Pacific – Prime Time, Baby! And 4:30 AM Tuesday in London).

Bill’s favorite Excel trick: Fast Formula Copy, as well as a lot of other items.

Table of Contents
(0:00) Historical re-enactment
(0:20) Data description
(1:00) Begins typing
(1:38) Adding text is #VALUE error
(1:57) & to Concatenate
(2:10) FORMULATEXT function
(2:36) Adding a space while joining text
(3:09) Needs Proper Case
(3:38) 500 functions in Excel
(3:50) PROPER function
(4:20) 5-Step way to copy
(5:10) Hello YouTube viewers
(6:00) Excel in Olympics Joke
(6:33) Excel on ESPN
(7:10) Dragging Fill Handle is a drag
(8:24) Double-click Fill Handle
(8:42) Blank cell in adjacent column
(9:21) 3 Ways to Undo in Excel
(9:35) Right-Drag to Paste Values
(9:50) Alternate Drag and Drop
(10:10) ESPN versus Olympics
(10:29) I bought a commercial on ESPN8
(10:47) Ocho-themed deals
(11:10) Promo Codes Woes
(11:40) Buy from Amazon in USA
(12:05) Buy e-Books
(12:20) Liam Bastick Financial Models in Power BI
(12:45) Wyn Hopkins Power BI for Excel Analyst
(13:05) Mike Girvin Only App That Matters
(13:25) Oz & Bill new Edition
(14:05) Courses on Retrieve