ADVANCE EXCEL
Duration : (10-12 CLASSES X 2 Hrs) (1Month X 2HrsXAlternate Days)
- Basics of Excel (Data Entry etc)
- Workbook, Worksheet, Workspaces
- Row & Column Settings
- Calculation Basics in Excel
- References (Relative, Absolute, Mixed)
- Find & Replacing Data
- Header & Footer setting
- Working with Chart
- Functions (Financial, Statistical etc.)
- Formulas
- If AndAnalysis, What if Analysis
- Goal Seek, Scenarios
- Naming Cell Range
- Protecting sheet & workbook
- Autofill, Autocorrect, Autoformat
DATA ANALYSIS IN EXCEL (ADVANCE EXCEL)
- Importing and Exporting Data
- Auditing, Freeze Panes
- Grouping and Subtotal
- Macro (recording tool)/EDITING
- Customizing Sheet/Cells /Rows/Columns
- Customizing Excel Window
- Sorting and Filtering Data
- Data Validation
- Pivot Table, Pivot Chart
- Consolidation of Sheets
- H Lookup, V Lookup
- Creating Reports, Marks sheet etc
- Printing Worksheet, Custom List
- Working with Excel CSV files
- Making Excel to PDF file
|
PROJECT WORK |