Advanced Excel Online Intermediate Level by Navza EduTech

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