Microsoft Excel Essentials: Level 2 - For Intermediate/Advanced Students - From User To Superuser - Skillshare

# Microsoft Excel Essentials: Level 2 - For Intermediate/Advanced Students - From User To Superuser

#### Alan Jarvis, Everything Is Easy, Once You Know How

Play Speed
• 0.5x
• 1x (Normal)
• 1.25x
• 1.5x
• 2x
90 Videos (8h 2m)
• 0 - Introduction, And Welcome To The Course

1:57
• 1 - Proof Of Concept

4:49

2:13
• 1 - Creating Our Data Entry Screen

4:08
• 1 - (Custom) Formatting Dates & Time

6:02
• 1 - Simple Calculations With Time

2:35
• 1 - More (Useful) Calculations With Time

8:06
• 1 - It's About Time!

8:28

3:39
• 1 - Creating A Template From An Image

11:34
• 1 - Importing A Template From An Existing Excel File

2:21
• 1 - Converting Time To A Decimal

5:41
• 1 - A Little Bit Of Simple Data Entry

3:11
• 1 - Simple Conditional Formatting For A Cleaner View

4:42
• 1 - Calculating Time Out Of House Using Travel Time

4:46
• 1 - Simple Logical Testing And Nested Logical Testing

8:28
• 1 - Building Text Strings With A Formula

12:10
• 1 - A Tick Box Exervise (Of Sorts)

7:11
• 1 - Auto-populating Check Boxes

11:48
• 1 - PRACTICE EXERCISE 1 - Time To Add A New Entry

1:40
• 1 - Defining A Working Area And Protecting Your Work

4:40
• 1 - PRACTICE EXERCISE 2 - Set Up A Working Area And Limit User Entry

1:06
• 2 - Simple VLOOKUPs

4:16
• 2 - Step1: Get Some Data In And Split It!

3:54
• 2 - Using Data Validation To Get The Right Input

3:47
• 2 - Let's Build Our Database!

6:12
• 2 - Importing Data From A Text File

2:01
• 2 - Importing Data From A Word File

2:37
• 2 - Pulling Data From Multiple Sources

3:33
• 2 - Using OTHER Look-Ups To Look Up!

5:25
• 2 - LOOKUP From A LOOKUP With No Intermediary Step

2:19
• 2 - Data Arrays Don't Have To Start At A!

2:58
• 2 - Some Common Reasons VLook-Ups Fail

6:02
• 2 - One Inherent Flaw In Vlook-Up

1:10
• 2 - POWER USER - A Breakdown Of Looking Up Backwards

6:44
• 2 - POWER USER - The Other Way Of Looking Up Backwards

6:49
• 2 - Backwards Look-Ups In Action

3:47
• 2 - POWER USER - Dealing With Inconsistencies In User Entry

8:19
• 2 - POWER USER - Fuzzy VLOOKUPs

3:33
• 2 - POWER USER - VLOOKUPs With Multiple Inputs

9:39
• 2 - POWER USER - Looking Up From Multiple Inputs Using An Array Formula

4:45
• 2 - VLOOKUPs Brother...HLOOKUP

5:04
• 2 - POWER USER - The Holy Grail - How To Return Multiple Values From A Single LookUp

13:33
• 2 - What To Look For When THAT Formula Didn't Work

4:05
• 2 - The Fastest Way To Modify Your Column Numbers

7:24
• 2 - POWER USER - VLOOKUPS With Moving Columns

3:05
• 2 - Putting It All Together

9:52
• 2 - The Finishing Touch: How Many Records Did I Find?

4:28
• 3 - A Simple Static Named Range Using A Single Cell

3:44
• 3 - Creating A Named Range Using A Range Of Cells

2:53
• 3 - Using Row Labels To Name Multiple Ranges

2:34
• 3 - POWER USER - A Magic Trick Using Row And Column Labels

4:55
• 3 - POWER USER - Dynamic Named Ranges

8:06
• 3 - POWER USER - What To Do With Dynamic Names Ranges With Titles

5:22
• 3 - POWER USER - Dynamic Charts

10:27
• 3 - Horizontal Dynamic Named Ranges

11:09
• 4 - Welcome to "What Can I Have For Dinner?" or...What Would I Use THAT for?

1:25
• 4 - Hyperlinking To A Different Sheet In The Same Workbook

3:32
• 4 - Creating Our First Macro

5:37
• 4 - Assigning A Macro To A Button

4:13
• 4 - Creating A List For Our Dropdown Using A Dynamic Named Range

1:39
• 4 - Using A Conditional Format To Know When A Value Is Missing

4:34
• 4 - Copying Conditional Formats And Creating Our Drop Downs

2:50
• 4 - Building Our Formula...INDIRECT Function

2:55
• 4 - Building Strings For Indirect Sheet And Cell References

7:16
• 4 - It's A One Or A Zero

2:35
• 4 - Working The Percentages And Adding Traffic Lights

4:06
• 4 - POWER USER - The HYPERLINK Function (And Problem)

3:16
• 4 - Exercise 1 - Fill In The Blanks

0:59
• 4 - Exercise 2 - Pretty It Up With A Macro

1:45
• 4 - Exercise 3 - Create A VLOOKUP Using A Built String With INDIRECT

2:13
• 5 - Creating A Gantt Chart Using A Worksheet

7:39
• 5 - Building The First Part Of Our Logical Test

4:20
• 5 - Multiple Logical Tests At Once Using AND

8:28
• 5 - Conditional Formatting

5:32
• 5 - Gantt Charts Using The Built In Charting Tools

4:51
• 5 - Gantt Charts With Different Colors For Different Criteria

7:47
• Bonus 001 Creating UK License Plate Numbers

7:14
• SQA 01 - Casing

6:35
• SQA - 02 Choose

14:47
• SQA 03 - Calls Text Data - How to Return A Column Title Based on a Value

6:42
• SQA 04 - Calls Text Data - How to Return A Column Title Based on Text

9:02
• SQA 05 - Extracting Phone Numbers From A Cell

2:39
• SQA 06 - VLookUps With Pictures!

4:30
• SQA 07 - Extracting a Unique List, And Summing The Money!

2:25
• SQA 08 - SUMIF With Dynamic Sum Range

5:55
• SQA 09 - Dynamic Charting From A Drop Down

10:02
• SQA 10 - Data Validation With Dependent Drop-downs

3:42
• SQA 11 Data Validation With Dependent Drop-downs (Dynamic Named Range Workaround)

8:30
• SQA 12 Kinda A Vlookup From 2 Drop down Lists

6:47
95 students are watching this class