Ultimate Excel Training

Date Till: 23 September 2020

Ultimate Excel Training

Frontline Development Center (FDC), the development Partner of Froxjob is pleased to present with a compatible training program starting from 23rd September 2020  namely ‘Ultimate Excel Training For Professionals (Who wants to excel in excel)’ specially designed to enables the Participants to learn about how to do ETL Process (Extract, Transform and Load).


After the completion of this training, the participants will accomplish the following objectives:
  1. Understand the core principles of Excel.
  2. Use Excel Tables to automate the task
  3. Understand creating Data Models in Excel
  4. Understand Power Tools in Excel
  5. Explore the various techniques of new data analysis in Excel.
  • 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
(We provide Training Videos for each session)

  • 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
Qualified Microsoft Excel Certified Professionals with 6+ experience in working with Excel database Management, data analysis, data presentation, data consolidation, and Reporting.

23rd September 2020  Live PNG Images | Vector and PSD Files | Free Download on Pngtree

Total Duration 10 Hours (1.5 Hours Per Day)

Evening Shift 5:30 -7:00 PM

Venue: Microsoft Team, Live Session
Registration Fees: NPR. 3000 Excluding VAT
Have Queries: Contact Us on 9801898004
Email: training@frontline.com.np