Analyzing Data with Excel Training & Certification Courses

Enquire Now


 
Loading...  

Processing data, please wait...

Live Chat
Official Training
Official Training
Microsoft #1 Training Partner
Microsoft #1 Training Partner
Guarantee to Run the Classes
Guarantee to Run the Classes
Hello Koenig

Overview

The main purpose of Analyzing Data with Excel course is to give students the ability to add BI techniques to Excel data analysis. The course goes beyond the capabilities of tables and charts and uses Pivot Charts, the Excel Data Model, and Power BI.

Audience:
  • Students who are experienced with analyzing data with Excel and who wish to add BI techniques.
  • SQL Server report creators who are interested in alternative methods of presenting data.

This course prepares you for Exam 70-778. Download course contents.

Need more info ? Email info@koenig-solutions.com  or   Enquire now!

Schedule & Prices

Delivery Mode Location Fees Schedule
Instructor-Led Online Training (1-on-1)

Duration : 3 Days
Client's Home/Office $ 1,720 As per mutual convenience (4-Hours Evenings & Weekends Possible
Classroom Training *

Duration : 3 Days
dubai $ 2,060
3 Nov -5 Nov 2019,
10 Nov -12 Nov 2019,
8 Dec -10 Dec 2019
Delhi, Bangalore, Dehradun (Rishikesh), Goa, Shimla, Chennai $ 1,470
11 Sep -13 Sep 2019,
12 Sep -14 Sep 2019,
3 Oct -5 Oct 2019,
9 Oct -11 Oct 2019,
28 Oct -30 Oct 2019,
11 Nov -13 Nov 2019,
13 Nov -15 Nov 2019,
2 Dec -4 Dec 2019,
9 Dec -11 Dec 2019
Fly-Me-a-Trainer

Duration : 3 Days
Client's Location On Request As per mutual convenience

Course Prerequisites

  • Basic knowledge of the Microsoft Windows operating system and its core functionality.
  • Working knowledge of relational databases.
  • Extensive knowledge of Excel spreadsheets including formulas, charts, filtering, sorting, and sub-totals.

FREE Trial Class FREE pre-requisite Class FREE revision Class

Need more info ? Email info@koenig-solutions.com  or   Live Chat

Analyzing Data with Excel Benefits

Upon Completion of this Course, you will accomplish following:-

  • Explore and extend a classic Excel dashboard.
  • Explore and extend an Excel data model.
  • Pre-format and import a .CSV file.
  • Import data from a SQL Server database
  • Import data from a report.
  • Create measures using advanced DAX functions.
  • Create data visualizations in Excel.
  • Create a Power BI dashboard with Excel
Need more info ? Email info@koenig-solutions.com  or   Enquire now!

Verbatim Student Feedback

Q1 Say something about the Trainer? Q2 How is Koenig different from other training Companies? Q3 Will you come back to Koenig for training?

Student Name Country Month Feedback Rating
Sale Abdullahi Nigeria Jul-2019 A3 THIS IS MY THIRD TRAINING WITH KOENIG, IT MEANS I ENJOYED THE PREVIOUS
Mohammed Almahdi Oman Jul-2019 A1 Professional, helpful, knows his area.
Chiyesu Kalaba Zambia May-2019 A1 He is a subject mater expert for the courses covered. Went out of his way covering concepts which were prerequisites for the courses for which I had no background in.
View More..
Delhi
Bangalore (Bengaluru)
Goa
Shimla (Himalayas)
Chennai
Dehradun
Dubai
USA UK
All rights reserved. ©1997 - 2019, Koenig Solutions Pvt. Ltd.
PMP® is a registered trademark of the Project Management Institute.
Koenig Solutions Pvt. Ltd. is rated 4.4 stars by www.facebook.com/KoenigSolutions based on 107 reviews

Please Input Captcha Below

Submit