Advanced Excel Training

1.1 Workbook & Worksheet Management

Creating, saving, and opening workbooks
Adding, renaming, and deleting worksheets
Moving and copying worksheets
Formatting tab colors for organization
Hide & unhide worksheets

1.2 Cells, Rows & Columns

Insert & delete rows and columns
Adjusting row height and column width
Auto-fit cells for content
Counting rows and columns

1.3 Data Entry & Tables

Typing and editing cell content
Table creation and formatting
Cell references: Absolute, Relative, Mixed

2.1 Font & Paragraph Formatting

Font type, style, size, and color
Text alignment and orientation
Merge cells and wrap text
Format Painter for quick formatting

2.2 Number Formatting

Currency formats (USD, INR)
Percentage and decimal formatting
Date and time formats
Custom number formats

2.3 Productivity Tools

Quick Access Toolbar customization
Clipboard and paste special
Find & Replace operations
Data sorting and filtering

3.1 Basic Functions

SUM, AVERAGE, COUNT, COUNTA
MIN, MAX, LARGE, SMALL
IF, AND, OR, NOT functions
Nested IF statements

3.2 Lookup Functions

VLOOKUP and HLOOKUP
INDEX and MATCH combination
XLOOKUP (modern lookup)
Handling errors with IFERROR

3.3 Text Functions

CONCATENATE, TEXTJOIN, CONCAT
LEFT, RIGHT, MID, LEN
UPPER, LOWER, PROPER, TRIM
Text to Columns feature

3.4 Date & Time Functions

TODAY, NOW, DATE, TIME
YEAR, MONTH, DAY functions
DATEDIF, NETWORKDAYS, WORKDAY
EDATE, EOMONTH functions

4.1 Data Validation

Drop-down lists and input validation
Whole number and decimal limits
Date and text length restrictions
Custom validation formulas
Input messages and error alerts

4.2 Conditional Formatting

Highlight cell rules
Top/Bottom rules
Data bars, color scales, icon sets
Formula-based conditional formatting

5.1 Pivot Tables

Creating and designing pivot tables
Rows, columns, values, and filters
Grouping dates and numbers
Calculated fields and items
Slicers and timelines

5.2 Charts & Visualizations

Column, Bar, Line, and Pie charts
Combo charts and dual axis
Pivot charts
Sparklines for inline charts
Chart formatting and customization

6.1 Dashboard Design

Dashboard planning and layout
Dynamic charts with named ranges
Form controls (buttons, dropdowns)
Connecting multiple data sources

6.2 Macros & VBA Basics

Recording and running macros
Macro security settings
Introduction to VBA editor
Simple automation scripts

6.3 Real-World Projects

Sales dashboard creation
HR analytics report
Financial modeling basics
Interview preparation exercises

Advanced Formulas

Master complex formulas including VLOOKUP, XLOOKUP, and INDEX-MATCH

Pivot Tables

Summarize and analyze large datasets with pivot tables

Data Visualization

Create stunning charts and visualizations for reports

Dashboards

Build interactive dashboards for business insights

Automation

Automate repetitive tasks with Macros and VBA

Job Ready

Practice with real interview questions and assignments

Course Syllabus

Excel Basics & Navigation