Ultimate Excel Training for Professionals

Ultimate Excel Training for Professionals

Master Excel with Ultimate Training for Professionals

Frontline consults Pvt Ltd is pleased to present an Excel training course Ultimate Excel Training For Professionals (Who wants to excel in excel)’ specially designed to enable participants to learn how to do ETL Processes (Extract, Transform and Load).

COURSE OBJECTIVE

After the completion of this training, the participants will accomplish the following objectives:

  • Understand the core principles of Excel.
  • Use Excel Tables to automate the task
  • Understand creating Data Models in Excel
  • Understand Power Tools in Excel
  • Explore the various techniques of new data analysis in Excel.
CONTENTS FOR ULTIMATE EXCEL TRAINING FOR PROFESSIONALS
  • Introduction to ETL Process in Excel
  • Power Query Introduction
  • Consolidating Files ( Tables, Workbooks, CSV files, etc)
  • Transforming Data Examples ( Unpivoting, Changing Cases, Splitting Data)
  • Types of Joins In Power Query
  • Appending Files
  • Introduction to Power Pivot
  • Relationships In Excel
  • Replacing V lookup with Relationships
  • Creating Dax Functions in Excel
  • Dynamic Reports Using Power Pivot
  • Introduction to Power BI
  • Why Power BI?
  • Various Elements of Power BI
  • Creating our First Power BI Dashboard

TARGET PARTICIPANTS;

  • Sales Officers/Managers
  • Business Development Officers/Managers
  • Human Resource Officers/Managers
  • Business Owners
  • Accountants/Finance Managers
  • MIS Executive/Managers
  • Financial Analysts
  • Researchers and Data Analysts
ABOUT TRAINERS
  • Mr. Shrestha is a Certified Microsoft office specialist with More than 8 years of experience in working with Excel database Management, data analysis, data presentation, data consolidation, and report analysis
  • He has worked in a Multi-National Work Environment (Samsung India Electronics Nepal Liaison Office) in a Sr. Position in MIS & Global Operation where he has successfully managed purchase, sales, and inventory data of more than 200 distributors as well as developed data analysis and reporting format which helped to analyze the distributor’s sales performance against their targets
  • He is equipped with the large skills of analyzing large data sets to forecast and allocate trends and prepare MIS reports, he has been actively involved in providing Advance Excel sessions for more than 20 reputed corporate houses in Nepal since 2011
  • He is currently associated with a Group of companies as a Data analyst and business automation – Manager and Advanced Power BI and Excel trainer for various reputed institutions in Nepal

Have Queries:

Contact Number: 9801898004
Email; training@frontline.com.np