ted-learning-logo

Microsoft Excel Power Pivot (Beginner)

This hands-on course demonstrates how to take advantage of self-service business intelligence using Microsoft PowerPivot for Excel.

Free

1 day
All levels
0 lessons
0 quizzes
0 students

Course Info

Power Pivot is an add-in for Microsoft Excel 2010 and 2013 that enables you to import millions of rows of data from multiple data sources into a single Excel workbook, create relationships between heterogeneous data, create calculated columns and measures using formulas, build PivotTables and Pivot Charts, and then further analyse the data so that you can make timely business decisions without requiring IT assistance.

What Will I Learn From This Course?

Import external data from multiple sources.

  • Client database
  • Excel tables
  • CSV files

Handling massive data from multiple sheets.

Create relationships between multiple tables.

How to create a user friendly models

Perform calculations in Power Pivot

  • Calculated columns.
  • Measures (Calculated field)

Create PivotTables and Pivot Charts.

Introduction to Data Analysis Expression language (DAX)

Target Audience

Excel Power Users, data analysts, business analysts, managers, MIS professionals and BI Consultants / BI Developers.

Pre-requisites

Delegates should be proficient users of Excel and be experienced in creating Excel PivotTables and Pivot Charts.

At Course Completion:

Upon successful completion of this course, the delegate should be proficient with PowerPivot and have the necessary skills to implement PowerPivot applications, manipulate data and perform data analysis.

Course Outline for This Programme

a. What is Power Pivot

b. Limitation of the normal Pivot Table

c. The Power Pivot Interface

a. Importing Data
b. Creating Linked Tables
c. Managing Relationships
d. Creating Your Power Pivot Table

a. Creating and customising reports that are user friendly
b. Formatting your Numbers
c. Customising your data model
d. Performing calculations with calculated columns
e. Performing calculations with calculated fields
f. Working with dates
g. Using slicers

a. DAXS operators
b. Calculated Columns
c. Calculated Fields
d. Date calculations

Curriculum is empty
Julian

Academic Qualifications
  • Diploma in Accountancy
  • ACCA (Association of Chartered Certified Accountants), UK

Professional Certifications
  • Pembangunan Sumber Manusia Berhad (PSMB) Certified Trainer
  • Microsoft Certified Trainer (MCT)

Julian specialises in conducting MS Excel application courses & seminars for various companies, local & multinationals. He teaches practical on-the-job experience, which translates to real-life exercises for participants’ benefit. Julian conducts various IT courses using Word Processors, Spread sheet, Database, Multimedia & Programming applications

whatsapp-icons
whatsapp-icons