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
55 Lessons (3h 50m)
    • 1. Introduction - Welcome To The Course

      1:43
    • 2. Opening Excel, & Creating A Shortcut

      3:45
    • 3. The Anatomy Of A Workbook

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

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

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

      1:41
    • 7. Editing Data - Text

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

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

      9:03
    • 10. A Quick Word On Formatting

      1:20
    • 11. Formatting Text - Alignment

      3:07
    • 12. Saving Time with AutoFilling Sequences

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

      4:23
    • 14. Saving Time with Format Painter

      2:48
    • 15. Changing The Column Width

      3:33
    • 16. Merge And Centre

      3:01
    • 17. Entering Data - A Couple Of Shortcuts

      3:57
    • 18. Sums - The Old Fashioned Way!

      3:11
    • 19. Sums - Using Autosum

      5:32
    • 20. Copying Formulas

      3:16
    • 21. SUMming Horizontally

      3:16
    • 22. Basic Formulas - Subtraction

      2:28
    • 23. Basic Formulas - Multiplication

      1:32
    • 24. Basic Formulas - Division

      1:21
    • 25. Average Function

      2:41
    • 26. The Order Of Mathematical Operation

      6:38
    • 27. POWER USER - Evaluate Formula Function

      4:50
    • 28. Inserting New Columns And Rows

      6:21
    • 29. Moving Existing Columns And Rows

      2:27
    • 30. Cutting, Copying, Inserting And Deleting

      6:07
    • 31. Hiding Columns And Rows

      2:41
    • 32. ROUNDing Functions

      5:55
    • 33. Formatting Numbers

      2:12
    • 34. A Primer On Building Complex Formulas

      3:10
    • 35. Building A Complex Formula

      4:19
    • 36. Sorting

      4:16
    • 37. Wrapping Text And Soft Enter

      3:59
    • 38. Adding A New Worksheet

      1:07
    • 39. Creating A Simple Chart

      4:20
    • 40. Adding Borders

      2:36
    • 41. Customizing the Quick Access Toolbar

      2:11
    • 42. Simple Printing

      3:34
    • 43. Freezing For An Easier View

      4:06
    • 44. Getting Help

      1:39
    • 45. Filters

      6:21
    • 46. Highlighting Cells

      2:03
    • 47. Closing - Thank You!

      1:30
    • 48. Bonus 1 Whizzing Around Excel Revision

      6:45
    • 49. Bonus 2 Keyboard Shortcuts

      11:18
    • 50. A1 Style - Relative Relative

      2:15
    • 51. $A1 Style - Absolute Relative

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

      2:44
    • 53. A$1 Style - Relative Absolute

      2:01
    • 54. Level 1 SQA 01 Reverse Engineering A Sample Spreadsheet

      20:55
    • 55. Level 1 SQA 02 Casing And Text Functions

      6:35
92 students are watching this class

Project Description

Here you will find a practice file to help cement your learning, and a few downloadable pdf's to keep with you until they become second nature!

Student Projects

project card
1 comment
project card
Ananya Ray
1 comment
project card
Terryn Acker
1 comment
project card
1 comment