Data Analysis and Visualisation with Excel Power Pivot - Pro
Classroom based 1 day course with LIVE TRAINER with Post Course Support - Nationwide £238
Infero Training Ltd
Summary
Live Virtual training - £249.60 for 1 day training
Classroom training - £285.60 for 1 day...
- Certificate of completion - Free
- Tutor is available to students
Add to basket or enquire
Location & dates
King Street
MANCHESTER
Lancashire
M24PD
United Kingdom
Princes Square
LEEDS
West Yorkshire
LS14HY
United Kingdom
SHEFFIELD
South Yorkshire
S118NX
United Kingdom
Exchange Flags
LIVERPOOL
Merseyside
L23PF
United Kingdom
Overview
This intensive 1 day, hands-on course is part of 3 days Data Analysis and Visualisation with Excel PRO course and helps you to gain a comprehensive, practical understanding of data analysis with Power Pivot.
Big data that is being collected all the time leads to an overwhelming amount of data and needs people who can analyse it quickly. Fortunately, Microsoft Excel provides free Power Pivot tool.
In this Data Analysis and Visualisation with Excel course, you will gain a solid understanding of Power Pivot to maximize your effectiveness when analysing data. You will learn how to organise, manipulate, and report on large amount of data in the best way possible, including creating dynamic Power Pivot reports, calculations and KPIs, as well as understanding of commonly used DAX Functions.
The Data Analysis and Visualisation with Excel Power Pivot course is the last in the Data Analysis with Microsoft Excel PRO 3 days series.
You can choose either our Classroom training at one of our venues or Live, Instructor-led Virtual training from the comfort of your home.
.
Benefits of Studying Data Analysis & Visualisation with Excel Power Pivot with Infero Training:
- Classroom training in Small Groups for Max Focus
- Only Microsoft Approved Courseware and Exercise Files are used
- Free Assessment of Skills prior to booking
- Certificate of Completion & Complementary 12 Months Post Course Support
- Premier Locations, Latest Tech, Refreshments, OR We Come to You
- 100% Money Back Guarantee & Price Match Guarantee
- Bespoke Courses & Group Discounts from £89 per person
.
Certification
Upon completion of the Data Analysis and Visualisation with Excel Power Pivot, you will receive a Certificate of Completion.
This course is also one of a series of courses that addresses Microsoft Certified Application Specialist (Microsoft Business Certification) skill sets. The Microsoft Certified Application Specialist program is for individuals who use Microsoft's business desktop software and who seek recognition for their expertise with specific Microsoft products. Certification candidates must pass one or more proficiency exams in order to earn Microsoft Certified Application Specialist certification.
Certificates
Certificate of completion
Digital certificate - Included
CPD
Description
Course Content for Data Analysis and Visualisation with Excel Power Pivot
Lesson 1: Getting Started with Power Pivot
Topic 1A: Explore the Power Pivot Application
Topic 1B: Import Data from Various Data Sources
Topic 1C: Refresh Data from a Data Source
Topic 1D: Create Linked Tables
Lesson 2: Manipulating Power Pivot Data
Topic 2A: Organize and Format Tables
Topic 2B: Create Calculated Columns
Topic 2C: Sort and Filter Power Pivot Data
Topic 2D: Create and Manage Table Relationships
Lesson 3: Creating Power Pivot Reports
Topic 3A: Create a PivotTable
Topic 3B: Create PivotCharts
Topic 3C: Filter Data Using Slicers
Topic 3D: Present PivotTable Data Visually
Lesson 4: Using DAX Functions in Power Pivot
Topic 4A: Manipulate PowerPivot Data Using DAX Functions
Topic 4B: Extract Data from Tables Using Functions
Topic 4C: Work with Time Dependent Data
Lesson 5: Distributing Power Pivot Data
Topic 5A: Protect Reports
Topic 5B: Save Reports in Different File Formats
.
Course Objectives
Upon successful completion of this Data Analysis and Visualisation with Excel Power Pivot course, students will be able to:
- become familiar with the Power Pivot application and import data
- manipulate data in a Power Pivot worksheet
- create reports using Power Pivot data
- use DAX functions in Power Pivot
- distribute Power Pivot Data
.
Testimonials from our Website and Google Reviews
I was absolutely delighted with the Excel courses that Infero delivered which more than exceeded my expectation. I learnt new ways of using Excel that I can now use in my day to day work to make my work more efficient. Pivot tables were always a mystery to me but now I use them regularly to display HR and Payrol data.
Lisa Dunstan (Payroll Manager) from Decathlon UK
.
The day after taking the Microsoft Excel Intermediate Course, I created two pivot tables and used several advanced formulas to do, in ten minutes, tasks that would previously have taken me hours. The teaching at Infero is easy to follow, the lessons are brilliantly delivered and the instructors are experts in their field, extremely friendly and endlessly patient. There are just the right number of breaks between concise, targeted modules to make learning as near effortless as possible. The ‘aftercare’ element - a tutor will usually answer your queries within hours - is particularly valuable. A great lunch, too.
Harry Frost (Marketing Assistant) from Babcock International Group
.
Had Excel training with Infero last week, I must say it was a good day, I am not the most gifted on excel, but after spending the day with our tutor Martin I came away with a lot more confidence and knowledge, and i will be back for more at a later date, Martin paced the course excellently so no one got left behind or not understanding how to do something. We had good rapport with Martin, even though he forgot how to spell his name :) must be an age thing Lol
Martin Pountney
.
I attended the level 3b training course offered by Infero Training and, like with many similar courses I have attended, was initially worried that it would be too much information to take in at once. However, the manuals and exercises provided along with the guidance and experience of our trainer Martin made the course interactive, concise and, dare i say it, enjoyable. I would highly recommend.
Michael Sexton
.
I attended the Microsoft Excel Basic and Excel Intermediate course which I found very useful. Martin is an excellent trainer, made you feel at ease, he is very helpful and patient. I wish I had undertaken the training ages ago as would have been very beneficial in my previous role.
Leela Patel
Who is this course for?
This Data Analysis and Visualisation with Excel Power Pivot course is for students with a sound working knowledge of Microsoft Excel and general computing proficiency, and are ready to advance their data-analysis capabilities to make business decisions.
Requirements
To ensure your success in this Data Analysis and Visualisation with Excel Power Pivot course you should have Excel knowledge, including how to create, edit, format, and print worksheets that include charts and sorted and filtered data is required. You should also know how to write and edit simple formulas. Students are also recommended to take the following courses, or have equivalent knowledge:
- Microsoft Excel Introduction
- Microsoft Excel Intermediate
Career path
Being proficient in Data Analysis and Visualisation with Excel Power Pivot can open the door to many career opportunities such as:
- Administrative Assistant
- Data Analyst
- Accountants
- Financial Analyst
- Retail Store Manager
- Project Manager
- Business Analyst
Questions and answers
Reviews
Currently there are no reviews for this course. Be the first to leave a review.
Legal information
This course is advertised on reed.co.uk by the Course Provider, whose terms and conditions apply. Purchases are made directly from the Course Provider, and as such, content and materials are supplied by the Course Provider directly. Reed is acting as agent and not reseller in relation to this course. Reed's only responsibility is to facilitate your payment for the course. It is your responsibility to review and agree to the Course Provider's terms and conditions and satisfy yourself as to the suitability of the course you intend to purchase. Reed will not have any responsibility for the content of the course and/or associated materials.