Instructor Led Pivottables Training - Training Resources

MS Excel 2007 Level 3 Training Seminar This course is designed for students desiring to gain the skills necessary to create macros, collaborate with others, audit and analyze worksheet data, create PivotTables and PivotCharts, incorporate multiple data sources and import and export data.  more...

MS Excel 2003 Level 2 - 1 Day HBI Description: Upon successful completion of this course, students will be able to: calculate with advanced formulas. organize worksheet and table data using various techniques. create and modify charts. analyze data using PivotTables and PivotCharts. insert graphic objects. customize and enhance workbooks and the Microsoft Office Excel environment.  more...

Microsoft Excel 2000 2003 Level 3 Data List Management - nexient Who should attend? This course is intended for participants who are familiar with Excel 2000/ 2002/ 2003. Performance Objectives Upon completion of the course, participants will be able to accomplish the following: Add, edit, search for, and delete records in a data list using a form, look up data Sort records in a data list using a variety of methods Filter data in a list using a  more...

Excel 2003 - Level 3 ...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...

Excel Datalist Management 2007 Upon completion of the course, participants will be able to accomplish the following: * Add, edit, search for, and delete records in a data list using a form, as well as look up data * Sort records in a data list using a variety of methods * Filter data in a list using a variety of methods, as well as work with filtered data * Create and work with subtotalled lists, as well  more...

MS Excel 2003 - Level 3 Training Seminar - HBI This course is designed for students desiring to gain the skills necessary to create macros, collaborate with others, audit and analyze worksheet data, create PivotTables and PivotCharts, incorporate multiple data sources and import and export data.  more...

MS Excel 2003 Level 3 Training Seminar This course is designed for students desiring to gain the skills necessary to create macros, collaborate with others, audit and analyze worksheet data, create PivotTables and PivotCharts, incorporate multiple data sources and import and export data.  more...

Excel Datalist Management Upon completion of the course, participants will be able to accomplish the following: * Add, edit, search for, and delete records in a data list using a form, as well as look up data * Sort records in a data list using a variety of methods * Filter data in a list using a variety of methods, as well as work with filtered data * Create and work with subtotalled lists, as well  more...

Excel Advanced - Level 3 This course provides competency in validating data, creating and modifying list ranges, sorting database data, using database functions, using the Advanced Filter and Automatic Subtotal features, creating and modifying PivotTables and Pivot Charts, formatting and adjusting PivotTables, auditing worksheets, performing what-if analyses, and working with scenarios.  more...

Microsoft Excel2003 - Level 3 This course is designed for students desiring to gain the skills necessary to create macros, collaborate with others, audit and analyze worksheet data, create PivotTables and PivotCharts, incorporate multiple data sources, and import and export data. Upon successful completion of this course, students will be able to: * Customize workbooks. * Collaborate with others using workbooks.  more...

Microsoft Excel 2007 Level 2 (1 Day) Location: Vancouver Date: 2008-03-27 List Price: $199 Offered Price: $159.00 Seats Available: 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  more...

Microsoft Excel 2003 Level 4 - Bilingual Location: Ottawa Date: 2008-01-29 List Price: $300 Offered Price: $210.00 Seats Available: 1 Module 0: Working with Data Series Module 1: Using Advanced Functions Module 2: Using Scenarios and Goal Seeking Module 3: Using Data Tables Module 4: Using Auditing Tools Module 5: Consolidating Worksheets Module 6: Solving Problems Module 7: Working With Views Module 8: Using Macros Module 9:  more...

MS Excel 2003 Level 3 Training Seminar Location: City of Mississauga Date: 2007-06-21 List Price: $245 Offered Price: $171.00 Seats Available: 2 This course is designed for students desiring to gain the skills necessary to create macros, collaborate with others, audit and analyze worksheet data, create PivotTables and PivotCharts, incorporate multiple data sources and import and export data.  more...

MS Excel 2003 Level 3 Training Seminar Location: City of Mississauga Date: 2007-04-19 List Price: $245 Offered Price: $171.00 Seats Available: 2 This course is designed for students desiring to gain the skills necessary to create macros, collaborate with others, audit and analyze worksheet data, create PivotTables and PivotCharts, incorporate multiple data sources and import and export data.  more...

Customized Microsoft Excel Training in Toronto ...th others * Audit and analyze worksheet data * Create PivotTables and PivotCharts * Incorporate multiple data sources * Import and export data. Upon enrolment in our Customized Excel Training, you will receive free skills assessments that will identify which of the following areas are needed and you desire in your personal learning plan, so that you only cover that which you do not  more...

Get on Track with MS Access Intermediate Students will learn how to set table relationships, work with Lookup fields and subdatasheets, create join queries, create PivotTables and PivotCharts, and use hyperlink fields and data access pages.  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...

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 filtering,  more...

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...