• April 26 - 27, 2019

Microsoft Excel is widely used to prepare various types of analytical interactive reports for the top management who are at the planning stage. The latest buzzword in the world of Excel is Dashboard Reporting. A dashboard report is a management tool that measures and presents critical data on the key business performance areas in a summarized easy-to-read format. To prepare a smart dashboard report, you have to use various form controls, appropriate charts, functions to fetch summary data, various formatting and few tricks.

Training Contents:

  1. Cell Reference (Absolute Vs Relative)
  2. Use Essential Functions For Restructuring Usable Data Table
  3. Lookup & References
  4. Advanced Conditional Formatting
  5. Convert Number In Words Automatically
  6. Reporting Techniques Using Pivottables, Pivotchart And Slicers
  7. Powerpivot – Use The Most Powerful Feature In Excel (Bi Tool)
  8. Data Summarization & Aggregation Techniques From Large Data
  9. Data Sorting & Filtering
  10. Date Functions
  11. Error Handling And Cleaning Reports
  12. Data Validation And File Protection
  13. Creating Chart And Visual Presentation
  14. Macro & Vba: Automate Your Excel Action Or Report And Save Time
  15. Problem Solving Session

Location:

Dhaka

Benefits

  • Opportunity to learn the latest features and tricks of Microsoft Excel
  • 100% PRACTICAL with trainer’s pre-designed working files
  • Opportunity to boost up the Excel skill
  • Training lecture sheet that will be interactively connected with working data
  • Opportunity to learn how to map and handle big data in Excel
  • Opportunity to learn to generate the interactive reports describing the core information within seconds professionally

Eligibilities

Spreadsheet authors, Excel developers, regular Excel users and all kinds of analysts who want to gain skills in designing visual reports can apply to attend the workshop.

Eligible Regions: Bangladesh

Application Process

  • Apply online
  • Registration Fees: BDT 7000/-

Application Deadline: April 21, 2019

Application ClosedOfficial link
Disclaimer: Youth Opportunities spreads opportunities for your convenience and ease based on available information, and thus, does not take any responsibility of unintended alternative or inaccurate information. As this is not the official page, we recommend you to visit the official website of opportunity provider for complete information. For organizations, this opportunity is shared with sole purpose of promoting “Access to Information” for all and should not be associated with any other purposes.

Log in with your credentials

Forgot your details?