Microsoft Excel Masterclass: Functions, Reporting & Data Visualization

User Avatar
Md. Mehanazuddin Rupom

Please fill following information

Excel_Masterclass_WEB

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
author avatar
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.

Book Your Seat

    Book Your Seat

    Please fill following information

    You May Like

    Leave A Reply

    Your email address will not be published. Required fields are marked *

    1 × 4 =

    Message modal