Invitation to register for Certificate Course on “Microsoft Excel: Basic to Advanced”

Dear Students,                                                                              

We are pleased to inform you that the Training Department of the Institute is planning to hold a Certificate Course on “Microsoft Excel: Basic to Advanced” for the students of ICMAB.  Become an Excel Expert and Supercharge your career! This course will take you from mastering the basics to confidently handling advanced data analysis and automation. The comprehensive details of the course are provided below:

 

Duration                                  :   4 weeks (8 sessions)
Session Time                          :   6:30 PM – 8:30 PM (Mondays and Wednesdays each week)
Session Start Date                :   November 13, 2024
Delivery Mode                        :   Online / In-Person
Fee per Person                       :   Tk. 2000.00 (In-Person), Tk. 1000.00 (Online)
Registration Closing Date  :   November 11, 2024, at 2:00 PM

 

Course Breakdown:

  • Navigating and Understanding the Excel Interface
    Gain familiarity with Excel’s layout, menus, and key tools.
  • Efficient Worksheet Management in Workbooks
    Learn how to manage, organize, and customize multiple worksheets.
  • Data Input, Modification, and Formatting Strategies
    Master data entry techniques and efficient formatting for better presentation.
  • Frequently Used Built-in Functions
    Explore essential Excel functions that simplify calculations and analysis.
  • Saving, Page Setup, Printing, and Security Features
    Optimize files for sharing, printing, and protection with practical tips.
  • Organizing Data with Sorting and Filtering Tools
    Quickly sort and filter large datasets for meaningful insights.
  • Using Cell References for Dynamic Formulas
    Understand the power of relative, absolute, and mixed references in formulas.
  • Visualizing Data with Charts
    Create impactful charts to convey information clearly and effectively.
  • Dynamic Reporting with Pivot Tables and Pivot Charts
    Develop powerful reports with interactive Pivot Tables and Charts.
  • Advanced Formula Techniques and Data Validation
    Implement complex formulas and ensure data accuracy with validation rules.
  • Retrieving Data with VLOOKUP, HLOOKUP, and XLOOKUP
    Harness the power of lookup functions for quick and efficient data retrieval.
  • Automating Tasks with Macros and VBA
    Save time by automating repetitive tasks using Macros and VBA.

As an interested candidate for this training course, please first pay the fees applicable to you through bKash Merchant Account # 01847360633 (Payment). Then, fill out the form with the required information using the link at https://forms.gle/noiABDSETm1h3asD9

 

Please note that, due to limited seating for the in-person delivery mode, we will follow the ‘first come, first served’ rule. For more information about the training course, please contact us at 01847360661.

 

On behalf of the Institute, we have the pleasure of inviting you to register for the said training course.