Curriculum
20 Sections
76 Lessons
Lifetime
Expand all sections
Collapse all sections
1 Introduction
4
1.1
1. Introduction
1 Minute
1.2
2. Course Outcome
1 Minute
1.3
3. Study Skills Required
1 Minute
1.4
4. How to get most out of the course
2 Minutes
2 Getting Started With Excel
9
2.1
5. Why Excel
1 Minute
2.2
6. Excel Menu System
1 Minute
2.3
7. Quick Access Toolbar
2 Minutes
2.4
8. Workbook and Worksheet
3 Minutes
2.5
9. Status Bar
2 Minutes
2.6
10. Navigation
1 Minute
2.7
11. Shortcut Menus and Mini Toolbar
1 Minute
2.8
12. New Workbook
1 Minute
2.9
13. Save and Save As
1 Minute
3 Working With Formula
6
3.1
14. Formula Bar
1 Minute
3.2
15. Creating Simple Formula
5 Minutes
3.3
16. Copying a Formula
2 Minutes
3.4
17. Calculating Year To Date Total
1 Minute
3.5
18. Percentage Change
2 Minutes
3.6
19. Working With Functions under Formula
1 Minute
4 Formatting
11
4.1
20. Fonts
1 Minute
4.2
21. Row Height and Column Width
2 Minutes
4.3
22. Font color and toggle button
1 Minute
4.4
23. Alignment and Text Wrapping
2 Minutes
4.5
24. Borders
1 Minute
4.6
25. Numeric and Special Formatting
3 Minutes
4.7
26. Formatting Date and Time
3 Minutes
4.8
27. Conditional Formatting
3 Minutes
4.9
28. Inserting Table
1 Minute
4.10
29. Shapes and Visual Effects
2 Minutes
4.11
30. Smart Art
1 Minute
5 Adjusting Worksheet Layout
4
5.1
31. Inserting Rows and Columns
1 Minute
5.2
32. Shifting Rows and Columns
1 Minute
5.3
33. Hiding and Unhiding Rows and Columns
1 Minute
5.4
34. Copying and Moving Data
1 Minute
6 Printing
3
6.1
35. Print Preview
1 Minute
6.2
36. Page Layout
2 Minutes
6.3
37. Final Print
1 Minute
7 Charts
5
7.1
38. Creating Charts
1 Minute
7.2
39. Changing Chart Types
1 Minute
7.3
40. Formatting Chart
1 Minute
7.4
41. Chart Design
1 Minute
7.5
42. Creating Spark lines
1 Minute
8 Worksheet Views
2
8.1
43. Freezing and Unfreezing Panes
1 Minute
8.2
44. Splitting Rows and Columns Horizontally and Vertically
2 Minutes
9 Multiform Workbook and Worksheets
3
9.1
45. Renaming Worksheet
1 Minute
9.2
46. Inserting and Deleting Worksheet
1 Minute
9.3
47. Moving and Copying Worksheet
1 Minute
10 IF Function
1
10.1
48. IF Function
4 Minutes
11 Vlookup
1
11.1
49. Vlookup
3 Minutes
12 Security and Protection
3
12.1
50. Locking and Protecting Data
1 Minute
12.2
51. Protecting Worksheet Part 1
2 Minutes
12.3
52. Protecting Worksheet Part 2
1 Minute
13 Sharing
1
13.1
53. Sharing Workbooks
1 Minute
14 Data Management
5
14.1
54. Sorting Data
1 Minute
14.2
55. Calculating Sub-Total
2 Minutes
14.3
57. Splitting Data Into Different Columns
1 Minute
14.4
56. Filtering Data
1 Minute
14.5
58. Removing Duplicates
1 Minute
15 Data Analysis
3
15.1
59. Goal Seek
2 Minutes
15.2
60. Scenario Manager
7 Minutes
15.3
61. Data Table
3 Minutes
16 Pivot Tabl
6
16.1
62. Creating A New Pivot Table
5 Minutes
16.2
63. Manipulation of pivot table
2 Minutes
16.3
64. Grouping Data by Date and Time
1 Minute
16.4
65. Filtering Data
1 Minute
16.5
66. Slicer
2 Minutes
16.6
67. Pivot Chart
2 Minutes
17 Macros
1
17.1
68. Using Macros
4 Minutes
18 Conclusion
1
18.1
69. Conclusion
1 Minute
19 Bonus Material
6
19.1
70. Sorting Data
19.2
71. Sub-total
19.3
72. Goal Seek
19.4
73. Scenario manager
19.5
74. Pivot table
19.6
75. Macros
20 Additional Content: Grand Finale
1
20.1
76. Bonus Lectures. Enjoy the Benefits
Microsoft Excel – Excel from Beginner to Advanced
Search
This content is protected, please
login
and enroll in the course to view this content!
Modal title
Main Content