Loading Events

« All Events

  • This event has passed.

PPERAE Excel Reporting & Analysis Essentials

December 4, 2017 @ 9:00 am - 5:00 pm UTC+11

$675
Excel Reporting & Analysis Essentials

This course is not currently scheduled. Please get in touch to book.
This one-day hands-on, instructor-led course will guide you step-by-step through how PowerPivot for Microsoft Excel makes advanced Business Intelligence available to any mainstream business user working with Excel 2010 and demonstrate where it can be used to solve different types of business reporting problems, a technology that lets you build complex data structures and analyse them without needing to engage IT staff!

This course is not currently scheduled. Please get in touch to book.

Overview

This one-day hands-on, instructor-led course will guide you step-by-step through how PowerPivot for Microsoft Excel makes advanced Business Intelligence available to any mainstream business user working with Excel 2010 and demonstrate where it can be used to solve different types of business reporting problems, a technology that lets you build complex data structures and analyse them without needing to engage IT staff!

Branded self-service Business Intelligence (BI), the course covers all the fundamentals of developing reports with PowerPivot in the real world, from the basics of how to use PowerPivot through to creating and formatting reports.  The course also covers how to use PowerPivot to provide business users the ability to easily customise and create ad- hoc reports.

Download Course Outline   Contact Us

Who Should Attend

The course is designed for all types of reporting users that are required to expose real-time, powerful business intelligence with PowerPivot including Information Works, Business Users, Developers and Analysts.

Course Objectives

After completing this course, participants will be able to:

  • Install PowerPivot and learn how to create an analytical database inside Excel 2010
  • Import various data sources into PowerPivot
  • Clean imported data
  • Understand Data Modelling basics for building PowerPivot data models
  • Use many of the report types in PowerPivot
  • Create Slicers and Sparkline’s for more engaging reports
  • Describe, use and apply PowerPivot Expressions

Course Prerequisites

Before attending this course, participants should have:

  • Experience navigating the Microsoft Windows environment
  • Experience with using Microsoft Excel PivotTable and PivotChart is desirable
  • General report building skills will be helpful

Details

Date:
December 4, 2017
Time:
9:00 am - 5:00 pm
Cost:
$675
Event Categories:
, , ,

Organizer

WARDY IT Solutions Training
Phone:
1300 WARDY IT (927 394)
Email:
training@wardyit.com
Website:
https://www.wardyit.com/training/

Tickets

Tickets are not available as this event has passed.