Reporting Automation with Microsoft Excel training centre in Bangladesh

Forgot password?
Sign in with
New
Caution

Reporting Automation with Microsoft Excel

Introduction

TRAINING OBJECTIVE
This training program builds upon advanced level knowledge and skills of Microsoft Excel (latest version) sets you on the road to creating dynamic reports, dashboard, macros as well as discover the power of nesting functions. Reduce work load and reporting errors by creating and modifying macros is our main objective.
TRAINING OUTCOME
Upon successfully completion of this training, participants will be able to create dynamic reports and dashboard along with modifying macros.
ASSURANCE
Our training program assure you to implement the knowledge that we transfer to you. We strictly follow KSA process. K ** Knowledge, S ** Skill & A ** Ability

Methodology

Hands on training with practice sessions via zoom

Contents of Training:

Excel data visualization and data tools
Cells referencing or addressing
Custom number formatting
Custom date formatting
Conditional formatting

Microsoft Excel functions
IF, And, Or function
Match, Search function
Sumifs, Countifs, Averageifs function
Lookup, Vlookup function
Indirect, Offset function
Edate, Eomonth, Weeknum function
Forecast, Trend, Growth function
Precedent and dependent

Microsoft Excel PivotTables
Creating and pivoting PivotTables
Summarizing PivotTable data
Managing subtotals and grand totals
Using PivotTable data in a formula
Sorting and Filtering PivotTable Data
Formatting PivotTables
Visualization using Slicer and Timeline
Grouping PivotTable data
Using formulas in PivotTable

Microsoft Excel Charts or Graphs
Excel chart elements
Plotting secondary axis in chart
Excel charts customization
Creating charts using custom template

Microsoft Excel macros & VBA
What is macro?
Trace developer tab
Macro recording
Excel VBA editor
Excel VBA dot notation
Excel VBA methods
Excel VBA range properties
Adding buttons
Assigning macros to a button
Excel VBA active cell properties

Dynamic reports and dashboard
Static and dynamic data
Dynamic reports stand for
Automated report creation for Daily, Weekly, Monthly, Quarterly and Yearly
Exercise of dynamic Dashboard

Mail merge using MS Excel
Mail merge stands for
Mail merge process

Wrapping up the session
Top Tips
Open Forum
Evaluation and follow-up
*** Queries excluding above mentioned list will be entertained based on available time.

Related Courses

Price 4,500 Tk + VAT
Syed Saniat Ahmmad
  • 17 - 31 Aug 2022 (5 Sessions)

Practical examples, exercises & case studies with ...

IT
Online Training Register Wishlist
Price 4,500 Tk + VAT
Md. Feroz Kibria
  • 26 - 27 Aug 2022 (2 Days)

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

IT
Offline Training Register Wishlist
Price 1,500 Tk + VAT
Md. Feroz Kibria
  • 9 - 10 Sep 2022 (2 Sessions)

Having good spreadsheet skills therefore gives you the ...

IT
Online Training Register Wishlist
Price 4,000 Tk + VAT
Syed Saniat Ahmmad
  • 22 Sep - 4 Oct 2022

Practical examples, exercises & case studies with ...

IT
Online Training Register Wishlist

Who can Attend

This training is intended for a person who has experience working with Microsoft Excel and would like to learn more about creating dynamic reports and dashboards which Increase one’s productivity as well as reduce work load and reporting errors by creating and modifying macros.

Related Jobs 93




Bdjobs eLearning, a division of Bdjobs.com Limited, started its operation in 2005. Currently it is the largest professional training house in the country that runs training ........ more

Get Email Alert

We'll email you updates on job trends, new courses, study tips and more.

About Bdjobs eLearning

Courses by Industry

Courses by Functional Area

Courses by Type

social link fb social link fb social link fb