MS® Excel PowerPivot Training

MS® Excel PowerPivot Training

Microsoft PowerPivot is an add-on for Excel that provides business intelligence functionality & reporting within the familiar environment of Excel. PowerPivot provides the real power to crunch & analyse data on a scale previously unimaginable with pivot tables. Now it is possible to process millions of rows of data in Excel enabling deeper business insight and shorter decision making cycles.

This course is suitable for any existing Excel user who has to manipulate, analyse and report on massive amounts of data. Attendees have varied from business analysts, commercial directors, finance teams, client service/revenue managers to the Central Statistics Office.

Support

Dedicated team of trainers and staff, committed to delivering support and advice to our customers.

Experience

We have over 12 years experience providing training for individuals, small, medium and large companies.

Training Team

Our trainers combine professional know-how with experience in their chosen training field.

Quality Assured

Safeguard your training investment. We offer courses accredited by national and international certification bodies.

a few of the companies that trust dcm

Get the MS Excel Power Pivot Training Course Brochure & 2024 Timetable Instantly

Get the MS Excel Power Pivot Training Course Brochure & 2024 Timetable Instantly

Full Course Outline

What's Inside the Brochure - Course Format; Trainer Profiles; Testimonials; Membership Details; Full 2024 & Fee.

Membership Details

By becoming a Member with DCM, you will gain access to exclusive free courses and substantial discounts on our certified courses.

Customer Stories

We work with the biggest brands in Ireland including Symantec, Keelings and Vodafone but don't just take our word for it.

Team Development Needs?

Do you have team development needs? An inhouse training solution is typically less expensive per head than publicly scheduled courses and provides greater business relevance.

Grow Your Career with DCM

Join thousands of professionals growing their careers with DCM Learning, for free. By becoming a member, you will gain
access to over 100 free courses and discounts on certified courses

Try Our Free Courses

Why not try our free one of our Free 1 Day Live Virtual Courses. (30 to Choose From). We have topics including management, project management and lots more.

Safeguard Your Investment

We have delivered training courses to some of the biggest organisations in Ireland so you can have confidence in our ability to deliver the results you want to achieve.

Bitesize Learning

If the one day courses are too long, why not try our Free Bitesize Learning?. We have over a 100+ one hour courses to choose from including public speaking and negotiations.

96% Of people who attended our training courses would recommend to others

20K Join the 20,000+ members who've advanced their career with DCM

87% Of learners report career benefits like getting a promotion or a raise

What is covered in this course?

The course will show delegates how to leverage their existing PivotTable knowledge in Excel with PowerPivot.

1

Getting Started with PowerPivot

Start Excel & launch the PowerPivot window
Navigating the PowerPivot window
Exploring the PowerPivot tab and field list in Excel

2

Adding Data to PowerPivot

Data sources and types supported in PowerPivot workbooks
Importing data (from pre-prepared file)
Add Data by using Excel Linked Tables

3

Preparing Data for Analysis

Working with Tables and Columns
Filtering and Sorting Data
Creating Relationships Between Tables
Creating and Working with calculations

4

Formatting and Layout

Creating, deleting a table
Rename a Table or Column
Set the Data Type of a Column
Hide or Freeze Columns
Undo or Redo an Action

5

Calculations in PowerPivot

Overview of Data Analysis Expressions (DAX) language
Building Formulas for Calculated Columns and Measures
Understanding the Use of Relationships and Lookups in Formulas

6

Creating PivotTables

Create a PivotTable or PivotChart Report
Create a Reporting Services Report with PowerPivot Data
Create a Measure in a PivotTable or PivotChart

Please Note: Each delegate will leave the course with an action plan for the workplace

Need Some Advice?

We have an excellent team who are more than happy to give you advice about the course. It doesn't matter what the question please ask, we'd be delighted to help.

Join over 20,000+ members that trust DCM Learning

What We Do

Founded in Dublin, DCM Learning is fast becoming recognised as a leading training organisation. We work closely with industry to define the skills and qualifications required to thrive.

At our core, we believe people learn best by doing. We design fun, powerful experiences that have a profound and lasting impact on people and their careers, inspiring new ways of thinking, building critical capabilities and unleashing business success. We empower you to learn from fresh, high-quality content on the skills that matter, taught by leading experts.

Our Customers

We work with small and large companies, individuals, Government Agencies, Universities and blue-chip companies such as Keelings, Google, Zendesk, Novartis, IBM and Symantec, so you can have confidence in our ability to deliver the results you want to achieve.

Our Certification Partners

In House Training In Your Office. Wherever You Are.

Have Team Development Needs?

We’ll work with you to create the course that your team and your business need. Get in touch today and we can give you a quote within an hour.

978 THE NUMBER OF COMPANIES WE DELIVERED INHOUSE TRAINING IN THE LAST 2 YEARS

87.3% OF COMPANIES WHO RETURNED FOR MORE TRAINING

37 27 FULL TIME TRAINING CONSULTANTS PLUS 10 SUPPORT STAFF

Trusted by

Related Courses

Advanced MS Excel

Information Technology

Advanced MS Excel Course Details

MS Excel Dashboards

Information Technology

MS Excel Dashboards Course Details

Free Bitesize Courses

We have over 100 free courses available to explore, all created by expert trainers, packed full
of practical exercises and real-world examples.

Explore All Courses

Make sure you Safeguard Your Training Investment. DCM offer courses accredited by:

Course Categories

Management Project Mgt. & Lean Agile Project Mgt.Learning & Development + View All 141 Courses

Course Categories

Communications Written Communication Personal Effectiveness + View All 141 Courses

Course Directory Brochure