About Advance Excel Course
Advance Excel course is for all students because in this course Excel has been taught from basic to advanced.
Advance Excel Job Opportunities
- Data Management
- Data Entry
Advance Excel Course Syllabus
- Ch - 1 Introduction to Ms Excel
- Ch - 2 IF Condition And Statement
- Ch - 3 Adv IF Condition And Statement And Home Tab
- Ch - 4 Create Table Program In Excel
- Ch - 5 Conditional Formatting in detail
- Ch - 6 Conditional Formatting in detail Part 2
- Ch - 7 Format option In Home tab
- Ch - 8 Pivot Table And Insert Tab
- Ch - 9 Page layout Tab And How to Setup Excel Sheets for Print
- Ch - 10 Basic to Adv Formula Part - 1
- Ch - 11 Basic to Adv Formula Part - 2
- Ch - 12 Basic to Adv Formula Part - 3
- Ch - 13 Lookup and Vlookup and Hlookup Function
- Ch - 14 Create Invoice Bill Part - 1
- Ch - 14 Create Invoice Bill Part - 2
- Ch - 15 Picture Lookup
- Ch -16 Define Name And Name Manager
- Ch - 17 Create Age Calculator
- Ch - 18 Formula Auditing
- Ch - 19 Data Tab
- Ch - 20 Data Tool And Consolidate And What if Analysis And Data Validation
- Ch - 21 Review Tab
- Ch - 22 Calculation of EMI Using PMT And IPMT And PPMT Functions
- Ch - 23 View Tab