Support

Thank you from doMore

I'd like to thank you for being involved in the doMore.com.au community and the team and I hope that you've received value from being a part of it.

doMore was our original passion project born out of the desire to help connect people wanting to learn something new with experts that could teach them over 10 years ago.

Over the years we have helped almost 70,000 learners connect with one of over 1,500 courses and providers, across the country. For that, we're very proud and grateful for your contribution.

doMore.com.au also served to teach us about how to help measure and improve business performance and inspired the launch and growth of two other companies as a result, one of which we've decided to dedicate our resources and energy to making great.

We'll be switching the site off on Tuesday 31st of July. If you have any questions or concerns, please contact us directly on [email protected].

Thanks again and good luck with your teaching endeavours in the future.

Warm regards,

The doMore team.

Microsoft Excel 2003 Course | PivotTables

4 sessions available starting from $350.00

Subject: Microsoft Excel

Ages: All ages

Skill level: All difficulty levels

This course is designed to develop experience and confidence in using Excel pivot tables to analyse data and produce sophisticated management reports. Learn to create and work with Pivot Tables to view and analyse your data in a variety of ways. Discover how to perform a variety of calculations with Pivot Table Data. You will learn how to construct Pivot Tables and Charts to consolidate and summarise your data.

Duration:

1 Day

Audience:

Users needing to manipulate and analyse data stored in Excel lists using pivot tables.

Prerequisites:

Participants must have an intermediate level knowledge and experience with Microsoft Excel.

Course Content:

PivotTable Fundamentals

• What is a PivotTable?
• Why should I use a Pivot Table?
• What are the advantages?
• PivotTable...

see more

This course is designed to develop experience and confidence in using Excel pivot tables to analyse data and produce sophisticated management reports. Learn to create and work with Pivot Tables to view and analyse your data in a variety of ways. Discover how to perform a variety of calculations with Pivot Table Data. You will learn how to construct Pivot Tables and Charts to consolidate and summarise your data.

Duration:

1 Day

Audience:

Users needing to manipulate and analyse data stored in Excel lists using pivot tables.

Prerequisites:

Participants must have an intermediate level knowledge and experience with Microsoft Excel.

Course Content:

PivotTable Fundamentals

• What is a PivotTable?
• Why should I use a Pivot Table?
• What are the advantages?
• PivotTable Terminology
• Preparing your data for use in a PivotTable
• Creating a PivotTable
• Selecting the Data Source
• PivotTable Fields List
• Filterering data with Page Fields
• Adding Fields
• Removing Fields
• Understanding the Field icons

Presenting Data in PivotTables

• PivotTable Toolbar
• Hiding and Unhiding Items
• Sorting Data in a PivotTable
• Using AutoSort
• Advanced AutoSort
• Refreshing a PivotTable Report
• Inserting Data into the Data Source
• Formatting Numerical Data
• Selecting Parts of a PivotTable
• PivotTable Formats
• PivotTable Options
• Change the Summary Function
• Adding Multiple Data Fields
• Changing Calculations
• Hiding and Showing Row/Column Details
• Displaying Data Details

Grouping Data

• Grouping Data
• Group by Dates
• Group by Number
• Ungrouping Data

Calculations in PivotTables

• Changing custom calculations
• Creating Calculated Fields
• Calculated Items
• GetPivotData() to extract information
• Using Other Sources of Data
• Selecting data from another Excel workbook
• Connecting to an Database
• Using a Saved Query as the data source
• Using a csv text file as the source of a PivotTable

Using PivotCharts

• PivotChart terms
• Modifying the Chart
• Caution - Loss of Formatting in PivotCharts

Publishing PivotTables to the Web

• Saving a PivotTable as a web page
• Creating Interactive PivotCharts - Web
• Adding Fields to a PivotChart - Browser

Analysing Data from Multiple Ranges

• Setting up the PivotTable using multiple ranges
• Using Multiple Page Fields

Re-using PivotTables

• Requerying data
• Using Saved queries
• Automating PivotTable Updates
• Saving a PivotTable Template

see less

Choose from 4 available sessions:

When

Please contact us for upcoming dates and/or more information about this class.

Where

  • 8/40 Creek St
    Brisbane, QLD 4000

Price: $350.00

Type

  • Class / Group Sessions

When

Please contact us for upcoming dates and/or more information about this class.

Where

  • 8/40 Creek St
    Brisbane, QLD 4000

Price: $350.00

Type

  • Class / Group Sessions

When

Please contact us for upcoming dates and/or more information about this class.

Where

  • 8/40 Creek St
    Brisbane, QLD 4000

Price: $350.00

Type

  • Class / Group Sessions

When

Please contact us for upcoming dates and/or more information about this class.

Where

  • 8/40 Creek St
    Brisbane, QLD 4000

Price: $350.00

Type

  • Class / Group Sessions



My Other Listings

Dealing with Difficult Behaviour 1 day Training Course
Dealing with Difficult Behaviour 1 day Training Course
3 sessions available starting from $435.00
Microsoft PowerPoint 2010 Course | Advanced
Microsoft PowerPoint 2010 Course | Advanced
2 sessions available starting from $350.00
Access 2003 Advanced Course
Access 2003 Advanced Course
2 sessions available starting from $770.00

see all listings »


Found In