Course Duration in Hours
20
20
Learn MIS Reporting
Pivot Tables & Reports
Goal Seek, Scenarios, Solver Functions & Data Tables
Sorting ,Filtering & data Sub totaling
Grouping & Outlining Data
Data Validation, Consolidation & Formatting , Conditional Formatting
Advanced Functions in Excel - Lookup, Finance, Statistical & Mathematical Functions
Getting Started to Microsoft Office Excel User Interface
Application
Printing & managing Workbook
Worksheets & its components
Named Ranges
Modifying & Formatting
Cell Color, Font Color, Indents, Alignments, Text Orientation
Search for and Replace Data
Use Proofing and Research Tools
Apply Number Formats
Custom Formats
Editing commands
Data Sorting
Built-in Sort
Sorting Levels
Custom Sort
Data Filtering
Auto Filter – Filter By Color, Filter by Icon Sets
Advanced Filter
Remove Duplicates
Outline & Subtotal Data - Built-In Subtotal (Nested Subtotal)
What-If Analysis
Using Goal Seek
Scenario Manager
Data Tables
Solver (Add-In)
Macros
Recording
Quick Automation techniques
V lookup, H Lookup, Pivot table, Charts, overall formulas in excel.
MIS.
Macros recoding
Generate data reports
Compare excel files
Data sorting
Conditional formatting
Students
Professionals
Administration
Team Management
Navza EduTech, Rajarajeshwari Nagar (Bangalore),Bangalore,IN