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
82 Videos (7h 6m)
    • 0 - Introduction, And Welcome To The Course

      1:57
    • 1 - Proof Of Concept

      4:49
    • 1 - Planning Ahead

      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
    • 1 - Adding Time

      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
    • 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
    • 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