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.

Book a Public Course

Book Corporate 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



WORKPLACE TRAINING

Learn about our Corporate Workplace Training Options

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.

Book a Public Course

Book Corporate Course

Request Quote / Date

Enquire Now

Send Us a Text

Public & Virtual Dates

Public & Virtual Dates	Link to Book
16 Dec 2021 (Thu)	BOOK NOW

Virtual & Public Pricing

Public (One Day)	Price per Head
Enrol 1	$265
Enrol 2	$255
Enrol 3	$245
Enrol 4	$235
Enrol 5	$225
Concession Card	$175
5 Course Vouchers	$1,175
10 Course Vouchers	$2,250
20 Course Vouchers	$4,000
Corporate / Workplace	GET QUOTE
Custom Training	GET QUOTE
One on One	GET QUOTE

Excel Training Courses and Support Mobile MOUSe Perth WA

Course Outline (PDF)

Excel Skill Assessment

Related Excel Courses

Excel Consulting

Reuben, Downhole Surveys

\"Joes presentation is brilliant, he is engaging, informative and extremely knowledgeable. Top bloke. I will recommend him to my company. The facilities at Mobile MOUSe are excellent.\"

Silvana, Prime Laundry

\"The course was absolutely brilliant, Graeme is an excellent instructor and I have taken a lot from this course. Thank you, Thank you, Thank you :)\"

Natasha, Woodside

\"Thanks, it was great! Everything was perfectly timed, very enthusiastic trainer and a lot of great takeaways from today. I look forward to attending the next one in a few months.\"

Lisa, Georgiou Group

\"Great trainer!! Russell presented the course really well....very funny and helpful! The facilities were great too. Nothing bad to say at all....would totally recommend Mobile MOUSe to others!\"

Andreas, Sinostruct

\"Easily the best course I have been to. Graeme you do a wonderful job at keeping the course upbeat and interactive. Thank you, learnt so much\"

Roni, Ranger Drilling

\"Very good teaching technique, class control and time management. Very well presented. Great facilities, teaching aids and take home information for future reference. Money well spent.\"

Emma, Brikmakers

\"I thought this course was fantastic. I learned a lot, which will be valuable to my experience and skill set and relatable to my current role. Graeme is an Exceptional trainer, very good at his job.\"

Kristy, BHP Billiton Iron Ore

\"This is the most fun we have had on a course in ages, and learnt so MUCH! Russ was awesome, Thank you!\"

Lisa, Eni Australia Ltd

\"Everything was explained brilliantly. Small class which was great as was more comfortable asking questions. Trainer was very approachable and very knowledgeable.\"

Nicole, Wirtgen Australia

\"Graeme was very interactive with the class and did a great job at keeping everyone involved. The Facilities are also very good. Thank you!\"

Garry, Office of Transport Security

\"I have an extensive training background. The content, pace of delivery and quality of delivery was exceptional. Preparation was obvious and contributed to the course quality. Thank you so much\"

Andrea, HFM Asset Management

\"I attended the courses today with Russell and yesterday with Graeme, they are both amazing! I cant stress enough how great their customer service is, they are very patient and passionate about what they do. Well done guys!\"

Stacey, City of Nedlands

\"The training was awesome and the instructor very helpful! This is my second or third training course I have done with Mobile MOUSe and I would come back again!\"

TRAINING UPDATES

COURSE SPECIALS

We offer some amazing course discounts and specials. Join our mailing list in order to become eligible.

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 !!!

EXCEL CONSULTING