Instructor Led Pivottables Training in United States
Pivottables Training Provider? - Tell us about your Training!
Please select the location nearest to you:
New York
Kansas
Washington
Ohio
Illinois
North Carolina
Maryland
Massachusetts
 online course |
 instructor-led class |
 learn at home |
 group study |
 self-directed study |
 cd-based training |
 DVD video training |
 printed book |
 e-book digital book |
 workshop seminar |
 train the trainer |
 computer-based learning |
 discount pricing |
 online tutorial |
From The Career Center
Microsoft Excel 2007 New Features
You have worked with Microsoft Office Excel 2003, and you now need to be aware of the additional features in the latest release of the software for improving the management, presentation, and distribution of your spreadsheets. In this course, you will work with the new and enhanced features in Microsoft Office Excel 2007. Objectives: You will be introduced to the new features in Microsoft
more...
Microsoft Excel 2007 New Features
You have worked with Microsoft Office Excel 2003, and you now need to be aware of the additional features in the latest release of the software for improving the management, presentation, and distribution of your spreadsheets. In this course, you will work with the new and enhanced features in Microsoft Office Excel 2007. Objectives: You will be introduced to the new features in Microsoft
more...
Microsoft Excel 2007 Level 2
In Microsoft Office Excel 2007: Level 1, you created, edited, formatted, and printed basic spreadsheets. You now have a need to streamline repetitive tasks and display spreadsheet data in more visually effective ways. In this course, you will use Microsoft Office Excel 2007 to streamline and enhance your spreadsheets with templates, charts, graphics, and formulas. Course Objectives You will
more...
In Microsoft Office Excel 2007: Level 1, you created, edited, formatted, and printed basic spreadsheets. You now have a need to streamline repetitive tasks and display spreadsheet data in more visually effective ways. In this course, you will use Microsoft Office Excel 2007 to streamline and enhance your spreadsheets with templates, charts, graphics, and formulas. Course Objectives You will
more...
Microsoft Excel Pivot Tables
You will create and analyze PivotTable data. Target Student: This course is meant for people with a sound working knowledge of Microsoft Excel and general computer proficiency. Upon successful completion of this course, students will be able to: build a PivotTable analyze data using PivotTables present PivotTable data visually
more...
You will create and analyze PivotTable data. Target Student: This course is meant for people with a sound working knowledge of Microsoft Excel and general computer proficiency. Upon successful completion of this course, students will be able to: build a PivotTable analyze data using PivotTables present PivotTable data visually
more...
Microsoft Office Excel 2010 Transition from MS Excel 2003
This course is designed for experienced Excel users who have worked with earlier versions of Microsoft Office Excel, ideally Microsoft Office Excel 2003, and who are planning to upgrade to Microsoft Office Excel 2010. Course Objective: You will use the new and enhanced features in Microsoft Office Excel 2010. Upon successful completion of this course, students will be able to: identify the
more...
This course is designed for experienced Excel users who have worked with earlier versions of Microsoft Office Excel, ideally Microsoft Office Excel 2003, and who are planning to upgrade to Microsoft Office Excel 2010. Course Objective: You will use the new and enhanced features in Microsoft Office Excel 2010. Upon successful completion of this course, students will be able to: identify the
more...
Microsoft Excel Level 2 2010
...functions and formulas, sorting and filtering data, using PivotTables and PivotCharts for analyzing data, and customizing workbooks. Course Objective: You will use advanced formulas and work with various tools to analyze data in spreadsheets. You will also organize table data, present data as charts, and enhance the look and appeal of workbooks by adding graphical objects. Upon successful
more...
...functions and formulas, sorting and filtering data, using PivotTables and PivotCharts for analyzing data, and customizing workbooks. Course Objective: You will use advanced formulas and work with various tools to analyze data in spreadsheets. You will also organize table data, present data as charts, and enhance the look and appeal of workbooks by adding graphical objects. Upon successful
more...
Excel Expert Level
This course is the second in a three-course series that satisfies the requirements for the
Microsoft Office User Specialist (MOUS) certification. This course will expand upon the skills
you learned in the Excel 2002 Level 1 course and give you an opportunity to work with some
more advanced features of Excel, including templates; sorting and filtering; importing and
exporting; advanced formulas;
more...
This course is the second in a three-course series that satisfies the requirements for the
Microsoft Office User Specialist (MOUS) certification. This course will expand upon the skills
you learned in the Excel 2002 Level 1 course and give you an opportunity to work with some
more advanced features of Excel, including templates; sorting and filtering; importing and
exporting; advanced formulas;
more...
From Maverick Enterprises
Dive Into Microsoft Excel Worksheet Intermediate
Editing a Spreadsheet
Tips, Tricks and Shortcuts
Enter and format your data, and write formulas
Develop Formulas using Built-in Functions
Use charts and graphs to predict trends and understand relationships
Create a template to speed up your work
Using the AutoFill and Custom Fill
Create and Edit Forms
Consolidate data from several worksheets into one
Find and organize information by
more...
Editing a Spreadsheet
Tips, Tricks and Shortcuts
Enter and format your data, and write formulas
Develop Formulas using Built-in Functions
Use charts and graphs to predict trends and understand relationships
Create a template to speed up your work
Using the AutoFill and Custom Fill
Create and Edit Forms
Consolidate data from several worksheets into one
Find and organize information by
more...
Dive Into Microsoft Excel Spreadsheets and Workbooks
Keeping track of sales figures, statistics or mortgage payments has never been easier, or more difficult. Microsoft Excel gives you the power to develop formulas using built-in functions, Use charts and graphs to predict trends and understand relationships, Consolidate data from several worksheets into one, Find and organize information by filtering, sorting, and grouping, Summarize and analyze
more...
Keeping track of sales figures, statistics or mortgage payments has never been easier, or more difficult. Microsoft Excel gives you the power to develop formulas using built-in functions, Use charts and graphs to predict trends and understand relationships, Consolidate data from several worksheets into one, Find and organize information by filtering, sorting, and grouping, Summarize and analyze
more...
From RAMCO Software Training
RAMCO Software Training
...training! Courses range from creating and modifying Excel PivotTables to creating long, complex document complete with index and table of contents. We'll show you how to create attention-getting web sites and how to deliver more dynamic presentations.
________________________________________
New Adobe classes offered!
** InDesign CS4 - setting new standards for professional layout and
more...
...training! Courses range from creating and modifying Excel PivotTables to creating long, complex document complete with index and table of contents. We'll show you how to create attention-getting web sites and how to deliver more dynamic presentations.
________________________________________
New Adobe classes offered!
** InDesign CS4 - setting new standards for professional layout and
more...
From INT Information Systems, Inc.
Mastering: Microsoft Excel PivotTables
... its most neglected. Many people have never even heard of PivotTables and those who have have often seen only the most basic features of the tool. This class devotes an entire day to exploring all of the most useful and powerful aspects of Excel's PivotTables. The class is taught as a hands-on "laboratory" lead by an experienced instructor. During class, students use a workstation to work with
more...
... its most neglected. Many people have never even heard of PivotTables and those who have have often seen only the most basic features of the tool. This class devotes an entire day to exploring all of the most useful and powerful aspects of Excel's PivotTables. The class is taught as a hands-on "laboratory" lead by an experienced instructor. During class, students use a workstation to work with
more...
From American Academy of Computer Training & Technology, Inc.
Microsoft Excel - Part III
Work with advanced formulas, as well as lookup functions such as VLOOKUP, MATCH, and INDEX. Learn about data validation and database functions such as DSUM. Work with PivotTables and PivotCharts, import and export data, and query external databases. Learn about the analytical features of Excel (such as Goal Seek and Solver), running and recording macros, and sharing Excel data via the Web.
more...
Work with advanced formulas, as well as lookup functions such as VLOOKUP, MATCH, and INDEX. Learn about data validation and database functions such as DSUM. Work with PivotTables and PivotCharts, import and export data, and query external databases. Learn about the analytical features of Excel (such as Goal Seek and Solver), running and recording macros, and sharing Excel data via the Web.
more...
From Knowledge Source Inc
Microsoft Excel 2010 Level II Intermediate
Course Objectives:
use advanced formulas.
organize worksheet and table data using various techniques.
create and modify charts.
analyze data using PivotTables, Slicers, and PivotCharts.
insert and modify graphic objects in a worksheet.
customize and enhance workbooks and the Microsoft Office Excel environment.
more...
Microsoft Excel 2007 Level III Advanced
builds on the skills and concepts taught in Excel 2007: Intermediate. Students will work with advanced formulas, as well as lookup functions such as VLOOKUP, MATCH, and INDEX. In addition, students will learn about data validation and database functions such as DSUM. They will learn how to work with PivotTables and PivotCharts, how to import and export data, and how to query external databases.
more...
Microsoft Excel 2007 Formulas Functions PivotTables for the Advanced Excel User
Take this course if you want to learn useful tools, tricks and tips for utilizing functions and formulas available in Microsoft Excel 2007. Learn which are best suited from over 300 available built-in functions. If you need to analyze large amounts of data quickly and easily, this class covers PivotTables - Excel's best resource for doing so.
more...
Office 2007- New FeaturesTarget Student This course is a high-level overview of those features of Microsoft Office 2007 that a
Target Student: This course is a high-level overview of those features of Microsoft Office 2007 that are new to the Office system - with a general overview of the most noticeable new features of each application.
When working with newly designed Office programs, it will take some getting used to at first. The menus are gone and the toolbars have been replaced with the ribbon and contextual
more...
Target Student: This course is a high-level overview of those features of Microsoft Office 2007 that are new to the Office system - with a general overview of the most noticeable new features of each application.
When working with newly designed Office programs, it will take some getting used to at first. The menus are gone and the toolbars have been replaced with the ribbon and contextual
more...
From Training-2-Go
Excel 2007 - Advanced
Advanced functions
Lookups and data tables
Advanced list management
PivotTables and PivotCharts
Exporting and importing
Analytical options
Macros and custom functions
Conditional formatting and SmartArt
more...
From Corporate Education Group
Excel 2003 Level III
...ate with others, audit and analyze worksheet data, create PivotTables and PivotCharts, incorporate multiple data sources, and import and export data. In addition, the course is also for students desiring to prepare for the Microsoft Office Specialist exam in Excel 2003 or Module 2-Key Applications of the Internet and Computing Core Certification (IC3) exam, and who already have knowledge of the
more...
...ate with others, audit and analyze worksheet data, create PivotTables and PivotCharts, incorporate multiple data sources, and import and export data. In addition, the course is also for students desiring to prepare for the Microsoft Office Specialist exam in Excel 2003 or Module 2-Key Applications of the Internet and Computing Core Certification (IC3) exam, and who already have knowledge of the
more...
