Excel Pivot Table and Macros for Reporting and Data crunching training centre in Bangladesh


Excel Pivot Table and Macros for Reporting and Data crunching

  • Date : Friday, March 29, 2019
  • Duration : Day(9.30am-5.30pm)
  • No. of Classes/ Sessions : 1 Day
  • Last Date of Registration : 28 March, 2019
  • Venue : Bdjobs Training, BDBL Building (Level 19), 12 Kawran Bazar C/A, Dhaka 1215.
  • 10% OFF at bKash or Online Payment (Certificate, Handbook and Lunch Included)


Numerous choices for Future Career Growth! There is no option to think of a career which doesn’t drive growth to you. After all, we all choose our career sincerely for our secured future. Therefore, job security is a key factor in everyone’s career. And, again, if you are looking for a secured job then, data analytics is your cup of tea! No one wants to put his/her business at a risk. And, you are the survivor. Ever imagined, how can a business run without its security? As you provide business security, data analytics gives you your job security as a freebie! Excel is the best for data analytics.

Organizations use Microsoft Office Excel to track sales trends, and other business data. Microsoft Excel spreadsheets software come with million rows of data and automate number crunching, but this popular spreadsheet software is capable of doing more than just figures. Pivot Tables and Macros are two major arms in excel that will help you to manage your data and prepare reports very easily, accurately and in a very short time.

Pivot Table - A PivotTable is a powerful tool to calculate, summarize, and analyze data that lets you see comparisons, patterns, and trends in your data. You can make a summary report in one minute using pivot table as the data is easier to segment and ready to instant report.

Macros - If you have tasks in Microsoft Excel that you do repeatedly, you can record a macro to automate those tasks. A macro is an action or a set of actions that you can run as many times as you want. When you create a macro, you are recording your mouse clicks and keystrokes. After you create a macro, you can edit it to make minor changes to the way it works.



Contents of Training:

Ice Breaking Tips and Techniques of Excel

 Data Conversion Tools and Techniques in Excel
 Handling errors while converting number or date values
 Troubleshooting errors using Formula Auditing & Errors finding features in Excel
 Rejuvenate your Basic Excel Skills: Find and Replace, Fill, Split, Transpose, Sort & Filter, Tables, Drop-downs, Analyze, Charts, and many more to ease your excellence in data crunching and reporting

Pivot Table
 Pivot Table features to boost your productivity
 Customize pivot table reports to best fit your objectives
 Create a PivotChart
 Use slicers to filter PivotTable data
 Create a PivotTable timeline to filter dates
 Create a PivotTable with the Data Model to analyze data in multiple tables
 Use the Field List to arrange fields in a PivotTable
 Change the source data for a PivotTable
 Create a dynamic range for Pivot Table Data Source
 Calculate values in a PivotTable
 Delete a PivotTable
 Group a pivot table data for numeric o date ranges
 Bangladesh’s Financial year (July to June) wise pivot report
 Cloning and Uncloing pivot reports

 Create or Record and Modify macros
 Details of Excel Developer Functions and Macros
 Split excel workbook reports dynamically using macros
 E-mail excel workbook reports as attachment to intendent users automatically using macros and mail-merge
 How to create and set up your own Excel Add-ins, for example: amount in words add-in using macro.

Related Courses

Habibur Rahman
  • 22 Mar - 13 Jul 2019

Course Module: Module One: HTML-5 Module Two: ...

Samiul Huq
  • 22 - 23 Mar 2019 (2 Days Long)

The course will take you from an Intermediate Level to a ...

S.M.Morshed Hemal
  • 25 Mar - 8 Apr 2019

Microsoft Excel is one of the most widely used tools for ...

Muhammad Rabiul
  • 26 Mar - 14 Apr 2019

This course focuses on motion graphics and animation from a ...

Starter or Experienced, Marketing, Sales or Service - in any profession in every position, because Microsoft Office is with your everyday jobs in everywhere.
Arrangement for Certificate, lunch and two tea-break would be made by the Organizer during the workshop.

Resource Person

Md. Feroz Kibria

Soft Skills Trainer Specialist, Human Resources

Md. Feroz Kibria has been involved in training, coaching and consulting for more than 10 years with the intention of dramatically increasing profit, productivity and the performance of people.

After completing his MBA & BBA in HR & Accounting, Feroz joined the corporate world and gaining experience in Human Resources Management and training in diversified industries e.g. Telecommunications, Networking Accessories, Customer Services, Engineering and Automobiles.

He also completed a certificate course on “People Management Skills for Professionals (PMSP)” from IBA, University of Dhaka under MDP (Management Development Program).

Through the experience from the local and multinational businesses operating in Bangladesh, Feroz has gained a versatile knowledge for the requirement of core development areas to build the strongest career.

Today, Feroz trains a wide range of Soft Skills like Microsoft Office Programs (Excel, PowerPoint, Access, Publisher, Visio, Word, Outlook and others), Time Management, Strategic Compensation & Benefits, Financial Modeling, Leadership & Team Building, Corporate Etiquettes, etc.

Feroz is passionate in inspiring lives and transforming people. Because of the dedication, he is well known for his energetic and power-packed training sessions.

His quest for continuous Human & Talent Development promises highly energizing and power-packed training style. He helps clients transferring knowledge into ready-to-use skills.