HDI

Enquire Now

Course Includes

Duration2 Months
Enrolled5
Lectures60
Videos0
Notes0
CertificateYes

What you'll learn

Advanced Formulas & Functions – Complex calculations using multiple functions.
Logical Functions – Decision-making formulas like IF, AND, OR.
Lookup Functions – Search and retrieve data using VLOOKUP, XLOOKUP, INDEX-MATCH.
Text Functions – Combine, split, clean, and format text data.
Date & Time Functions – Calculate dates, days, months, and time.
Financial Functions – EMI, interest, depreciation, and investment calculations.
Statistical Functions – Average, rank, percentage, standard deviation, etc.
Dynamic Array Functions – Use FILTER, SORT, UNIQUE, SEQUENCE functions.
Named Ranges – Assign names to cell ranges for easy formulas.
Data Validation – Create dropdown lists and restrict data entry.
Conditional Formatting – Highlight data based on conditions.
Advanced Sorting & Filtering – Organize and filter large datasets.
Flash Fill – Automatically detect and complete patterns in data.
Remove Duplicates – Delete repeated entries from datasets.
Pivot Tables – Summarize and analyze large data quickly.
Pivot Charts – Create charts from Pivot Table data.
Slicers & Timelines – Interactive filters for Pivot Tables.
Charts & Graphs – Visual representation of data analysis.
Sparklines – Mini charts inside cells.
What-If Analysis – Predict results by changing values.
Goal Seek – Find required input for a desired result.
Scenario Manager – Compare multiple business scenarios.
Solver – Optimize calculations with constraints.
Consolidate Data – Combine data from multiple worksheets.
Subtotals – Generate grouped totals automatically.
Excel Tables – Manage structured and dynamic data ranges.
Power Query – Import, clean, and transform data.
Power Pivot – Handle large datasets and relationships.
Dashboard Creation – Build interactive reports and dashboards.
Data Analysis ToolPak – Advanced statistical and analytical tools.
Macros Recording – Automate repetitive tasks.
VBA Basics – Programming in Excel using Visual Basic.
User Forms in VBA – Create input forms for automation.
Worksheet Protection – Secure sheets, cells, and workbooks.
Collaboration & Sharing – Share and edit files with others.
Import & Export Data – Connect Excel with external files/databases.
XML & CSV Handling – Work with structured data formats.
Keyboard Shortcuts – Improve speed and productivity.
Excel Templates – Use ready-made workbook designs.
Printing & Page Setup – Format worksheets for professional printing.