Instructor Led Pivottables Training

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

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

Microsoft Excel - Advanced ... 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. Finally, students will learn about the analytical features of Excel (such as Goal Seek and Solver), running and recording macros, and sharing Excel data via the Web. Learning Objectives: Designated as Approved Courseware for the  more...

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

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

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

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

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

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

Microsoft Excel 2000 XP 2003 Level 3 Advanced This course will consist of: Outlining And Grouping Your Data, Pivottables, Excel And Hyperlinks, Workbooks As Web Pages, Creating And Using Shared Workbooks, Visual Basic And Macros, Excel Security.  more...