Certificate Course In Advance Excel
(Course Duration: 30Hrs)
Program Contents
Introduction to Excel
Basic Functions
Tabs and Ribbons
Home Tab
Number Formatting
Data Sorting/Validation
Advance Conditional Formatting
Paste Special
Insert Tab
Page Layout Tab
Data Tab
Data Filtrations
Whatif Analysis
Goal Seek/Scenario Management
Sub Total/Consolidation
Working with Charts
Pivot Table
Logical Functions
Pivot Charts with Report
Date and Time Functions
Text Functions
Mathematical Functions
Statistical Functions
Financial Functions
Conditional Functions
Lookup Functions
Database Functions
Array Functions
Advance Printing Features
Debugging Formulas
Working with Macros
MIS Reporting
Setting up Formulas Practically
Advance Level Shortcut Keys
Page and Margin Setup
Protection and Security
