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

  • Google Apps for Business

    Google Apps for Business

    SGD $45.00

    Course Description

    Whether you are a business owner, personal google apps user, or google apps administrator, this VTC Google Apps for Business course has been designed to take you from a beginner to an advanced user in no time at all. It will cover each Google App in detail including lots of great functionality that will impress your friends, family, and co-workers. You can easily jump to sections of the course that are relevant to you, including Google Apps Setup, Gmail, Contacts, Tasks, Calendar, Groups, and Drive. Drive is really where cloud computing comes to life; Documents, Spreadsheets, Presentations, and Forms each get their own chapter because their functionality is so rich. This phenomenal course is packed to brim with goodness and draws upon Andrew Martin's many years of experience working with and teaching Google Apps. Get ready to transform your way of working while you bring collaboration and efficiency to your project or company. TKnow all about Google's Apps with this course!- Learn about the different applications in Google - Understand how the different applications function- Learn about the features and functions of Google Apps - Know how to make full use out of the features 

    Read more...

  • An Essential Online Course: Advanced Microsoft Excel Course (PC: 2013, 2007/2010, 2016)

    An Essential Online Course: Advanced Microsoft Excel Course (PC: 2013, 2007/2010, 2016)

    SGD $79.60

    Course Description

    Microsoft Excel is a spreadsheet developed by Microsoft for Windows, Mac OS X, Android and iOS. It features calculation, graphing tools, pivot tables, and a macro programming language called Visual Basic for Applications. It has been a very widely applied spreadsheet for these platforms, especially since version 5 in 1993, and it has replaced Lotus 1-2-3 as the industry standard for spreadsheets. Excel forms part of Microsoft Office. Demystify some of the most complex business relevant areas of Microsoft Excel. With 160 videos and loads of practice exercises you will be able to use the most hard to grasp Excel functions in no time.  Grasp this chance to immerse in the knowledge of Advanced Microsoft Excel  - Further your knowledge in Microsoft Excel  - Learn about advanced steps and functions that you have yet to find out - Gain an advantage when presenting your next spreadsheet  - Be equipped with an extra set of skills in Microsoft Excel  Training for Advanced Excel (PC version:2013, 2007/2010, 2016) This course is Skillsfuture Credit Eligible.

    Read more...

  • Avid Pro Tools 10: Know how to work with audio

    Avid Pro Tools 10: Know how to work with audio

    SGD $49.00

    Course Description

    VTC's Avid Pro Tools 10 course introduces the new features in this latest release of the audio recording and music production powerhouse. From clip gain and disk caching to new plug-ins and workflows, this version of ProTools is both powerful and exciting. Sam McGuire covers these new features and also explores many of the traditional features using real world examples and practical demonstrations. Whether you are a novice or a seasoned professional, you will find this course both insightful and entertaining.Learn how to work with audio files using Avid Pro Tools. - Know how Avid Pro Tools handles audio - Learn how to edit your own audio files with Avid Pro Tools- Discover the potential of Avid Pro Tools with your audio files- Master audio editing with all the right tools and techniques in Avid Pro ToolsThis 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.