MICROSOFT EXCEL TOPICS
Potential Topics to share: https://www.skillshare.com/browse/microsoft-office?via=browse-related-skills
57 Lessons
1. Introduction - Welcome To The Course
2. Opening Excel, & Creating A Shortcut
3. The Anatomy Of A Workbook
4. A Quick Review Of What's Where
5. Accessing The "F" Keys (Function Keys) On A Laptop
6. Always Do This FIRST! - Save Your New Workbook
7. Let's Enter Some Data - Text
8. Editing Data - Text
9. Ooops. I Made A Mistake - Undo and Redo
10. Changing The Appearance Of Text With Formatting - Fonts
11. A Quick Word On Formatting
12. Formatting Text - Alignment
13. Saving Time with AutoFilling Sequences
14. POWER USER - Adding Your Own Lists To Autofill
15. Saving Time with Format Painter
16. Changing The Column Width
17. Merge And Centre
18. Entering Data - A Couple Of Shortcuts
19. Sums - The Old Fashioned Way!
20. Sums - Using Autosum
21. Copying Formulas
22. SUMming Horizontally
23. Basic Formulas - Subtraction
24. Basic Formulas - Multiplication
25. Basic Formulas - Division
26. Average Function
27. The Order Of Mathematical Operation
28. POWER USER - Evaluate Formula Function
29. Inserting New Columns And Rows
30. Moving Existing Columns And Rows
31. Cutting, Copying, Inserting And Deleting
32. Hiding Columns And Rows
33. ROUNDing Functions
34. Formatting Numbers
35. A Primer On Building Complex Formulas
36. Building A Complex Formula
37. Sorting
38. Wrapping Text And Soft Enter
39. Adding A New Worksheet
40. Creating A Simple Chart
41. Adding Borders
42. Customizing the Quick Access Toolbar
43. Simple Printing
44. Freezing For An Easier View
45. Getting Help
46. Filters
47. Highlighting Cells
48. Closing - Thank You!
49. Bonus 1 Whizzing Around Excel Revision
50. Bonus 2 Keyboard Shortcuts
51. A1 Style - Relative Relative
52. $A1 Style - Absolute Relative
53. $A$1 Style - Absolute Absolute
54. A$1 Style - Relative Absolute
55. Level 1 SQA 01 Reverse Engineering A Sample Spreadsheet
56. Level 1 SQA 02 Casing And Text Functions
57. Level 1 SQA 03 Charts From A Filtered List