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
90 students are watching this class
How students rated this class
Leave Review

Watch more to review

We ask our students to watch a few lessons before reviewing to make sure we get quality feedback!

Best Suited for
 --  Beginner Intermediate Advanced Beginner/Intermediate Intermediate/Advanced All Levels

Community Generated

The level is determined by a majority opinion of students who have reviewed this class. The teacher's recommendation is shown until at least 5 student responses are collected.

Be the first!

No ratings just yet—watch a few lessons to be the first to share whether this class met your expectations.

Expectations Met?
  • Exceeded!
    0%
  • Yes
    0%
  • Somewhat
    0%
  • Not really
    0%
Be the first to leave a review in our updated system!
Reviews Archive

In October 2018, we updated our review system to improve the way we collect feedback. Below are the reviews written before that update. You are welcome to edit your old review into the new system!

147 of 147 students recommend this class