Advance Excel

Duration: 3 Months

MS-Excel

• Introduction to Excel
• Basic Calculations
• Basic Functions
• Text Functions
• Date and Time Functions
• IF Condition
• Lookup Functions
• Mathematical Functions
• PMT Functions
• Conditional Formatting
• Cell & Table Formats
• Insertion and Deletion
• Sorting and Filtering
• Pivot Table and Pivot Chart
• Slicer & Timeline
• Cell Name Management
• Formula Auditing
• Calculations
• Import & Export Data
• Data Tools - Text To Column, Flash Fill, Remove Duplicates, Data Validation & Consolidate
• What If Analysis - Scenario Manager, Goal Seek & Data Table
• Group, Ungroup & Subtotal
• Sheet & File Protection
• Freeze Panes
• Macros

Advance Excel

• Math & Trigonometry functions
• Advance Text Functions
• Advance Date & Time Functions
• Advance Lookup & References Functions
• Advance Statistical Functions
• Financial Functions
• Array Functions
• MIS Reports
• Dashboard Making

Excel VBA

• Basics of Excel VBA
• Macro Recordings and Check Codes
• Basic Syntax and Variables
• If Condition
• Loops
• Procedures & Functions
• Introduction to Excel Objects
• Manipulate Cells & Ranges
• Working with Worksheets and Workbooks
• User Forms & Controls
• Event Handling
• Importing & Exporting Data
• Create Dashboards with VBA
• Working with Pivot Tables and Charts
• Custom Classes & Objects
• Array Handling