Microsoft Excel Data Analysis Course

Microsoft Excel Data Analysis Course

Microsoft Excel short courses in Sydney, open to everyone.

Learn to work smarter with your data with our Microsoft Excel courses in Sydney.

Microsoft Excel is one of the world’s most popular spreadsheet software applications. Learn Microsoft Excel with our Microsoft Excel courses in Sydney - short courses open to everyone.

This Microsoft Excel data analysis course is an advanced Excel course where you will learn how to use the data analysis add-ins of Microsoft Excel, including:

  • using Power View to create interactive data visualisations
  • using Power Pivot to create a data model for use with Microsoft Excel tools such as pivot tables and pivot charts
  • using Get & Transform to import and combine data from a variety of sources such as databases and web sites and using Power Map to visualise geographic data.

This Microsoft Excel course is designed for those already familiar with Microsoft Excel or those who have completed Microsoft Excel Course: Level 3 (Advanced) or have equivalent knowledge and are seeking a more in-depth understanding of data analysis techniques using Microsoft Excel.

Learning Outcomes

At the completion of this Microsoft Excel data analysis course you should be able to:

  1. Use Power View to examine and analyse data.
  2. Perform a variety of analytical tasks using Power Pivot.
  3. Import and refine data with Get & Transform.
  4. Effectively create and work with data in Power Map.

Course Content

Microsoft Excel Power View

  • Understanding Power View.
  • Enabling Power View.
  • Adding Power View to the Ribbon.
  • Creating a Power View Sheet.
  • Working With a Power View Object.
  • Working With Power View Fields.
  • Rearranging and Sorting Fields.
  • Working With Measure Fields.
  • Formatting Power View Data.
  • Tiling Data in Power View.
  • Filtering in Power View.
  • Switching Visualisations.
  • Adding More Power Views.
  • Adding Titles and Images.
  • Updating a Power View Report.

Microsoft Excel Power Pivot

  • Understanding Power Pivot.
  • Understanding Relational Data.
  • Enabling Power Pivot.
  • Connecting to a Data Source.
  • Working With the Data Model.
  • Working With Data Model Fields.
  • Changing a Power Pivot View.
  • Creating a Data Model PivotTable.
  • Using Related Power Pivot Fields.
  • Creating a Calculated Field.
  • Creating a Concatenated Field.
  • Formatting Data Model Fields.
  • Using Calculated Fields.
  • Creating a Timeline.
  • Adding Slicers.

Get & Transform in Microsoft Excel

  • Understanding Get & Transform.
  • Understanding the Navigator Pane.
  • Creating a New Query From a File.
  • Creating a New Query From the Web.
  • Understanding the Query Editor.
  • Displaying the Query Editor.
  • Managing Data Columns.
  • Reducing Data Rows.
  • Adding a Data Column.
  • Transforming Data.
  • Editing Query Steps.
  • Merging Queries.
  • Working With Merged Queries.
  • Saving and Sharing Queries.
  • The Advanced Editor.

Microsoft Excel Power Map

  • Understanding Power Map.
  • Creating a Power Map Tour.
  • Working With Location Fields.
  • Working With Mapping Confidence.
  • Working With Height and Category Fields.
  • Filtering Data.
  • Navigating a Data Map.
  • Changing the Look.
  • Working With Layers.
  • Working With Scenes.
  • Working With Scene Options.
  • Working With Time Settings.
  • Viewing and Editing a Tour.
  • Exporting a Tour as a Video.

Intended Audience

Providing comprehensive and thorough coverage of data analysis add-ins, this Microsoft Excel course is ideal for anyone who has completed Microsoft Excel Course: Level 3 (Advanced) or for existing Excel users seeking a more in-depth understanding of data analysis techniques.

Delivery Style

This Microsoft Excel data analysis course is presented as a practical, instructor-led computer-based course in a Microsoft Windows environment. You’ll have dedicated access to a computer exclusively for your use so you can follow instructor training and work through examples.

Course Prerequisites

This Microsoft Excel data analysis course assumes fluency with Microsoft Excel and the creation of workbooks. You should be familiar with the basic functions of a computer operating system. This includes navigating the environment using a mouse and keyboard, starting applications, copying and pasting objects, formatting text, creating folders, opening and saving files, familiarity with the accessing the Internet and use of common web browsers. If you do not have these skills, we recommend attending the Basic Computer Skills Course before attempting this course.

About your instructor

Paul Neale

Paul Neale

Paul Neale has had vast experience teaching all Microsoft Office applications from basic to advanced levels. His qualifications include Microsoft Certified Professional, Cert IV Workplace Training and Assessment, and Cert IV Small Business Management. He is an experienced Project Management and Team Leader. He is also an IT trouble-shooter, experienced in hardware assembly, network design, back-office apps and helpdesk support.


Get $25 off

Get $25 off

Receive a $25 gift voucher to use toward your first enrolment.

Employer Sponsorship

Employer sponsorship

Your employer may be willing to pay for your course. Find out more.

Payment

Need an invoice to make payment?

Use our invoice authorisation to request one for your organisation.

Training

Training for groups of employees

Learn more about enterprise training for organisations.

CorporatePass

Self service enrolment for organisations

CorporatePass enables you to enrol participants with deferred payment.


Seven great reasons to enrol in a short course with us

99.0% average satisfaction

Join thousands of satisfied participants who have completed short courses with us. Read what they have to say.

Small class sizes

Our small class sizes and personalised approach gives you greater access to a quality education. There’s plenty of opportunity to interact with your instructor and ask questions.

Modern facilities and equipment

We have spacious, modern, purpose-built facilities equipped with the latest technology.

Quality instructors

Our educators bring first-hand experiences and knowledge to your learning, incorporating cutting-edge practices from diverse industries.

For business, or for pleasure

Our courses help you to develop your skills and knowledge, whether it be for professional development or personal interest. We also offer customised training for organisations.

24/7 secure online enrolment

With enrolment available online 24 hours a day, 7 days a week, registering for a course is as easy as it is convenient.

Enrol as easy as 1-2-3

Pay for your course securely online in 3 simple steps: select your course, provide your details and select your payment method. It’s that simple. Organisations seeking payment other than via credit card can enrol participants using our Invoice Authorisation.

Course Features

Available classes for Microsoft Excel Data Analysis Course

No dates that suit you? Be the first to know when we schedule more. Join the waiting list.

The University of Newcastle, Sydney Campus is a leading provider of short courses in Australia, with industry qualified and experienced educators that bring up-to-date real-world skills directly to the classroom.