MS Excel
Basic MS Excel Course Details
Objective:
To introduce new users to Microsoft Excel and provide foundational skills for creating spreadsheets, performing simple calculations, and organizing data.
Duration:
3 Months
Key Topics:
Introduction to Excel
Excel interface: Ribbon, tabs, workbook, worksheet
Understanding rows, columns, cells
Creating, saving, and opening workbooks
Data Entry and Formatting
Entering text, numbers, and dates
Cell formatting (font, color, alignment)
Using number formats (currency, percentage, etc.)
Adjusting column width and row height
Basic Formulas and Functions
Introduction to formulas: =SUM(A1:A5), =AVERAGE(), =MIN(), =MAX()
AutoSum and Quick Analysis tools
Copying formulas (relative vs. absolute references)
Managing Worksheets
Insert, rename, delete, move, copy sheets
Freeze panes, split screen
Page layout and printing basics
Sorting and Filtering Data
Sorting (A-Z, Z-A, custom)
Basic filtering using Filter tool
Charts and Visualization
Creating basic charts (Column, Line, Pie)
Formatting charts and adding labels
Basic Data Validation
Drop-down lists
Restricting cell input (e.g., only numbers)
Advanced MS Excel Course Details
Objective:
To equip users with powerful tools and techniques for data analysis, automation, and advanced reporting using Excel.
Duration: 6 Months ( Including 3 months of Basic MS Excel )
Key Topics:
Advanced Formulas and Functions
Logical:
IF,IFS,IFERRORLookup:
VLOOKUP,HLOOKUP,INDEX,MATCH,XLOOKUPText:
LEFT,RIGHT,MID,TEXT,CONCATENATE,TEXTJOINDate and Time:
TODAY,NOW,DATEDIF,NETWORKDAYSArray formulas and dynamic arrays (
FILTER,SORT,UNIQUE)
Data Tools
Data validation (advanced options)
Consolidate data from multiple sheets
Remove duplicates
Flash Fill
PivotTables and PivotCharts
Creating PivotTables from large datasets
Customizing fields, filters, slicers
Grouping data in PivotTables
Using calculated fields
Conditional Formatting (Advanced)
Rules using formulas
Heat maps, data bars, icon sets
Advanced Charting Techniques
Combination charts (e.g., bar + line)
Dynamic charts with dropdowns
Sparklines
Macros and VBA (Optional for Advanced Users)
Recording Macros
Understanding the VBA editor
Writing basic VBA scripts
Power Query (Get & Transform)
Importing data from different sources
Cleaning and transforming data
Merging and appending queries
Power Pivot and Data Modeling
Creating relationships between tables
Using DAX functions (CALCULATE, RELATED, etc.)
Collaboration & Security
Protecting sheets/workbooks
Sharing workbooks
Tracking changes
