Excel Pivot Tables

excel-2013
  • Category : Microsoft Office
  • Course Name : Excel Pivot Tables
  • Instruction Language : English
  • No. of Courses : 1
  • No. of Lessons : 13
  • Price : R725 (USD $49)

Excel Pivot Tables

In the course MS Excel Pivot Tables: Expert Tools, you will familiarise yourself with a variety of highly specific tools available in Excel. You will examine advanced functions and filtering, including the usage of pivot tables. You will learn to perform what-if analysis of data and create forms in worksheets. You will also get familiarized with the use of Microsoft Query and the XML format when processing a larger amount of data.

Lessons:

  • Criteria table and advanced filter
  • Database functions
  • Pivot table
  • Editing pivot tables and charts
  • Form creation in a sheet
  • Calculation criteria in database functions
  • Using functions for searching in tables
  • Work with Microsoft Query
  • Complicated queries in Microsoft Query
  • Sheet scenarios
  • Resolver
  • Introduction to XML
  • Working with data in the XML format

College Africa Group is the African Continent’s authorised partner for Gopas. GOPAS is one of the major IT training providers. Its technical courses are annually attended by almost 30,000 students, mostly IT specialists.


System Requirements

The courses have been developed using Flash technology. For this reason the minimum system requirements for a user PC are very low:

  • Any of following internet browsers: Internet Explorer 8.0 or higher, Opera, Mozilla Firefox, Chrome; all with the Adobe Flash plug-in version 8.0 or higher
  • 1 GHz CPU; 512 MB RAM; OS Windows XP or higher
  • Display resolution of 1280 x 1024
  • Sound card, speakers or headphones are recommended

System Requirements For Using LMS

  • Processor: 1 GHz or higher
  • Memory: 512 MB RAM
  • Display resolution 1280 × 1024 or higher
  • Any of following internet browsers: Internet Explorer 8.0 or higher, Opera, Mozilla Firefox, Chrome; all with the Adobe Flash plug-in version 8.0 or higher
  • Operating system for online or internal LMS use: Windows XP or higher or Mac OS (+ Opera browser)
  • Sound card and speakers/headphones are recommended

MS Office 2013

Download TOC for Excel Pivot Tables