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

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
88 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!

10 KB

1 comment
Ananya Ray
1 comment
Terryn Acker
1 comment
1 comment