Free Registration: https://crm.lcbsdhaka.com/view.php?id=198410
Facilitator: Mr. Enayet Ullah, ACCA
Number of Sessions: 8
Session Duration: 2 hours
Total Duration: 16 hours
Course Length: 2 Months
Course Fee: 6,000 BDT
Course Contents:
Session 1: Competency Test and Review of Existing Excel Skills
- Functions: SUMIF, SUMIFS, AVERAGEIF, AVERAGEIFS, COUNTIF, COUNTIFS, VLOOKUP.
Session 2: Working with Multiple Worksheets & Workbooks
- Managing Multiple Worksheets and Workbooks
- Linking Data Across Workbooks
- Consolidating Data from Multiple Worksheets
- Named Ranges
- Definition and Creation
- Managing Named Ranges
- Practical Applications in Formulas
- Simplifying Complex Formulas with Named Ranges
Session 3: Working with Tables & Pivot Tables
- Tables
- Creating and Formatting Tables
- Sorting and Filtering in Tables
- Automation with Tables
- Converting Tables to Range
- Subtotaling in Tables
- Pivot Tables
- Creating and Modifying Pivot Tables
- Value Field Settings
- Sorting and Filtering Pivot Tables
- Using Report Filter Pages
- Pivoting Charts and Slicers
Session 4: Advanced Lookup, Index, and Match Functions
- VLOOKUP and Advanced Alternatives
- Using VLOOKUP for Nested Lookups
- VLOOKUP with Multiple Criteria
- INDEX and MATCH
- Basics of INDEX and MATCH
- Advanced Lookups with INDEX-MATCH
- Practical Exercises for Mastery
- IF Functions and Nested IF
- Combining IF with OR and AND
- Handling Lists of Criteria
- Real-World Applications of IF Functions
Session 5: Data Visualization, Protection, and Advanced Data Tools
- Data Visualization
- Creating and Customizing Charts
- Designing Combo Charts
- Adding and Editing Sparklines
- Dashboards
- Understanding Dashboard Concepts
- Creating Interactive Dashboards with Charts and Pivot Tables
- Using Slicers and Timelines for Dynamic Filtering
- Incorporating Conditional Formatting for Enhanced Visualization
- Best Practices for Effective Dashboard Design
- Protecting Data
- Protecting Sheets and Workbooks
- Managing Edit Ranges
- File Protection Techniques
- Advanced Data Tools
- Filters (Text, Number, Date, Wildcard, and Advanced)
- Custom List Sorting
- Exploring Views: Custom Views, Page Layout, and Page Break Preview
- Side-by-Side Comparisons for Data Analysis
Session 6: Revision and Final Assessment
- Comprehensive review of all topics
- Practical application through exercises
- Final assessment to evaluate skill mastery
Certification
- Every trainee will receive a “Certificate of Participation.”
- A “Certificate of Completion” will be awarded to those who successfully pass the final assessment(s).
Trainer’s Profile:
Mr. Enayet Ullah, ACCA
An ACCA member with a degree from Oxford Brookes University and over 9 years of teaching experience. Currently a Financial Analyst at Bashundhara Group, Mr. Enayet’s deep knowledge and dedication make him a trusted mentor to ACCA students.