Ultimate Excel Training

Date Till: 19 August 2020

Ultimate Excel Training

Frontline Development Center (FDC), the development Partner of Froxjob is pleased to present with a compatible training program starting from 1 July, 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).

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

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

1 July 2020  Live PNG Images | Vector and PSD Files | Free Download on Pngtree

Schedule:
10 hours, Evening Shift (2 Hours Per Day)

Evening: 3:00 -5:00 PM

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