ULTIMATE EXCEL TRAINING FOR PROFESSIONAL - WEEKEND COURSE

Frontline Development Center (FDC), the development Partner of Froxjob is pleased to present with a weekend  training course starting from 8th May 2021  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:
8th May, 2021

Schedule:
Total Duration: 8 Hours 
( 4 Hours Per Saturday)

Shift : 
Morning: 7:00AM - 11:00AM

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

For More Deatils: https://frontline.com.np/ultimate-excel-training-weekend-course