Excel Tools for Business Reporting & Presentation

Instructor

Categories

Please fill following information

Overview
Instructor

Everyone in the business community makes hundreds of templates, formats and reports
Every month or even in a day. We make these for making our business more efficient. This
Is for sure; we invest hell lot of time & energy to make it insightful. What if you get the
Opportunity to get some cool weapons that would retain your energy and save your time so
That you can invest them to some other projects or assignments. You will grab it, right? This
Training is all about orienting you with some of the most powerful Excel tools to increase
Your productivity with Professional Reporting and Presentation.

Module 1:
•Become a Pro user of IF Condition
•Managing Errors in Excel to have a clean sheet in the reports
•Data Validation for Dynamic Report Operation

Module 2:
•Summarize Reports with Functions
•Customize Report Presentation with LARGE / SMALL & MAX / MIN Functions
Module 3:
•Understand the Power of Named Arrays
•Extract Data with INDEX + MATCH & VLOOKUP & MATCH

Module 4:
•Transform the Data with Power Excel
•Automate Business Reports

Module 5:
•Summarizing PivotTable Data & Automate Reporting
•Sorting & Filtering PivotTable Data
•Formatting PivotTables

Module 6:
•Customizing Charts in Excel
•Bar & Column Chart
•Line Charts & Trendlines
•Area Chart
•Pie Chart, 2D Pie Chart and Doughnut Chart
•Waterfall Chart
•Heat Maps
•Combo Charts
•Sparklines
•Gauge Chart
•Custom Number Formatting
•Conditional Formatting
•Creating Non-Chart Viz Palette
Mini-Dashboard Project from Module 4 to 6

Pre-requisite:
1. Professionals of All Levels and from All Functions
2. Basic Knowledge of MS Excel
3. MS Excel 2016 or higher is recommended.

Course Information

Reg. Ends 12 November, 2020
Start Date 13 November, 2020
End Date 14 November, 2020
Class Schedule 7:00PM to 9:30PM
Total Hours 5
Venue Title Online Live Training
Venue Address www.sudoksho.com/class-room

Md. Mehanazuddin Rupom

Microsoft Certified Excel Trainer

Md. Mehanazuddin Rupom is a seasoned HR Professional who possesses expertise of handling both local and international HR Projects in his 10+ years of professional journey. He is also Microsoft Certified Trainer, Microsoft Office Specialist – Excel Expert and Certified Microsoft Innovative Educator.

He currently leads the HR & Administration functions of Bangladesh unit for one of the top multinational international sewing thread dyeing & finishing company named AMANN Group headquartered in Germany. He joined AMANN in August 2015 and then on contributed significantly to develop a sustainable business for AMANN in Bangladesh with the management of HR & Admin activities. For his outstanding contribution for setting up the HR & Admin functions in Bangladesh, company has awarded him with the responsibilities of New HR Projects in Asia and also made the Employee Engagement Survey Project Lead – Asia back in 2018. Prior to AMANN, Rupom worked in a HRBP Role for Manufacturing Team of Lafarge Surma Cement Limited that was a French Multinational Cement Manufacturing Company. He was also key member of Lafarge’s Asian Technical Development Team. Before Lafarge, he was with one of the biggest LLC’s in Bangladesh named Beximco Pharma. He started his HR career for this company back in 2011. However, he stepped into the professional world with British American Tobacco back in 2010 when he was recruited in there Trade Marketing & Distribution – TM&D team.

Apart from his professional commitment, he also conducts training on Microsoft Excel & PowerPoint in both online & offline form 2012. He has also established himself as a key profile internationally in the field of Microsoft Excel. He also conducted several trainings on HR & Management Skills topics in the organizations where he had worked. His key interest areas in this trades are Team Building, Communication Skills, Business Etiquettes, Talent Management, Performance Management, Training & Development and Organization Development.

During the Corona Pandemic that has started to expand from April 2020 in Bangladesh till now, he has conducted 50+ webinars in Excel with over 2,500 students from around the world.