Reporting Automation with Microsoft Excel training centre in Bangladesh

New

Reporting Automation with Microsoft Excel

  • Date : 22 September - 06 October 2021
  • Duration : Evening(7:00 PM-10:00 PM)
  • No. of Classes/ Sessions : 2 Sessions
  • Class Schedule : Monday & Wednesday
  • Total Hours : 15
  • Last Date of Registration : 21 September, 2021 ( within 5pm )
  • Venue : Online Virtual
  • (10% Off on Bkash or Online payment)

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

Rony Saha
  • 23 Sep - 5 Oct 2021

This Power BI course is best suited for Business ...

IT
Md. Feroz Kibria
  • 24 - 25 Sep 2021 (2 Sessions)

Having good spreadsheet skills therefore gives you the ...

IT
Price 4,500 Tk + VAT
Enamul Haque Sujon
  • 6 - 25 Oct 2021 (6 Sessions)

After completing this course on can work as Independent ...

IT
Md. Feroz Kibria
  • 15 - 16 Oct 2021 (2 Sessions)

Having good spreadsheet skills therefore gives you the ...

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

Resource Person

Mostofa Monower, MCP, MCSAM

Deputy Manager, Reporting & BI Beximco Communications Ltd

Mr. Mostofa Monower has over 13 years of working experience in Network Infrastructure, Workforce Management, and MIS reporting, BI & presentation. He has started his career with Gemcon Group in early 2007 and also has working experience with TK Group as System Administrator. In the 9 years of telco industry like Airtel and Robi, his footprint has been remarkable for analysis and decision making. Recognition from both telco organizations for developing varies decision-making tools and dynamic dashboards enhance his career as a Data Scientist in the fields of Big data & Artificial Intelligence (AI). Currently, he is working as Deputy Manager, Reporting & BI, Beximco Communications Limited.
He is proficient in creating dynamic MIS & BI Reports, templates, dashboards and maintaining the database. He has excellent knowledge in Microsoft Office, especially in Microsoft Excel, Microsoft Access, Microsoft PowerPoint, Microsoft Outlook, Microsoft Word & Microsoft Power BI. He has been providing training on the Microsoft Office package since 2011. Currently, doing public training on behalf of BD Jobs & Demist Training Institute. He has provided training & consultancy to develop reporting systems to many renowned organizations of Bangladesh.
Mr. Mostofa Monower is a Microsoft Certified Professional (MCP) and Microsoft Certified System Administrator with Messaging (MCSAM). He has completed Cisco Certified Network Associate (CCNA) from American International University (AIUB). Other courses that he has completed and specialized are Red Hat Certified Engineer (RHCE), ComTIA A+, ComTIA Network+, and International Computer Driving License (ICDL).
Mr. Mostofa Monower has designed, developed and conducted the number of corporate training programs in Microsoft Office (especially in Microsoft Excel) and has trained more than three thousand corporate professionals from renowned corporate houses in Bangladesh. He is dedicated to developing and improving professional skills and unlock resource potential in order to increase efficiency and productivity. As a consultant, he developed various international standard dynamic reports, template & dashboard (like Payroll management, Sales monitoring dashboard, Dynamic attrition report, Financial modules for business, Dynamic analysis tools for marketing, Assets management tools, Inventory management, Customer management, etc.

Hands on training with practice sessions via ZOOM.



social link fb social link fb social link fb