Certificate in Advance Excel

Course Code:Adv.Excel

Duration: 3 Months

Topics Covered :

• Introduction and Fundamentals
• Basics of Excel
• Data Sorting and Filtering
• Custom and Conditional Formatting
• Data Validation
• Working with Range Numbers
• Formulaes and Functions
• Cell Reference
• Tables in Excel
• Charts and Pivot Tables
• Working with Reports
• Worksheet Presentation,Multiple Workbooks
• Macros
• Worksheet Presentation,Multiple Workbooks