We are happy to advise you!
0845 470 1000     Contact

Instructor-Led Online Training (ILO)
Live Online Classes in the Virtual Classroom

Find out more and view dates

> > > 20779

Analyzing Data with Excel (20779)

 

Course Overview

This course is intended for anyone responsible for analyzing data with Excel.

Who should attend

This course is intended for:

  • Both novice and experienced programmers who have a minimum of three months programming experience and have basic Windows navigation skills.
  • Anyone responsible for analyzing data with Excel.
  • Course will likely be attended by SQL Server report creators who are interested in alternative methods of presenting data.

Certifications

This course is part of the following Certifications:

Prerequisites

Before attending this course, students must have:

  • Basic knowledge of the Microsoft Windows operating system and its core functionality.
  • Good Knowledge of Excel spreadsheets, functions, and charts.
  • Working knowledge of relational databases.

Course Objectives

After completing this course, students will be able to:

  • 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.
Online Training

Duration 3 days

Price (excl. VAT)
  • United Kingdom: £ 1,705.-
  • SA Voucher: 3
    hardcoded default SA
Classroom Training

Duration 3 days

Price (excl. VAT)
  • United Kingdom: £ 1,705.-
  • SA Voucher: 3
    hardcoded default SA
E-Learning MOC on Demand

Duration 90 days

Price (excl. VAT)
  • United Kingdom: £ 449.-
  • SA Voucher: 2
    hardcoded default SA
Buy E-Learning
 
Click on the location to go directly to the booking page Schedule
This computer icon in the schedule indicates that this date/time will be conducted as Instructor-Led Online Training.
This is a FLEX course, which is delivered both virtually and in the classroom. Please note, local pricing is applicable.
United Kingdom
15/04/2020 ― 17/04/2020 Virtual Enroll
29/06/2020 ― 01/07/2020 London (Int Hse) Enroll
28/09/2020 ― 30/09/2020 London (Int Hse) This is a FLEX course.   Time zone: Europe/London Enroll:
for online training
for classroom training

Fast Lane Flex™ Classroom If you can't find a suitable date, don't forget to check our world-wide FLEX™ training schedule.