Excel Power Pivot Course Perth
The ULTIMATE Excel Power Pivot Course in Perth. Discover our World Class Excel Power Pivot Training that teaches students how to build amazing and powerful reports, using this modern Excel tool.
Excel Power Pivot Course Summary
Our Excel Power Pivot Essentials Course covers a number of important topics for advanced Excel users, who would like to learn about this powerful reporting and analysis tool for Microsoft Excel. Data Imports, Functions and Reporting are just some of the elements of this course.
COURSE DETAILS
Click to view details about this Training Course
COURSE DATES
View our available Public & Virtual Course Training Dates
COURSE PRICING
Check out our amazing Public & Virtual Course pricing
REMOTE TRAINING
You can also attend Virtually (Remotely). Learn how it works
Excel Power Pivot Course Details
Learn more about this Course and find links to booking options.
Outline: Excel Power Pivot Course
You can learn more about this Course, by drilling down on the topics below.
Overview
- Power Pivot Introduction
- Install Power Pivot for Excel
- Navigate Power Pivot windows
Power Pivot Data Sources
- Supported Data Sources
- Loading Data Sources
- Load Data from SQL Server
- Add Data from Text Files
- Load Data from Excel Files
- Add Data via Copy and Paste
- Cleaning Data
- Create Data Relationships
Power Pivot Functions
- Power Pivot Expressions
- DATE Functions
- TIME Functions
- STATISTICAL Functions
- VALUE Functions
- LOGICAL
- INFORMATION Functions
- TEXT Functions
Power Pivot Reports
- Power Pivot Reports
- Pivot Charts
- Slicers
- Sparklines
Overview
Our Excel Power Pivot Course is suitable for Advanced Excel Users. This course introduces the fundamentals of Power Pivot, and as a result, students learn how to build powerful and flexible reports in Microsoft Excel.
Furthermore, knowledge gained includes best design practices, as well as Power Pivot functions. Finally, Data Importing and Reporting concepts are covered in detail.
Audience & Duration
This one day course (9am to 4pm WST) is a Advanced Excel Course, which means that it is aimed at advanced users. Therefore, it will not suit users with limited Excel skills.
Excel Power Pivot Course Outcome
At the end of this course students should be able to generate amazing Power Pivot reports. During this Excel Power Pivot Training course, guidance is given about best practices for importing data into Power Pivot. Consequently, students will also learn how to perform calculations on data and will subsequently be able to generate interactive reports.
Excel Power Pivot Course Attendance
We offer a number of different ways to attend our Perth based Training, such as Public or Virtual Courses, as well as Workplace Training options. This is all in addition to the fact that you can also attend our courses online.
Public and Virtual Excel Power Pivot Courses
We often run Public Courses at our venue in Perth, which can also be attended virtually (via ZOOM or Teams), from anywhere in Australia.
Workplace Excel Power Pivot Training
We also offer Workplace Training for companies. This means that we can run the course at your venue, or you can come to ours. With workplace courses, we supply laptops (with no rental fees), and can also cater for virtual students at the same time.
Custom Excel Training
In addition to this course, we also offer many other Training Courses for Excel, as well as custom Excel Training.
Online Courses
In addition to our standard delivery, we also offer the option to sit your Power Pivot course via our online training portal.
Public & Virtual Dates
Public & Virtual Dates | Booking Link |
---|---|
16 Aug 2022 (Tue) | BOOK NOW |
Virtual & Public Pricing
TRAINING UPDATES
Course Specials
We offer some amazing course discounts and specials. Join our mailing list in order to become eligible.
We now also accept Afterpay. You can select this option when completing your course booking online.
Microsoft Excel Consulting Perth, Australia
Not only does Mobile MOUSe offer the best Excel Power Pivot Course in Perth. But we also offer tailored Excel support and assistance for any type of spreadsheet..
Our Perth based Microsoft Excel Support is world class, due to our years of experience and expertise.
Get Excel Support by contacting us today !!!
Related Microsoft Courses
In addition to this Excel Power Pivot Course, here are our related Microsoft Training Courses for Australia and Perth.
EXCEL POWER QUERY COURSE
Info on our Excel Power Query Course (Advanced). Virtual Classes are also available.
EXCEL POWER PIVOTS COURSE
More on our Excel Power Pivot Training Course (Advanced). Virtual Classes are also available.
EXCEL DASHBOARDS COURSE
Discover our Excel Dashboards Course (Advanced). Virtual Classes are also available.
INTERMEDIATE EXCEL TRAINING COURSE
More about our Intermediate Excel Training Course. Virtual Classes are also available.
ADVANCED EXCEL TRAINING COURSE
Discover our Excel Expert (Advanced Excel Course). Virtual Classes are also available.
EXCEL FORMULA WORKSHOP COURSE
Learn about our Excel Formulas Course (Advanced). Virtual Classes are also available.
VBA (MACROS) EXCEL COURSE
Click to learn about our Excel VBA Course (Advanced). Virtual Classes are also available.
In Business Since
Students Trained
Avg Student Score (out of 10)
Pricing From
Excel Power Pivot Training Inclusions
All Mobile MOUSe Excel Courses have the following course inclusions…
IN-HOUSE (Our Venue)
Power Pivot Courses at our Perth venue include the following…
- State of the Art Venue
- Face to Face Courses
- Manual (PDF)
- Certificate (PDF)
- Exercise Files
- Free Post Course Help
- Refreshments and Snacks (Free)
- Free Parking
- Dynamic Trainers
- Really Affordable Training
- An Amazing Training Day 🙂
ONSITE (Your Venue)
Our Workplace Training normally includes these features…
- Laptops (no rental fees)
- Face to Face Training
- Manual (PDF)
- Certificate (PDF)
- Exercise Files
- Free Post Course Help
- Projection Equipment
- Cables & Power Boards
- Dynamic Trainers
- Very Affordable Training
- An Amazing Training Day 🙂
Virtual Excel Courses
In short, Virtual Training (via ZOOM or TEAMS) features include…
- Face to Face Training
- Interactive Virtual Classroom
- Manual (PDF)
- Certificate (PDF)
- Exercise Files
- Free Post Course Help
- Fewer Travel Costs
- No Public Health Worries
- Dynamic Trainers
- Really Affordable Training
- An Amazing Training Day 🙂
Courses Online (Self Paced)
Our Online Courses include the following features…
- Online Portal
- Same Trainers
- Manual (PDF)
- Certificate (PDF)
- Exercise Files
- Free Post Course Help
- Fewer Travel Costs
- No Public Health Worries
- Dynamic Trainers
- Really Affordable Training
- Learn at Your Own Pace