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


Excel Pivot Table and Macros for Reporting and Data crunching


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

Syed Saniat Ahmmad
  • 20 Jul - 1 Aug 2022

Practical examples, exercises & case studies with ...

Md. Feroz Kibria
  • 22 - 23 Jul 2022 (2 Sessions)

Having good spreadsheet skills gives you the ability to ...

Sonny DCosta
  • 28 Jul - 9 Aug 2022

This is a hands-on course for anyone who wishes to ...

Md. Feroz Kibria
  • 5 - 6 Aug 2022 (2 Days)

Day to day HR and Admin data analysis, reporting, tools and ...

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.

social link fb social link fb social link fb