Instructor Led Pivot Tables Training - Training Resources
Pivot Tables Training Provider? - Tell us about your Training!
Please select the location nearest to you:
India
United Kingdom
United Arab Emirates
Canada
United States
From iWare Logic
Oracle BI Presentation Services 10g Create ReportsDashboards
...xity to the Dashboard as the course progresses, including pivot tables, charts, prompts, embedded content, and navigation links. Utilize OracleBI Delivers in sending real-time, personalized alerts via intelligence agents (iBots) to Interactive Dashboards for subscribed users.
In addition to building Dashboards, students learn to perform administration tasks related to configuring and
more...
From Mullan Training
Advanced MS Excel (1 & 2 Days)


Our 1 or 2 day Microsoft Excel Intermediate / Advanced course is suitable for those with a sound working knowledge of Excel who wish to progress to the most complicated functions and features.
PREREQUISITES
A working knowledge of Excel or our Introduction to MS Excel course.
BENEFITS
At the end of this course you will have a complete understanding of the higher functions of Excel.
You
more...
From Meirc Training and Consulting
Mastering Business and Financial Modeling - Abu Dhabi Dubai




By the end of the program, participants will be able to:
Use Microsoft Excel in business finance more effectively.
Perform analysis and evaluation to assist in enhancing the decision making process.
Understand and create pivot tables and pivot charts.
Analyze business data in no time.
Prepare business and flash reports to senior management.
more...
Mastering Business and Financial Modeling using Excel
' This program is designed for Business analysts and professionals, supervisors and staff from any function including finance who need to improve their understanding and use of Microsoft Excel as an important tool to produce more effective and efficient work. This program is worth 25 NASBA CPE?s. Note: This is a hands-on training program using Laptops/Computers. Use Microsoft Excel in
more...
Mastering Business and Financial Modeling using Excel
This program is designed for Business analysts and professionals, supervisors and staff from any function including finance who need to improve their understanding and use of Microsoft Excel as an important tool to produce more effective and efficient work. This program is worth 25 NASBA CPE s.Note: This is a hands-on training program using Laptops/Computers.Use Microsoft Excel in business finance
more...
Mastering Business and Financial Modeling using Excel
This program is designed for Business analysts and professionals, supervisors and staff from any function including finance who need to improve their understanding and use of Microsoft Excel as an important tool to produce more effective and efficient work. This program is worth 25 NASBA CPE s.Note: This is a hands-on training program using Laptops/Computers.Use Microsoft Excel in business finance
more...
From ibruk Consulting Pvt Ltd
Mastering Microsoft Excel
Microsoft Excel is a powerful spreadsheet application with features that enable computation, graphical representation and analysis of data. It has many features that can make life easier for people who deal in numbers on an everyday basis.
Also, with Microsoft Office 2007, there is a new way of working in Microsoft Office. ibruk consulting's Mastering Microsoft Excel training program helps your
more...
From Last Minute Training
Microsoft Excel Level 3 Advanced - ctc
This course will consist of the following lessons:
Outlining And Grouping Your Data
Pivot tables
Exploring Scenarios
What If Analysis
Excel And Hyperlinks
Excel Workbooks As Web Pages
Creating And Using Shared Workbooks
and more!
more...
Microsoft Excel 2003 Advanced - tplanit
Level 3. This course provides competency in Outlining and Grouping Data, Pivot Tables, Excel Workbooks as Web Pages, Creating and Using Workbooks, Visual Basic and Macros, Advanced File Management and Security.
more...
Microsoft Excel 2007 Pivot Tables and Data List Management
Learn how to add, edit, search for, & delete records in a data list using a form. How to sort data in a data list, creating & working with subtotaled lists, using various database functions to summarize data,
creating &working with pivot tables & charts
more...
Excel Upgrade to 2007 - 1 Day
Topics include: the brand new user-interface, changes in spreadsheet limits, themes and styles, conditional formatting, improved formula writing, improved sorting and filtering, table enhancements, the new look of charts, improved pivot tables and more
more...
Microsoft Excel 2007 Level 3 - On Track
* Create and modify Pivot Tables
* Create and modify macros
* Create and modify outlines
* Use advanced functions
* Trace Dependents and Precedents
* Create and modify scenarios
more...
Microsoft Excel 2003 Pivot Tables and Data List Management - uofa
Learn how to add, edit, search for, & delete records in a data list using a form. How to sort data in a data list, creating &working with subtotaled lists, using various database functions to summarize data, creating &working with pivot tables & charts.
more...
Microsoft Excel 2003 Advanced - Option 1 FRENCH
Upon completion of the course, you will be able to work with Outlines, Subtotals, Data Forms and Autofilter. You will also be comfortable using Pivot Tables and Charts as well as importing and exporting data.
more...
Excel 2003 Advanced Level 1 1 Day -computer help
This course looks at some of the advanced features in Excel that assist in the summarizing of large spreadsheets. Topics covered will help to make sense out of the data & allow for the creation of sophisticated summary reports. (Pivot Tables)
more...
Microsoft Excel 2007 Advanced FRENCH
Upon completion of the course, you will be able to work with Outlines, Subtotals, Data Forms and Autofilter. You will also be comfortable using Pivot Tables and Charts as well as importing and exporting data.
more...
Microsoft Excel 2007 Advanced - compuease
Upon completion of the course, you will be able to work with Outlines, Subtotals, Data Forms and Autofilter. You will also be comfortable using Pivot Tables and Charts as well as importing and exporting data.
more...
Microsoft Excel 2007 Level 3 Data List Management-Nexient
Upon completion participants will be able to accomplish the following: Add, edit, search for, and delete records;using a form; look up data, sort records; filter data; Create and work with subtotalled lists; pivot tables and Pivot Charts; Import data;
more...
Microsoft Excel 2007 Level 3 Data List Management- Nexient
Upon completion participants will be able to accomplish the following: Add, edit, search for, and delete records;using a form; look up data, sort records; filter data; Create and work with subtotalled lists; pivot tables and Pivot Charts; Import data;
more...
MS Excel 2000 2003 Level 3 Data List Management- Nexient
This course is intended for participants who are familiar with Excel 2000/ 2002/ 2003. Course Outline includes : Maintaining data lists, sorting & filtering lists, summarizing data, pivot tables, use of MS Query to retrieve data & other supplemental topics.
more...
Microsoft Excel 2000 2003 Level 3 Data List Management- Nexient
This course is intended for participants who are familiar with Excel 2000-2003. Course Outline includes : Maintaining data lists, sorting & filtering lists, summarizing data, pivot tables, use of MS Query to retrieve data & other supplemental topics.
more...
Microsoft Excel 2007 Level 3 Data List Management
Upon completion participants will be able to accomplish the following: Add, edit, search for, and delete records;using a form; look up data, sort records; filter data; Create and work with subtotalled lists; pivot tables and Pivot Charts; Import data;
more...
Excel 2003 Advanced-Last Minute Training
Topics include: templates, forms, sharing workbooks and tracking changes, customizing excel, numeric formats (including custom numeric formats), advanced filter, scenarios, pivot tables, group & outline & subtotals, and importing & exporting data.
more...
Microsoft Excel 20022003 Level 3
This 1 day course topics are : pivot tables, macros, outlines, Excel functions, auditing, what-if analysis and more.
more...
Excel 2007 Upgrade 1 Day
This course is a must if you want to get up to speed quickly with the many changes and improvements in Excel version 2007. Topics include: the brand new user-interface, changes in spreadsheet limits, themes and styles, conditional formatting, improved formula writing, improved sorting and filtering, table enhancements, the new look of charts, improved pivot tables, new file formats, changes in
more...
Excel 2003 Analyzing Summarizing Data with Pivot Tables
Do you want learn why and when you can use a pivot table or pivot chart to analyze and summarize data. This workout covers creating and modifying pivot tables, filtering and formatting data, customizing pivot table options, and creating pivot charts.
more...
Excel 2007 Analyzing and Summarizing Data with Pivot Tables
Do you need to analyze data? Learn why and when you can use a pivot table or pivot chart to analyze and summarize data. This workout covers creating and modifying pivot tables, filtering and formatting data, customizing pivot table options, and creating pivot charts.
more...
Microsoft Excel Advanced Option 2
Upon completion of the course, you will be able to work with Outlines, Subtotals, Data
Forms and Autofilter. You will also be comfortable using Pivot Tables and Charts as
well as importing and exporting data.
more...
Microsoft Excel Advanced

Upon completion of the course, you will be able to work with Outlines, Subtotals, Data Forms and Autofilter. You will also be comfortable using Pivot Tables and Charts as well as importing and exporting data.
more...
Microsoft Excel XP 2003 Level 3
After you complete this course you will be able to do the following:
* Create and modify Pivot Tables
* Create and modify macros
* Create and modify outlines
* Use advanced functions
* Trace Dependents and Precedents
* Create and modify scenarios
more...
WordPerfect Training - Intermediate Level
Upon completion of the course, you will be able to work with Outlines, Subtotals, Data Forms and Autofilter. You will also be comfortable using Pivot Tables and Charts as well as importing and exporting data.
more...
Microsoft Excel 2003 - level 3

This courseware is a continuation of the Microsoft Excel level 2, in which students gained more knowledge as a proficient user of Excel. You will begin with a review of these intermediate subject areas and then move to more advanced topics with Excel. In this session you will:
* Create data maps
* Create and use a database
* Create and use Pivot Tables
* Create and run
more...
Microsoft Excel Advanced (Option 1) - French Instruction English Software
Location: Ottawa Date: 2008-05-16
List Price: $235 Offered Price: $188.00
Seats Available: 2
Upon completion of the course, you will be able to work with Outlines, Subtotals, Data Forms and Autofilter. You will also be comfortable using Pivot Tables and Charts as well as importing and exporting data.
For more information please call 1-877-313-8881 or copy this link into your browser:
more...
Microsoft Excel XP 2003 Level 3
Location: Vancouver Date: 2008-04-28
List Price: $229 Offered Price: $160.00
Seats Available: 2
After you complete this course you will be able to do the following:
* Create and modify Pivot Tables
* Create and modify macros
* Create and modify outlines
* Use advanced functions
* Trace Dependents and Precedents
* Create and modify scenarios
For more information please
more...
Microsoft Excel - Advanced Level
Location: Ottawa Date: 2008-04-15
List Price: $235 Offered Price: $188.00
Seats Available: 2
Upon completion of the course, you will be able to work with Outlines, Subtotals, Data Forms and Autofilter. You will also be comfortable using Pivot Tables and Charts as well as importing and exporting data.
For more information please call 1-877-313-8881 or copy this link into your browser:
more...
Microsoft Excel Advanced (French Instruction, English Software)
Location: Ottawa Date: 2008-03-20
List Price: $235 Offered Price: $188.00
Seats Available: 2
Upon completion of the course, you will be able to work with Outlines, Subtotals, Data Forms and Autofilter. You will also be comfortable using Pivot Tables and Charts as well as importing and exporting data. Receive a certificate of completion at the end of this course.
For more information please call
more...
Microsoft Excel XP 2003 Level 3
...ill be able to do the following:
* Create and modify Pivot Tables
* Create and modify macros
* Create and modify outlines
* Use advanced functions
* Trace Dependents and Precedents
* Create and modify scenarios
You will also receive a Certificate of Completion.
For more information please call 1-877-313-8881 or copy this link into your browser:
more...
Microsoft Excel 2003 Level 3

... Price: $160.00
Seats Available: 1
Outline
Section 1 - Pivot Tables
What is a Pivot Table?
Creating a Simple Pivot Table
Changing the Layout of a Pivot Table
Creating a Spreadsheet for each Page of thePivot Table
Multiple Field Headings on Page Axis
Refreshing a Pivot Table
Structured Selection
Formatting a Pivot Table
Adding or Removing Fields
Renaming Fields
Sorting Field Items
more...
Microsoft Excel 2003 Level 3
... Offered Price: $160.00
Seats Available: 2
Section 1 - Pivot Tables
What is a Pivot Table?
Creating a Simple Pivot Table
Changing the Layout of a Pivot Table
Creating a Spreadsheet for each Page of thePivot Table
Multiple Field Headings on Page Axis
Refreshing a Pivot Table
Structured Selection
Formatting a Pivot Table
Adding or Removing Fields
Renaming Fields
Sorting Field Items
more...
From Act Training
Excel Level 3
Advanced level one day hands-on instructor led course on Microsoft Excel. Topics include: Customizing the Work Area; Advanced Formula Construction; Using Pivot Tables; Working with Multiple Worksheets; Consolidating and Analysing Data; Using Protection and Display Options; Introduction to Macros; Working with Interactive Excel Web Documents.
The prerequisite for this course is Excel Level 1 &
more...
From New York Interactive Media
Advanced Excel 2003 for Business
...ickly organize and analyze large amounts of raw data with Pivot Tables and Charts
* Increase your Excel knowledge with efficiency techniques, advanced formulas and collaborating techniques.
Examples of people who will benefit greatly from this class:
* Those working with databases
* Those who have been working with Excel and would like to cut out hours of work from their
more...
From GetOpenOffice.org
OpenOffice.org and StarOffice Comprehensive Calc


...e covering advanced Calc topics such as charts, formulas, pivot tables, calculations, equations, scenarios, and other advanced topics. Available at your site.
For information on training and prices, see www.getopenoffice.org/training.html
The Comprehensive Calc workbook is used for this course; see the table of contents at www.getopenoffice.org/workbooks.html To order the workbook
more...
From NobleProg - IT training courses
Excel 2007 Advanced Training Course




By the end of this course you will have a complete understanding of the higher functions of Excel. You will be able to perform very advanced calculations and functions, manipulate data using pivot tables and 'advanced' analysis, record macros and integrate with other office applications.
more...
From Microcomputing Solutions ltd
Advanced Microsoft Excel
...4 Using Lists
a Advanced Sorting & Data Filtering
a Pivot Tables
a Database Functions
5 More about Worksheets
a Worksheet Auditing
a Using Views
a Scenarios & Report Manager
a Designing Data Entry Forms
6 Advanced Charting
a Understanding a Data Series
a Chart Options
a Types of Chart a Doughnuts, Radar, Surface & Bubble
a Advanced Formatting
7
more...
From 2e2
Microsoft Excel Advanced
...lysis; and use custom scenarios, advance custom views and pivot tables to manage large worksheets. Run and record macros to automate complex or repetitive tasks. Publish a worksheet as an interactive Web page. Apply financial formulas and array formulas in Data Tables to determine outcomes.
Prerequisites: This course is designed for students who have completed the Excel Intermediate or have
more...
From Computer Training Source, Inc.
Microsoft Excel Intermediate
... features, create your own template, and learn how to use pivot tables. Using advanced functions in formulas will also be practiced. Our classes are all instructor-led, hands-on learning. Each student has their own computer and is given a student manual with practice files to take home. A free repeat, within six months, is included as well as thirty days of technical support.Class is usually
more...
From Applied Office
Microsoft Excel 2003 - Pivot Tables



...pivot tables to quickly summarize thousands of records in just a few clicks. The Pivot Table feature sorts, counts, and totals data and lets users quickly review that data in a variety of ways. Participants will be able to turn a long list of payroll transactions or scientific data into something useful. Basic experience with Excel is expected.
~~~~~~~~~~~~~~~~~~
About the Location
more...
From ExcelTech Consultant
Advance Excel

This is a 100% practical workshop, which gives you 14 hours of on-hand experience of Advance Excel functions and its applications. Key contents of this workshop would be;
1. Conditional Formatting
2. Lookup functions
3. Array functions
4. Database functions
5. Error Handling Processes
6. Charts and Pivot Tables
7. Shortcut Keys for quick working and many more things, which will help you to
more...
