# 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
56 Lessons (3h 53m)
• 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

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

2:36

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
• 56. Level 1 SQA 03 Charts From A Filtered List

2:54
160 students are watching this class
##### How students rated this class
Best Suited for

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!