Microsoft Excel Essentials: Level 1 Basics - Master Excel Step-By-Step - Learn Excel Fundamentals!

Alan Jarvis, Everything Is Easy, Once You Know How

Play Speed
  • 0.5x
  • 1x (Normal)
  • 1.25x
  • 1.5x
  • 2x
53 Videos (3h 23m)
    • Introduction - Welcome To The Course

      1:43
    • Opening Excel, & Creating A Shortcut

      3:45
    • The Anatomy Of A Workbook

      15:19
    • A Quick Review Of What's Where

      6:11
    • Always Do This FIRST! - Save Your New Workbook

      2:00
    • Let's Enter Some Data - Text

      1:41
    • Editing Data - Text

      1:42
    • Ooops. I Made A Mistake - Undo and Redo

      1:20
    • Changing The Appearance Of Text With Formatting - Fonts

      9:03
    • A Quick Word On Formatting

      1:20
    • Formatting Text - Alignment

      3:07
    • Saving Time with AutoFilling Sequences

      4:41
    • POWER USER - Adding Your Own Lists To Autofill

      4:23
    • Saving Time with Format Painter

      2:48
    • Changing The Column Width

      3:33
    • Merge And Centre

      3:01
    • Entering Data - A Couple Of Shortcuts

      3:57
    • Sums - The Old Fashioned Way!

      3:11
    • Sums - Using Autosum

      5:32
    • Copying Formulas

      3:16
    • SUMming Horizontally

      3:16
    • Basic Formulas - Subtraction

      2:28
    • Basic Formulas - Multiplication

      1:32
    • Basic Formulas - Division

      1:21
    • Average Function

      2:41
    • The Order Of Mathematical Operation

      6:38
    • POWER USER - Evaluate Formula Function

      4:50
    • Inserting New Columns And Rows

      6:21
    • Moving Existing Columns And Rows

      2:27
    • Cutting, Copying, Inserting And Deleting

      6:07
    • Hiding Columns And Rows

      2:41
    • ROUNDing Functions

      5:55
    • Formatting Numbers

      2:12
    • A Primer On Building Complex Formulas

      3:10
    • Building A Complex Formula

      4:19
    • Sorting

      4:16
    • Wrapping Text And Soft Enter

      3:59
    • Adding A New Worksheet

      1:07
    • Creating A Simple Chart

      4:20
    • Adding Borders

      2:36
    • Customizing the Quick Access Toolbar

      2:11
    • Simple Printing

      3:34
    • Freezing For An Easier View

      4:06
    • Getting Help

      1:39
    • Filters

      6:21
    • Highlighting Cells

      2:03
    • Closing - Thank You!

      1:30
    • Bonus 1 Whizzing Around Excel Revision

      6:45
    • Bonus 2 Keyboard Shortcuts

      11:18
    • A1 Style - Relative Relative

      2:15
    • $A1 Style - Absolute Relative

      2:16
    • $A$1 Style - Absolute Absolute

      2:44
    • A$1 Style - Relative Absolute

      2:01