Advanced MS Office Excel Essentials

Advanced MS Office Excel Essentials

Free Registration: https://crm.lcbsdhaka.com/view.php?id=198410

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
• 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).