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
  • An Essential Online Course: PivotTable Course (PC: 2013 & 2007/10), Singapore SKillsFuture elarning online course
  • An Essential Online Course: PivotTable Course (PC: 2013 & 2007/10), Singapore SKillsFuture elarning online course
  • An Essential Online Course: PivotTable Course (PC: 2013 & 2007/10), Singapore SKillsFuture elarning online course
  • An Essential Online Course: PivotTable Course (PC: 2013 & 2007/10), Singapore SKillsFuture elarning online course
  • 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

  • Sony DVD Architect Pro 5

    Sony DVD Architect Pro 5

    SGD $45.00

    Course Description

    Sony DVD Architect Pro 5 is the latest update to the extremely popular professional digital video authoring software. In this VTC course, users will be shown the initial system requirements necessary to run the program smoothly. Author Mark Struthers will then discuss the main functions as he demonstrates several methods for creating different types of projects including Menu-Based Projects and Music & Video Compilations. Important considerations such as Masks, Menus, and Themes are analyzed along the way. To conclude the course, methods of transferring projects to DVD are covered. Swiftly create professional-looking DVDs, even stunning widescreen productions. - Learn what goes into creating a DVD - Be able to create different kind of content in DVD - Learn how to create your own media content using Sony DVD Architect - Learn how to polish your projects before transferring into DVD

    Read more...

  • Understand your Database with Microsoft Access 2010

    Understand your Database with Microsoft Access 2010

    SGD $49.00

    Course Description

    As part of the release of the Office 2010 software suite, Microsoft is introducing the latest version of Access, their entry-level database application software. Don't let the words 'entry-level' fool you, this is one very powerful database tool. Access was designed to collect, store, manage, report, and dissect data for individuals and small businesses. The release of the 2010 version continues to raise the bar of what an entry-level database product can do. In this course, Mark Long takes you from opening Access 2010 for the first time through the entire process of creating a database. He covers tables, queries, forms, reports, and many of the other bells and whistles that make up Access 2010. 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...

  • Essential Online Course - Microsoft Word 2016

    Essential Online Course - Microsoft Word 2016

    SGD $299.00

    Course Description

    Microsoft Word 2016 is a very popular word processing program that can be used for both personal and business purposes. While already feature rich and critical for productivity, Microsoft continues to improve and enhance their software with each new release like the latest Microsoft Word 2016. In this course, you will develop and improve your Microsoft Word skills, so that you are able to maximize this industry standard word processing system. This online training course will cover Basic Word 2016, Intermediate Word 2016 and Advanced Word 2016. 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

    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.