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

  • Understand Data Analytics with Microsoft Excel

    Understand Data Analytics with Microsoft Excel

    SGD $40.00

    Course Description

    In today's world, we must navigate through a sea of data and simplify it into decisions for growth, problem solving, and success. By learning the data-analysis techniques and features of Microsoft excel we can master the fast growing world of Analytics. Microsoft Excel is the most common analysis software on the market today, but few users are aware of its full powers. In this advanced course, users will master the tasks necessary in order to handle today's complex data sets, including data validation, data analysis, charting, and design. * Learn how to use Excel and your data to support decision making * Master functions and calculations that streamline your analysis * Simplify statistics through the use of Excels analysis features * Learn to automate repetitive tasks and quickly spot patterns * Translate your analysis into meaningful charts and graphs.Realise the full potential of your data with Microsoft Excel. - Learn about the functions in Excel that can help your understand data better - Know the different ways of vizualising your data with Excel- Pick up the knowledge of utilizing Excel for better understanding your data- Learn how you can stretch your data for optimum analysis 

    Read more...

  • Corel Painter X3 Advanced

    Corel Painter X3 Advanced

    SGD $45.00

    Course Description

    Corel Painter X3 is a powerful and popular natural media emulator which is used by professional creative artists in a wide variety of genres and styles. This course, taught by longtime illustrator and fine artist Jason Maranto, is designed to quickly familiarize you with many advanced features of this powerful application. Focusing on the extensive Painter X3 brush engine settings, with an in-depth but easy to follow style, this course is packed with valuable brush design tips and tricks. Quickly helping you to unlock the mark-making potential of Painter, so your personal expressiveness can come to life inside Painter like never before.Dive into Corel Painter and unleash your artistic flare!- Learn about the tools and techniques available in Corel Painter X3 - Know about the different types of tools and techniques used in Corel Painter X3- Discover the capability of Corel Painter X3 to create dynamic creative content - Be able to produce content that can rival physical painting 

    Read more...

  • Essential Online Course - Microsoft Access 2016

    Essential Online Course - Microsoft Access 2016

    SGD $299.00

    Course Description

    Microsoft Access is now much more than a way to create desktop databases. It’s an easy to use tool for quickly creating browser based database applications that help you run your business. Your data is automatically stored in a SQL database, so it’s more secure and scalable than ever, and you can easily share your applications with colleagues. This course will guide you through the basics of relational database design and through the creation of database objects. You will learn how to use forms, query tables and reports to manage data. You will understand the interface, customization and creation editing of the many objects available within the Microsoft Access application. This course is divided in to three separate levels being Basic Microsoft Access, Intermediate Microsoft Access and Advanced Microsoft Access. Realise the full potential of your data with Microsoft Access. - Learn about the functions in Microsoft Access that can help your understand data better  - Know the different ways of vizualising your data with Microsoft Access - Pick up the knowledge of utilizing Access for better understanding your data - Learn how you can stretch your data for optimum analysis

    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.