> > > 20779

Analyzing Data with Excel (20779)

Course Description Schedule Course Outline
 

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.

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.
Classroom Training

Duration 3 days

Price (excl. VAT)
  • United Kingdom: £ 1,703.-
  • SA Voucher: 3
    hardcoded default SA
Enroll now
Online Training

Duration 3 days

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

Duration 90 days

Price (excl. VAT)
  • United Kingdom: £ 449.-
  • SA Voucher: 2
    hardcoded default SA
Buy E-Learning
 

Accessing our website tells us you are happy to receive all our cookies. However you can change your cookie settings at any time. Find out more.   Got it!