Notice : You are now accessing LOOP UAT SERVER. This is not meant for public access. For the actual LOOP Website please visit www.LOOP.sg instead


An Essential Online Course: PivotTable Course (PC: 2013 & 2007/10)


An Essential Online Course: PivotTable Course (PC: 2013 & 2007/10), Singapore SKillsFuture elarning online course

Course Description

Microsoft Excel is an important and powerful program for many businesses. The PivotTable feature is one of the most useful, powerful and misunderstood features. PivotTables are absolutely not just about big data and large companies. Although PivotTables can work with very large data sets they are just as useful for micro businesses trying to understand where their sales opportunities lie or for individuals working on their household finances or even their fantasy football leagues.
This PivotTable course from Skillsology teaches you how to draw these conclusions easily and present and manage your findings effectively. Using screenshots, video examples and exercises, you’ll soon be able to make the most out of your data, whether ‘Big’ or small, to further your business or personal life.

Turn redundant data into useful analysis with PivotTable.

- Manage your data and information in a more intelligent system
- Realize your data's full potential to your advantage
- Discover ways to enhance your data output
- Learn about the advantages of PivotTable

This training is for PivotTable (PC version: 2013, 2007/10)

This course is SkillsFuture Credit Eligible.


Course Objectives

1. Identify the primary uses of PivotTables and when to use them
2. Identify ‘best’ and ‘worst’ entries in data sets
3. Filter, sort and group PivotTable data to maximize its usefulness
4. Present your findings clearly and compellingly using PivotCharts and Conditional Formatting
5. Customize calculations to ensure PivotTable data is tailored to your requirements
6. Use PivotTables to summarize data for management reports
7. Work with PivotTables based on OLAP cubes
8. Use Slicers to synthesize and emphasize data across multiple PivotTables
9. Use PivotTables to build interactive dashboards


Related Courses

  • Microsoft Visio Training: From 2007 to 2013

    Microsoft Visio Training: From 2007 to 2013

    SGD $99.00

    Course Description

    Learn how Microsoft Office Visio makes it easy to visualize, explore, and communicate complex information. Instead of static pictures, create data-connected Visio diagrams that display data and are easy to refresh. Use the wide variety of diagrams in Visio to understand and share information about organizational systems, resources, and processes throughout your enterprise. You’ll learn about Visio’s interface: including the ribbon, stencils and shapes, and setting document properties. You’ll also learn how to work with pages, and backgrounds and layers. Lastly, we will demonstrate how to create an organization chart and a flowchart. Learn and adopt Microsoft Visio and improve your productivity. - Know and understand the different versions of Microsoft Visio  - Know how Microsoft Visio can be applied into your work-life  - Understand how Microsoft Visio can change your productivity  - Enable yourself to produce work with satisfactory deliverables with Microsoft Visio  This course is SkillsFuture Credit Eligible.

    Read more...

  • Microsoft Project 2013

    Microsoft Project 2013

    SGD $45.00

    Course Description

    Microsoft Project is the standard-bearing tool to help project managers track all the vitals of their projects: tasks, resources, schedule, and cost. With the 2013 version of Project, Microsoft introduces several new features and improves existing ones. In this VTC course, author Brian Culp will guide users through techniques that allow project managers to quickly get up to speed on this powerful toolkit. Users will learn how to start projects, create and edit tasks, assign resources to tasks, share project information, and much more. Find out more about Microsoft's productivity tools!- Learn and understand the purpose of Microsoft's tools- Know more about the functionality and features of each application- Learn about functions that you never knew existed in Microsoft's tools- Be fluent and an efficient user in Microsoft tools by the end of this course This course is SkillsFuture Credit Eligible.

    Read more...

  • An Essential Online Course: Digital Collaboration with Office 365

    An Essential Online Course: Digital Collaboration with Office 365

    SGD $79.60

    Course Description

    Working with several separate software applications can be challenging. Microsoft Office 365 simplifies the process with an integrated collaboration and communication solution. Combining well known software applications with cloud features helps individuals and teams work together more productively. This course looks at the common features of Office 365 and how they can be used to support collaboration and communication. You and your staff will learn how to monitor and collaborate on projects and tasks, share knowledge and content with colleagues, and use social and communication tools efficiently. Discover the different products of Office 365 today! - Explore the different features in Office 365 - Know more about the functions of each individual product  - Learn about the purpose of the different products in Office 365 - Discover the usefulness of Office 365 for your job  This course is SkillsFuture Credit Eligible.

    Read more...


Content

PivotTable 2007/10 PC

+
Discover the contents of PivotTable 2007
  • Section 1: PivotTables
    • Unit 1.1 - Introduction - Finding the Best or the Worst
    • Unit 1.2 - Filter and Group to Compare and Contrast
    • Unit 1.3 - Presentation - Clarity and Impact
    • Unit 1.4 - Calculations - Adding Value to Values
    • Unit 1.5 - Your Data Your Way - Flexible Reporting
    • Unit 1.6 - Power to the User - Interactivity
  • Section 2: PivotTables for Data Analysis
    • Unit 2.1 - Dominate Your Data
    • Unit 2.2 - PowerPivot and Big Data
    • Unit 2.3 - Make Your Data Work Harder
    • Unit 2.4 - From Data to Decisions
    • Unit 2.5 - Present Data Analysis with Impact

PivotTable 2013 PC

+
Discover the contents of PivotTable 2013
  • Section 1: PivotTable 2013 PC
    • Unit 1.1 - Introduction and Basics
    • Unit 1.2 - Filter and Group to Compare and Contrast
    • Unit 1.3 - Presentation - Clarity and Impact
    • Unit 1.4 - Calculations - Adding Value to Values
    • Unit 1.5 - Your Data Your Way - Flexible Reporting
    • Unit 1.6 - Power to the User - Interactivity
  • Section 2: PivotTables for Data Analysis
    • Unit 2.1 - Dominate Your Data
    • Unit 2.2 - PowerPivot and Big Data
    • Unit 2.3 - Make Your Data Work Harder
    • Unit 2.4 - From Data to Decisions
    • Unit 2.5 - Present Data Analysis with Impact
    • Unit 2.6 - Give me more Power
SkillsFuture Credit Eligible
SGD $49.60
(Price excludes GST)
GET ACCESS NOW
Convince your boss email
This site is best viewed using the latest versions of Google Chrome, Apple Safari, Mozilla FireFox, Microsoft Internet Explorer 11 and Edge which supports HTML5/Webkit technologies.