Excel Legend Bob Umlas MVP Episodes 1, 2, 3

Aug 31, 2022 Excel MVP Secrets In Episode 1

Microsoft MVP Bob Umlas teaches you how to: Get totals in 5 different ways, remove unnecessary text in your Excel cell, arrange multiple workbooks in order, add columns in a textbook and distribute values within a range evenly. All that in just under 10 minutes!

https://www.youtube.com/watch?v=yGzGebBZraE

Excel Secrets:

0:00 Get the total (in 5 different ways!)

2:22 Remove unnecessary text in a cell

5:44 Arrange multiple workbooks in order

7:12 Add columns in a textbox

7:48 Distribute values within a range evenly

Sep 7, 2022 Excel MVP Secrets In Episode 2

Microsoft MVP Bob Umlas teaches you how to: Add a blank row in-between rows, Enter totals in a pattern, Mirror your data, create a table of contents and how to style your comments. All that in under 10 minutes!

https://www.youtube.com/watch?v=VqDIkpk69-w

Excel Secrets:

0:00 How to add a blank row in-between rows

1:14 Enter totals in a pattern

2:08 Mirror your data

3:31 Create a table of contents

4:51 Style your comments

Sep 14, 2022 Excel MVP Secrets Episode 3

Microsoft MVP Bob Umlas teaches you how to: Sort your mailing lists by last names, switch your mailing list info from rows to columns, switch info from 1 column to multiple rows. All this in under 10 minutes!

https://www.youtube.com/watch?v=PDeTYygkx3g

Excel Secrets:

0:00 Sort your mailing lists by last names

1:24 Switch your mailing list info from rows to columns

2:45 Switch info from 1 column to multiple rows