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

New
EMI EASY PAY

Excel Pivot Table and Macros for Reporting and Data crunching

Introduction

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.

Methodology

Hands On Training

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


Macros
 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

Price 6,000 Tk + VAT
Noman Siddikee
  • 23 Oct - 1 Nov 2018

SPSS Statistics is a GUI and syntax based statistical ...

IT
Mostofa Monower
  • 26 Oct - 10 Nov 2018

This training program builds upon advanced level knowledge ...

IT
Ashim Kumar Sikder
  • 27 Oct - 30 Nov 2018

Trainee will be capable to develop and deploy database ...

IT
Mostofa Monower
  • 30 Oct - 2 Dec 2018

Upon successfully completion of this training, participants ...

IT
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.