

SMARTECH EDUCATION COMPUTER INSTITUTE
An ISO Certified Institute | NIELIT Accredited Institute | Regd. Under Govt. of Punjab
Basic to Advance Excel
(Online Course Syllabus)

-
Tables (Merge & Wrap Text Use of Alignment)
-
Mathematical Formulas Practice Sheets (Addition, Subtraction, Multiply, Divide, Percentage)
-
All Home Tab Commands
-
Count, Counta, Count Blank & Countif formulas Practice Sheet
-
Chart Practice (Pie, Bar, Lin, etc.)
-
Text Functions
-
Date formatting & other Date functions in excel
-
Sum, Sumif, Sumifs, Sumproduct, Average, Averageif, Averageifs
-
Pivot Table & Pivot Charts
-
Absolute Cell Reference Practice Sheet
-
V lookup & H lookup Function
-
Search Box Practice Sheet
-
Use of Paste Special & Transpose Function
-
What if Analysis (Goal Seek, Data Table & Scenario Manager)
-
Data Validation
-
Data Consolidation
-
Hyperlink Function in Excel
-
Compare Two Sheets & Organize Sheets
-
Combine Test & Assignment (Related to all Syllabus)