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. 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 -
13. POWER USER - Adding Your Own Lists To Autofill
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 -
40. Adding Borders
2:36 -
41. Customizing the Quick Access Toolbar
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
-
