Microsoft Excel Essentials: Level 1 Basics - Master Excel Step-By-Step - Learn Excel Fundamentals! | Alan Jarvis | Skillshare

# 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
57 Lessons (3h 54m)
• 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. Accessing The "F" Keys (Function Keys) On A Laptop

0:54
• 6. Always Do This FIRST! - Save Your New Workbook

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

1:41
• 8. Editing Data - Text

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

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

9:03
• 11. A Quick Word On Formatting

1:20
• 12. Formatting Text - Alignment

3:07
• 13. Saving Time with AutoFilling Sequences

4:41

4:23
• 15. Saving Time with Format Painter

2:48
• 16. Changing The Column Width

3:33
• 17. Merge And Centre

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

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

3:11
• 20. Sums - Using Autosum

5:32
• 21. Copying Formulas

3:16
• 22. SUMming Horizontally

3:16
• 23. Basic Formulas - Subtraction

2:28
• 24. Basic Formulas - Multiplication

1:32
• 25. Basic Formulas - Division

1:21
• 26. Average Function

2:41
• 27. The Order Of Mathematical Operation

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

4:50
• 29. Inserting New Columns And Rows

6:21
• 30. Moving Existing Columns And Rows

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

6:07
• 32. Hiding Columns And Rows

2:41
• 33. ROUNDing Functions

5:55
• 34. Formatting Numbers

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

3:10
• 36. Building A Complex Formula

4:19
• 37. Sorting

4:16
• 38. Wrapping Text And Soft Enter

3:59
• 39. Adding A New Worksheet

1:07
• 40. Creating A Simple Chart

4:20

2:36

2:11
• 43. Simple Printing

3:34
• 44. Freezing For An Easier View

4:06
• 45. Getting Help

1:39
• 46. Filters

6:21
• 47. Highlighting Cells

2:03
• 48. Closing - Thank You!

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

6:45
• 50. Bonus 2 Keyboard Shortcuts

11:18
• 51. A1 Style - Relative Relative

2:15
• 52. \$A1 Style - Absolute Relative

2:16
• 53. \$A\$1 Style - Absolute Absolute

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

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

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

6:35
• 57. Level 1 SQA 03 Charts From A Filtered List

2:54
291 students are watching this class