Microsoft Excel Essentials: Level 1 Basics - Master Excel Step-By-Step - Learn Excel Fundamentals!
Alan Jarvis, Everything Is Easy, Once You Know How
-
-
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
-
