Trainer: Dhurba Prasad Devkota (CA)
Date: 7 th July 2026 (Tuesday)
Time: 7-9 PM (2 hours)
Venue: Virtual via Zoom
Enroll Now: https://docs.google.com/forms/d/e/1FAIpQLSdsEZYefp46mEjyVMkyjcOV3fKF84FHODJ-2zLoC8LodQt9Cw/viewform
Module 1 (20 Minutes):
- Excel Productivity & Smart Navigation
- Excel interface and workbook organization
- Essential keyboard shortcuts for professionals
- Efficient data entry techniques
- Tables, Freeze Panes, AutoFill & Flash Fill
- Data validation and professional formatting tips
Module 2 (35 Minutes):
- Essential Excel Formulas
- SUM, SUMIF, COUNT, COUNTA, AVERAGE, ROUND
- IF, Nested IF, AND, OR
- IFERROR
- Absolute vs Relative Cell References ($)
- Practical exercise: Preparing a payroll/expense summary
Module 3 (30 Minutes):
- Lookup & Data Analysis Functions
- VLOOKUP
- XLOOKUP
- INDEX + MATCH
- Remove Duplicates
- Conditional Formatting for error detection
- Practical exercise: Linking employee master data with payroll records
Module 4 (25 Minutes):
- Pivot Tables & Reporting Dashboard
- Creating Pivot Tables from accounting data
- Sorting, Filtering, Grouping & Slicers
- Pivot Charts
- Building a simple interactive dashboard
- Practical exercise: Monthly financial reporting
Final Session (10 Minutes):
- Excel Productivity Tips & Q&A
- Top Excel shortcuts every professional should know
- Common Excel mistakes and best practices
- Live Q&A
- Roadmap to Advanced Excel learning
Target Audience: Accountants, Auditors, Finance Professionals, Owners, Bankers, Government
Officers, MBA/MBS Students, and Corporate Professionals.
- By the end of this webinar, participants will be able to:
- Work faster using Excel shortcuts and productivity features.
- Apply essential formulas confidently in day-to-day tasks.
- Use VLOOKUP, XLOOKUP, and INDEX-MATCH for efficient data retrieval.
- Analyze large datasets using Pivot Tables.
- Create professional reports and simple dashboards.
- Improve efficiency and accuracy in accounting, auditing, banking, and financial reporting.
