Online Course Lectures : 

1.      Introduction to Excel

2.     How to open Excel?

3.     MS Excel interface

4.    Customize the quick access bar

5.     More on interface of Excel

6.     Workbook in Excel

7.     How to save the document in Excel?

8.     How to open the document in Excel?

9.     Build a spreadsheet

10.  Numeric data in Excel

11.    Cell References

12.   Basic Formulas

13.   Relative and Absolute Cell References

14.  What are functions in Excel?

15.   Sum () function

16.   Min () and () Max Function

17.   Average Function

18.   Count Function

19.   Auto Sum Command

20. Shortcut to Auto Sum Command

21.   How to copy the formulas by using autofill?

22.  How to move and copy data?

23.  Adding and deleting rows and columns

24. How to change the width and height of the column?

25.  How to hide rows and columns?

26.  How to rename the worksheet?

27.  How to delete the worksheet?

28.   Reordering and copying an Excel Worksheet

29.  Font formatting commands

30. Background color of a cell

31.   How to add borders to cells?

32.  How to add currency values to the data?

33.  How to format percentage values?

34. Format painter in Excel

35.  How to create styles to format data?

36.  Merge and Center Option

37.  Conditional Formatting

38.  How to insert the images?

39.  Shapes in Excel

40. How to format shapes?

41.  SmartArt in Excel

42. Column Chart in Excel

43. Chart ribbon in Excel

44. Modification of data

45. How to format chart?

46. How to move chart from one worksheet to another?

47. Pie Chart

48. How to view your document in Print Preview?

49. Orientations, margins, and Scaling

50. Page layout view

51.   Header and Footer

52.  How to print specific range of cells?

53.  Templates in Excel

54. How to custom a template?

55.  List Structure in Excel

56.  Single level sort

57.  Multi- level sort

58.  Custom sort

59.  Use of auto filter tool

60. How to create subtotal in list?

61.   How to format a list as a table?

62.  Conditional formatting to find duplicates

63.  How to remove duplicates?

64. Introduction to DSUM Function

65.  OR criteria in DSUM

66. AND criteria in DSUM

67.  D Average () Function

68. D Count Function

69. Introduction to data validation

70. Data validation criteria

71.   Adding data from a list in data validation

72.  How to add custom data validation error?

73.  Introduction to Pivot Table

74. How to create Pivot Table?

75.  How to modify the calculations of Pivot Table?

76.  How to group data in Pivot Table?

77.  Data formatting in Pivot Table

78. Pivot Chart

79.  More about Pivot Table

80. Filtering data in Pivot Tables

81.   Use of slicer tool

82.  Power Pivot

83.  How to active Power Pivot?

84. Working with Power Pivot

85.  How to create Pivot Table using Data Model?

86. Calculations inside the data model

87. Key performance indicator in data model

88. Freeze Panes Tool

89. How to print large set of data?

90. How to group data?

91.   How to link worksheets?

92.  Name ranges in Excel

93.  Benefits of using name range

94. If function ()

95.  Use of name range in if () function

96. Nesting functions

97.  Using AND () Function within the if () function

98. Countif () function

99. SUM if () function

100. Not and If error function

101.  VLOOKUP Function

102. HLOOKUP Function

103. Index Function

104. Index and Match Function Together

105. Left () Right () and Mid () function

106. LEN () Function

107. Search () Function

108. Concatenate Function

109. Use of Watch Window

110.  Match Function ()

111.  Use of trace precedents

112. Use of trace dependents

113. Show formula

114.  How to protect the structure of a worksheet?

115. How to add password to protect the worksheet, workbook password?

116. Solver Tool

117. Goal Seek Function

118. Scenario Manager in Excel

119. Introduction to Marcos

120. How to create Marcos?

121. How to create button for Marcos?

122.  How to Edit Marcos?

AI Integration in LIVE Sessions