Certificate Course in Advance Excel (CAE)
DURATION
2 MONTHS
ELIGIBILITY
10th/12th
AFFILIATED UNDER
RGCSM (Dept. of Secondary & Higher Education, Govt Of India)
SEMESTER – 1
BASIC Microsoft Excel
Creating | Editing | Functions & Formulas |Charts & Graphs | Subtotal | Filtering
Detailing About Formulas & Functions
Common Functions | Nested Functions | References | Logical Functions | Lookup Functions | Text, Stat, Math Functions
DATA Analysis
Sub Total | Auto Filter | Whats-if-Analysis | Goal Seek | Pivot Table Tables | Nested IF | Consolidated of DATA | Data Validation | Sheet Referencing
Macros
Definition & Use | Record a Macro | Assign a Macro | Introduction to VBA Programming
Develop the Worksheet
Use Auto Format | Copy Data and Formulas | Enhance Worksheet Appearance | Print Features & Edit an outline | Enhance charts | Drawing toolbar Features