Ultimate Excel Training For Professionals

Date Till: 15 March 2020

Ultimate Excel Training For Professionals

  COURSE OBJECTIVE

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

CONTENTS
  • 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 look up 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 sessions)


TARGET PARTICIPANTS
  • Sales Agents
  • Business Development Officers
  • Human Resource Department (HR)
  • Sales Representatives
  • Accountants
  • MIS
  • Financial Analysts
  • Researchers and Data Analysts

ABOUT TRAINERS
 
Qualified Microsoft Professionals with 6+ experience in working with Excel data base Management, data analysis, data presentation, data consolidation and Reporting.

MORE DETAILS
 
Date:
March 15 to 22, 2020
Schedule:
16 hours (Morning and Evening Shift)
Morning: 7 to 9 AM
Evening: 5.30 to 7.30 PM
Vanue: FDC Training hall, Anamnagar, KTM
Registration Fees: NPR. 5000 + VAT (Including Hi-Tea)
Contact Us on : 9801048455 (Rohinee Bista), Email: trainning@frontline.com.np