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
    • 14. POWER USER - Adding Your Own Lists To Autofill

      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
    • 41. Adding Borders

      2:36
    • 42. Customizing the Quick Access Toolbar

      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
147 students are watching this class