0845 470 1000 / enquiries@flane.co.uk
> > > 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.
Classroom Training

Duration 3 days

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

Duration 3 days

Price (excl. VAT)
  • United Kingdom: £ 1,703.-
  • 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
 
...