Introduction to MS Excel & Interface
Workbook, Worksheet, Rows, Columns, Cells
Data Entry, Editing & Formatting
Basic Formulas (SUM, AVERAGE, MIN, MAX)
AutoFill & Flash Fill
Sorting & Filtering
Basic Charts (Bar, Line, Pie)
Conditional Formatting
Data Validation (Drop-down Lists)
Logical Functions (IF, AND, OR, Nested IF)
Lookup Functions (VLOOKUP, HLOOKUP, XLOOKUP)
Text Functions (LEFT, RIGHT, MID, CONCATENATE, LEN, TRIM)
Date & Time Functions
Pivot Table & Pivot Chart
Import & Export Data
Advanced Formulas (INDEX, MATCH, OFFSET, INDIRECT)
What-If Analysis (Goal Seek, Scenario Manager, Data Tables)
Power Query Basics
Power Pivot & Data Models
Creating Interactive Dashboards
Protecting & Securing Data
Printing & Page Setup
Introduction to Macros
Recording & Running Macros
Introduction to VBA (Visual Basic for Applications)
Writing Simple VBA Programs
Automating Reports
10TH PASS
Course Code : EXCEL
Course Code : S-ADCAA
Course Code : S-TALLY
Course Code : S-CHT
Course Code : S-CET
Course Code : M-PGDCA
Course Code : M-ADCA
Course Code : M-ADCHN
Course Code : M-DCTT
Course Code : M-DCA
Course Code : M-ADCPD
Course Code : M-ADIT
Course Code : M-ADA
Course Code : M-ADH
Course Code : M-ADN
Course Code : M-DCP
Course Code : M-CCP
Course Code : M-CCCP
Course Code : M-CCFA
Course Code : M-CCMO
Course Code : M-CCDP
Course Code : M-CCCC
Course Code : M-ADCM
Course Code : M-DCMRM
Course Code : M-DWT
Course Code : M-CCAC
Course Code : M-CCN
Course Code : M-CCSMN
Course Code : M-CCAP
Course Code : M-CAP
Course Code : M-CCWPDI
Course Code : M-CDEO
Course Code : M-CCA
Course Code : M-DNT
Course Code : M-DFA
Course Code : M-ADPA
Course Code : M-DOA
Course Code : M-ADGD
Course Code : M-DMA
Course Code : M-DWPDWD
Course Code : M-DIT
Course Code : M-DBAT
Course Code : M-DCADP
Course Code : M-DDPT
Course Code : M-MDCA
Course Code : M-MDCA
