Microsoft Excel Masterclass: Functions, Reporting & Data Visualization

Instructor

Categories

Please fill following information

Overview
Instructor

Excel has been the most effective Data Analysis & Reporting tool for years. However, with its recent developments and extensive use of these features, it is now regarded as an effective and amazing Presentation tool as well. Excel provides flexibility to manipulate and orient data with utmost ease and with minimal effort. After the introduction of Power Query that is a BI tool in Excel, there has been a tremendous change in the use of excel. This workshop will drill down to most effective functions & tools of excel that would enhance the effectiveness and efficiency to handle Small to Big Data.

Outline:

Module One: Advance Excel Functions

3D Excel Functions
Advance Versions of IF Statement
Prepare Excellent Summary Report with COUNTIFS / SUMIFS/ AVERAGEIFS
Present Top / Bottom with LARGE & SMALL Functions
VLOOKUP
INDEX + MATCH Function Combining MATCH with VLOOKUP XLOOKUP
UNIQUE FILTER SORT

Module 2: Create Awesome Report

Creating & Pivoting PivotTables
Summarizing PivotTable Data
Sorting & Filtering PivotTable Data
Formatting PivotTables
Applying Conditional Formats to PivotTables
Creating & Manipulating PivotCharts

Module 3: Data Visualization

Key Data Viz Principle & the 10 Second Rule
The Good, Bad & the Ugly
Customizing Charts in Excel Bar & Column Chart
Line Charts Pie, Donut Waterfall Chart Heat Maps Combo Charts Sparklines
Advance Data Viz with Custom Number Formatting
Custom Data Viz with Conditional Formatting

Key Learnings

Develop detail understanding of the Excel Functions to analyze data
Learn the Key Data Viz & Reporting Techniques
Be fast and effective in Report preparation with MS Excel
Build Animation in Slicers to Animate Dashboard

Target Audience:

Corporate Professionals
Students
Business Persons

Training Deliverables:

Exercise Files for practice
Full Video recording of the training
Certificate of Participation

Pre-requisites to Participate:

Should have Basic knowledge about Excel.
Use Microsoft Office 2016 or higher. Office 365 is best suited.

Course Information

Reg. Ends 01 April, 2021
Start Date 02 April, 2021
End Date 10 April, 2021
Class Schedule 6:30PM to 9:30PM
Total Hours 12
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.