Instructor Led Pivottable Training - Training Resources
Pivottable Training Provider? - Tell us about your Training!
Please select the location nearest to you:
United Kingdom
India
United States
South Africa
Singapore
 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 Mullan Training
VB Access
...tion
working with forms and controls
working with the PivotTable object.
Debugging code
handling errors to ensure minimal downtime while building and effecting the program.
COURSE CONTENT
The VBA Programming Environment
When to use Visual Basic for Applications instead of Macros
Visual Basic for Applications Development Environment
Programming in the VBA Language Code
more...
...tion
working with forms and controls
working with the PivotTable object.
Debugging code
handling errors to ensure minimal downtime while building and effecting the program.
COURSE CONTENT
The VBA Programming Environment
When to use Visual Basic for Applications instead of Macros
Visual Basic for Applications Development Environment
Programming in the VBA Language Code
more...
VB Excel
...tion
working with forms and controls
working with the PivotTable object.
debugging code & handling errors to ensure minimal downtime while building and effecting the program.
COURSE CONTENT
Introduction
What is a Macro
Recording a Macro
Running a Macro
Relative References
Assigning Macros to Buttons and Objects
Assigning a Macro to a Button on a Sheet
Assigning
more...
...tion
working with forms and controls
working with the PivotTable object.
debugging code & handling errors to ensure minimal downtime while building and effecting the program.
COURSE CONTENT
Introduction
What is a Macro
Recording a Macro
Running a Macro
Relative References
Assigning Macros to Buttons and Objects
Assigning a Macro to a Button on a Sheet
Assigning
more...
Introduction To MS Frontpage
...abase Results Wizard
Components
- Office spreadsheet/ PivotTable/ chart
- Banner ad manager
- Hit counter
- Hover button
- Marquee
- Include page
- Scheduled picture/ include page
- Search form
- Table of contents
Various
- Check In/ Out Files
- Line Breaks
- Tools Spell Check, Replace, Etc
- Active Elements (Hover Button, Marquee, Etc)
- Create And Use Templates
- Use of Macros
more...
...abase Results Wizard
Components
- Office spreadsheet/ PivotTable/ chart
- Banner ad manager
- Hit counter
- Hover button
- Marquee
- Include page
- Scheduled picture/ include page
- Search form
- Table of contents
Various
- Check In/ Out Files
- Line Breaks
- Tools Spell Check, Replace, Etc
- Active Elements (Hover Button, Marquee, Etc)
- Create And Use Templates
- Use of Macros
more...
From Trainers 'n' Mentors
MS Project
...ts and diagrams
The Visual Reports feature can produce PivotTable views, charts, graphs, and diagrams based on Project data.
Add visual highlights
You can change the background color of a cell or row with Background Cell Highlighting.
Use improved views
With new enhancements to the Calendar interface and the addition of 3-D Gantt bars, you can create even more visually
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 NetLearn
Excel 2007 basic - advanced
...dation
Topic B: Exploring database functions
Unit 4: PivotTables and PivotCharts
Topic A: Working with PivotTables
A-1: Creating a PivotTable
A-2: Adding fields to a PivotTable
Topic B: Rearranging PivotTables
B-1: Moving fields
B-2: Hiding and showing details
B-3: Refreshing the data in a PivotTable
Topic C: Formatting PivotTables
C-1: Formatting by using a Pivot
more...
...dation
Topic B: Exploring database functions
Unit 4: PivotTables and PivotCharts
Topic A: Working with PivotTables
A-1: Creating a PivotTable
A-2: Adding fields to a PivotTable
Topic B: Rearranging PivotTables
B-1: Moving fields
B-2: Hiding and showing details
B-3: Refreshing the data in a PivotTable
Topic C: Formatting PivotTables
C-1: Formatting by using a Pivot
more...
From Intellisoft Systems
Advanced Microsoft Excel
...larity
Advanced Excel Lesson 5:
Analyzing Data Using PivotTables and PivotCharts
Create a PivotTable Report
Analyze Data Using PivotCharts
Day 2
Advanced Excel Lesson 6:
Streamlining Workflow
Create a Macro
Edit a Macro
Apply Conditional Formatting in Excel
Add Data Validation Criteria
Update a Workbook's Properties
Modify Excel's Default Settings
Advanced Excel Lesson
more...
From Boston University Corporate Education Center
Access 2003 Level III
...: Summarize Data with a Crosstab Query Topic 2D: Create a PivotTable and a PivotChart Topic 2E: Display a Graphical Summary on a Form
Lesson 3: Simplifying Tasks with Macros
Topic 3A: Create a Macro Topic 3B: Attach a Macro to a Command Button Topic 3C: Restrict Records Using a Where Condition
Lesson 4: Adding Interaction and Automation with Macros
Topic 4A: Require Data Entry with
more...
...: Summarize Data with a Crosstab Query Topic 2D: Create a PivotTable and a PivotChart Topic 2E: Display a Graphical Summary on a Form
Lesson 3: Simplifying Tasks with Macros
Topic 3A: Create a Macro Topic 3B: Attach a Macro to a Command Button Topic 3C: Restrict Records Using a Where Condition
Lesson 4: Adding Interaction and Automation with Macros
Topic 4A: Require Data Entry with
more...
From The Career Center
Access VBA Programming
Your training in and experience with Microsoft Access has provided you with a solid
foundation for working with this database software. In the previous course in this series,
you began to implement some of the more specialized and advanced capabilities that Access
offers. You are now ready to extend your knowledge base beyond the user level and into
introductory-level administrator skill sets. You
more...
Your training in and experience with Microsoft Access has provided you with a solid
foundation for working with this database software. In the previous course in this series,
you began to implement some of the more specialized and advanced capabilities that Access
offers. You are now ready to extend your knowledge base beyond the user level and into
introductory-level administrator skill sets. You
more...
