MS Excel Power Query Beginner to Intermediate

User Avatar
Md. Mehanazuddin Rupom

Please fill following information

MS Excel Power Query Beginner to Intermediate

The business world is transforming rapidly and to cope up with the rapid transformation, we need to be superfast. The more you grow your business, the more information you have. Processing these huge amount information and transforming those to meaningful insights requires Powerful Analysis tool. Microsoft Excel has a built-in Business Intelligence Tool that is dynamic, powerful and automated. Learning power Query will not only save your time but enhance the pace of your business growth by providing intelligent insights transformed from business data. If you want to automate your business reporting, this is the right training for you.

Outline:

  1. Introduction to Power Query
  2. Essentials of Power Query
  3. How to connect multiple files / worksheets and Analyze large data with Power Query.
  4. Modifying Query, Handling Errors & Null Values in Power Query
  5. Transform your Database in Power Query
  6. Work with Conditional Column, Dynamic Data Grouping and Unpivot Data
  7. Data & Time Transformations
  8. Create Fully Automated Dashboard / Business Intelligence Report

Course Information

  • Reg. Ends 03 September, 2020
  • Start Date 04 September, 2020
  • End Date 05 September, 2020
  • Class Schedule 7:00 PM – 9:30 PM
  • Total Hours 5 Hours
  • 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

      Message modal