-
-
01. Introduction of the Course
-
02. Familiarize with Excel Interface
-
03. Familiarize with Excel Interface Continued
-
04. Application of Navigation and Selection Tools
-
05. Exploring Data Entry and Data Editing
-
06. Uses of Fill Handle
-
07. Managing Rows, Columns, and Cells Insert and Delete
-
08. Managing Rows, Columns, and Cells Hide and Resize
-
09. Uses of Font Formatting
-
10. Format Painter
-
11. Application of Alignment Tools
-
12. Number Formatting
-
13. Conditional Formatting
-
14. Finding and Replacing Data
-
15. Sorting
-
16. Filtering
-
17. Application of Freeze Pane
-
18. Formulas
-
19. Functions SUM and AUTO SUM
-
20. Functions SUBTOTAL, AVG, MIN, and MAX
-
21. Absolute Cell References
-
22. Calculations Across Sheets
-
23. Different Paste Options in Excel
-
24. Basic Chart Types
-
25. Editing Charts
-
26. Print Preview, Orientation, margins, and Scale
-
27. Page Breaks
-
28. Keyboard shortcuts, adding comments and saving to PDF
-
29. Conclusion
-
Assessment and Certificate
-