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

  • Cubase 8

    Cubase 8

    SGD $45.00

    Course Description

    Steinberg's Cubase Elements 8 is their entry level, professional digital audio workstation. It contains all the aspiring musician and mix engineer requires to get started with audio and midi recording compositions. This VTC course covers installation issues and preference setting before moving on to connecting the program to a relevant soundcard. As the course progresses, functions such as creating busses and the implementation of the inspector are looked at prior to focusing on building a project.Learn how to work with audio files with Cubase 8. - Know how Cubase 8 handles audio files- Learn how to edit your own audio files with Cubase 8- Discover the potential of Cubase 8 with your audio files- Master audio editing with all the right tools and techniques in Cubase 8

    Read more...

  • Microsoft Word 2013

    Microsoft Word 2013

    SGD $49.00

    Course Description

    In this VTC course, students will learn how to work with basic to advanced functions of Microsoft Word 2013. This efficient word processing program allows you to edit text, graphics, tables, page layouts, styles, and more. Intermediate to advanced users will learn how to complete a mail merge, use screenshots or clippings, implement hyperlinks, set up collaboration, create a table of contents, and utilize macros. Microsoft Word even provides connected services so users can utilize social media networks within files. Word is part of the cloud, SkyDrive, which allows everyone to utilize remote access anywhere, anytime. 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...

  • Audio Mixing Essentials

    Audio Mixing Essentials

    SGD $54.00

    Course Description

    VTC's Audio Mixing Essentials is an advanced course on the often mysterious art of audio mixing. Instead of showing you how to open an equalizer plug-in in a specific program, this tutorial will show you how to use an equalizer (in any program) in order to improve the sound of your next mix. This course first discusses the mixing process and then uses two mixing examples to demonstrate mixing from start to finish (“This Too Shall Pass” by Mile High Chapter and “Night Train To Cairo” by Scot). The mixing of the second project is done in work files and referenced in the course so that they have no narration in order to place more attention on the audio adjustments being made. This course will give any novice recording engineer the tools, techniques, and knowledge to effectively mix professional sounding projects. Master the mysterious art of audio mixing.  - Learn the tools and techniques of audio mixing - Know what to use to produce good audio  - Discover the secrets of producing a quality audio  - Learn the ropes of creating your own master piece with this course  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.