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

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)
  • £ 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

Schedule

This course is guaranteed to run. Please see our complete terms and conditions for full details of this offer.
This is a FLEX course, which is delivered both virtually and in the classroom. Please note, local pricing is applicable.
English
Time zone BST
28/09/2020 ― 30/09/2020 Online Training Time zone: BST
21/12/2020 ― 23/12/2020 Online Training Time zone: GMT
25/01/2021 ― 27/01/2021 Online Training Time zone: GMT
29/03/2021 ― 31/03/2021 Online Training Time zone: BST
This course is guaranteed to run. Please see our complete terms and conditions for full details of this offer.
This is a FLEX course, which is delivered both virtually and in the classroom. Please note, local pricing is applicable.
United Kingdom
28/09/2020 ― 30/09/2020 Virtual This is a FLEX course.   Time zone: Europe/London Enroll:
for online training
for classroom training
21/12/2020 ― 23/12/2020 London (Int Hse) This is a FLEX course.   Time zone: Europe/London Enroll:
for online training
for classroom training
25/01/2021 ― 27/01/2021 London (Int Hse) This is a FLEX course.   Time zone: Europe/London Enroll:
for online training
for classroom training
29/03/2021 ― 31/03/2021 London (Int Hse) This is a FLEX course.   Time zone: Europe/London Enroll:
for online training
for classroom training