Instructor Led Microsoft Excel 2003 Training Classes

Microsoft Excel 2003 - Introduction Identify basic worksheet and workbook concepts and terms Enter & edit data Modify the worksheet Use functions to calculate and return values Format cells to enhance the appearance of your worksheet Use drawing features and other enhancements Change the page set-up to define how the printed worksheet appears This course is suitable for absolute beginners and  more...

Microsoft Excel - Intermediate Training - French Instructions, English Software Upon completion of the course, you will be familiar with the following: Advanced formulas, using range names in formulas, managing worksheets within workbooks, using advance formatting techniques, creating and printing charts as well as sorting data in alphanumeric order.  more...

Microsoft Excel - Intermediate Training Upon completion of the course, you will be familiar with the following: Advanced formulas, using range names in formulas, managing worksheets within workbooks, using advance formatting techniques, creating and printing charts as well as sorting data in alphanumeric order. This course is focused on intermediate training. It is recommended that you have basic knowledge of Excel or equivalent  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...

Microsoft Excel 2003 - Level 1 This course is designed for persons preparing for certification as a Microsoft Office Specialist in Excel, who already have knowledge of the Microsoft Office Windows 98 (or above) operating system, and who desire to gain the skills necessary to create, edit, format, and print basic Microsoft Excel 2003 worksheets. Upon successful completion of this course, students will be able to: *  more...

Excel 2003 Advanced (1 Day) The third level in the series, Excel 2003 Advanced builds on the topics learnt from Introduction and Intermediate and expands upon them. In addition to the expanded topics, there will also be new topics inside this class. The topics in this class will include: Streamlining with macros, Advanced formula creation, Customizing the work area, and much much more. Included will all courses are  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...

Excel 2003 Intermediate This course, Microsoft Excel 2003 intermediate level, builds on the introductory level course that we offer in our school. Topics will include: working with multiple sheets, more excel fundamentals, charting, database features, and much more. We also offer telephone support following the conclusion of the class.  more...

Excel 2003 - Level 3 This course was 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. 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  more...

Microsoft Excel XP 2003 Level 2 After you complete this course you will be able to do the following: * Name and Reference Cells * Protect Data * Create Links * Use Basic Excel Functions * Create Charts * Create Databases * Work with Data Series ... Participants who complete this course will receive a certificate of completion as well as a course manual ...  more...

MS Excel Level 2 Training Seminar In this course, students will streamline and enhance worksheets with templates, charts, graphics and formulas. They will receive the course materials that will be used for the course, as well as a certificate of completion at the end of the course. The course is designed so as it is more hands-on, classroom-like style.  more...

Microsoft Excel 2003 XP Level I Start with the basics, including elements of Excel screen, simple formulas (Sales-Expenses=Profit), operators: + - = / * ^, cut, copy, paste using toolbar, menu bar, mouse and keyboard, working with workbooks, worksheets, tabs, moving/ copying worksheets, formatting labels and values, AutoFormat; basic functions (SUM, AVG, MIN, MAX, NOW), printing, calculating percentages, relative/ absolute cell  more...

Microsoft Excel 2003 XP Level II Start with the basics, including elements of Excel screen, simple formulas (Sales-Expenses=Profit), operators: + - = / * ^, cut, copy, paste using toolbar, menu bar, mouse and keyboard, working with workbooks, worksheets, tabs, moving/ copying worksheets, formatting labels and values, AutoFormat; basic functions (SUM, AVG, MIN, MAX, NOW), printing, calculating percentages, relative/ absolute cell  more...

Excel 2003 Advanced 1 Day This course looks at some of the Advanced features in Excel. Topics covered will speed up repetitive actions, and further customize Excel. Prerequisites are: * Solid understanding of all Excel Introduction and Intermediate Level I topics. Knowledge of Excel Intermediate Level II topics is recommended. This course is classroom style instruction: Instructor-led, hands-on training.  more...

Excel - Functions This course looks at a variety of functions within Excel. Focus on the IF and Vlookup functions. Other functions covered are: text, statistical, mathematical, logical, financial and information. You should have an understanding of of Excel Intermediate topics with solid understanding of formulas before taking this course.  more...

Excel 2003 Introduction These courses are hands-on and designed to provide participants with a solid understanding of Microsoft Excel. Included will all courses are course notes, a pad for note taking and telephone support following the class. In the courses, participants will gain an understanding of the capabilities of Excel and how they can be applied to solve common business problems.  more...

Microsoft Excel XP 2003 Level 1 After completing this course, participants who attend this seminar will be able to: * Navigate worksheets, document windows, and the application window * Manage and manipulate Excel files * Edit data * Work with ranges * Create simple formulas * Use built-in Excel functions * Cut, copy, paste data * Format column width, row height, fonts, styles, borders  more...

Microsoft Excel 2003 Level 2 In Microsoft Office Excel 2003: 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 Excel 2003 to streamline and enhance your spreadsheets with templates, charts, graphics, and formulas. Upon successful completion of  more...

Excel 2003 Formulas (1 Day) This course is designed for Excel users who would like to learn more about creating formulas, as well as brushing up on math skills. This course is classroom style instruction: Instructor-led, hands-on training.  more...

Excel Introduction - Level 1 This course provides competency in creating workbooks, modifying worksheets, formatting worksheets and printing worksheets. This course also provides competency in creating and editing formulas, working with basic functions and the Function Wizard, applying text attributes and other formatting characteristics, creating workbooks from templates, using styles, adding worksheet backgrounds, applying  more...

MS Excel Level 1 Training Seminar 1 Day In this course, students will create basic worksheets and charts, enter text and values, work with cells, cell data and copy and move data, use formulas, functions and format worksheets, work with multiple sheets by formatting, repositioning, copying, moving, adding and deleting worksheets, create a chart and set the page display and printing options.  more...

Excel 2003 Intermediate Level 2 (1 Day) This course examines features of Microsoft Excel which assist in working with larger spreadsheets, as well as creating graphs and using drawing tools. This course is classroom style instruction: Instructor-led, hands-on training.  more...

Microsoft Excel 2003 - level 2 Microsoft Excel is a powerful spreadsheet package for working with numerical data. It easily does calculations and allows you to manipulate, track and store the data. This session is designed to give those who are already familiar with the basics of Excel the opportunity to use more advanced techniques in their spreadsheets. In this session, participants will: * apply intermediate formats  more...

Excel Intermediate - Level 2 This course provides competency in organizing and consolidating data from multiple worksheets, adjusting the screen display, working with advanced functions, using advanced formatting features, using advanced print options, filtering data, using comments, naming worksheet ranges and formulas, creating and modifying charts, protecting data, importing and exporting data, saving worksheets and  more...

Excel 2003 Intermediate Level 1 (1 Day) After learning the basics in the Introduction course, this course is an absolute must to get the most out of Excel. You will learn important features that will save you time and make you much more efficient with Microsoft Excel program. This course is classroom style instruction: Instructor-led, hands-on training.  more...

Excel 2003 - Level 1 You have basic computer skills such as using a mouse, navigating through windows, and surfing the Internet. You have also used paper-based systems to store data that you run calculations on. You now want to migrate that data to an electronic format. In this course, you will use Microsoft Office Excel 2003 to manage, edit, and print data.  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 2003 Introduction 1 Day This course introduces participants to the Microsoft Excel program. The objective is to make the student comfortable with spreadsheet concepts like columns, rows, cells, sheets, and creating formulas. At the end of the course, students can begin creating their own spreadsheets and be comfortable enough to pursue the more sophisticated topics covered in the Intermediate and Advanced courses.  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...

Excel - Formulas Provides competency in creating absolute formulas, formulas and range names, manipulating formulas, combining and splitting formulas, referencing cells on other sheets or files, auditing, goal seeking and array formulas.  more...

VBA for Excel 2003 In the previous Excel courses, you used Excel to simplify business tasks, including the creation of spreadsheets, graphs, charts, and formulas that were difficult to create and nearly impossible to maintain using pencil and paper. You now want to simplify your work in the Excel environment by automating many of the repetitive tasks that are part of spreadsheet development. In Excel 2003:  more...

Microsoft Excel 2003 Level 1 This one day Microsoft Excel Training course covers the fundamentals of what you will need to know to effectively use Microsoft 2003. Objectives Understanding the Excel Program Screen Using Menus, Toolbars and Creating a New Workbook Opening, Saving, and Manging a Workbook Moving the Cell Pointer Worksheets Entering Formulas Editing and Formatting a Worksheet Cutting, Copying, and  more...

Excel 2003 -- Level 2 In Microsoft Office Excel 2003: 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 Excel 2003 to streamline and enhance your spreadsheets with templates, charts, graphics, and formulas.  more...

Microsoft Excel - Module 2 Functions and Multiple Worksheets This course is the second of six modules (levels) that we have to offer for Microsoft Excel 2000/2002/2003... Objectives * Use labels and reference names in formulas * Use simple and complex mathematical * functions * Manage workbook worksheets * Perform calculations with references to multiple * worksheets and multiple workbooks * Summarize data with data  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...

Excel 2003 Advanced (1 Day) Location: City of Mississauga Date: 2008-05-28 List Price: $275 Offered Price: $220.00 Seats Available: 2 This course looks at some of the Advanced features in Excel. Topics covered will speed up repetitive actions, and further customize Excel. This course is classroom style instruction: Instructor-led, hands-on training. For more information please call 1-877-313-8881 or copy this link into  more...

Excel 2003 Intermediate Level 2 (1 Day) Location: Toronto Date: 2008-05-22 List Price: $275 Offered Price: $220.00 Seats Available: 2 This course examines features of Microsoft Excel which assist in working with larger spreadsheets, as well as creating graphs and using drawing tools. This course is classroom style instruction: Instructor-led, hands-on training. For more information please call 1-877-313-8881 or copy this link into  more...

Excel 2003 Intermediate Level 1 (1 Day) Location: Toronto Date: 2008-05-14 List Price: $275 Offered Price: $220.00 Seats Available: 2 After learning the basics in the Introduction course, this course is an absolute must to get the most out of Excel. You will learn important features that will save you time and make you much more efficient with the program. This course is classroom style instruction: Instructor-led, hands-on training.  more...

Microsoft Excel XP 2003 Level 2 (1 Day) Location: Vancouver Date: 2008-05-14 List Price: $199 Offered Price: $159.00 Seats Available: 2 After you complete this course you will be able to do the following: * Name and Reference Cells * Protect Data * Create Links * Use Basic Excel Functions * Create Charts * Create Databases * Work with Data Series For more information please call 1-877-313-8881 or copy  more...

Excel 2003 Intermediate Level 1 (1 Day) Location: Toronto Date: 2008-05-12 List Price: $275 Offered Price: $220.00 Seats Available: 2 After learning the basics in the Introduction course, this course is an absolute must to get the most out of Excel. You will learn important features that will save you time and make you much more efficient with the program. We have more locations in the GTA including North York, Mississauga, and  more...

Excel 2003 Intermediate Level 1 (1 Day) Location: Town of Newmarket Date: 2008-05-09 List Price: $275 Offered Price: $220.00 Seats Available: 2 After learning the basics in the Introduction course, this course is an absolute must to get the most out of Excel. You will learn important features that will save you time and make you much more efficient with the program. This course is classroom style instruction: Instructor-led, hands-on  more...

Microsoft Excel XP 2003 Level 2 (1 Day) Location: Vancouver Date: 2008-05-09 List Price: $199 Offered Price: $159.00 Seats Available: 2 After you complete this course you will be able to do the following: * Name and Reference Cells * Protect Data * Create Links * Use Basic Excel Functions * Create Charts * Create Databases * Work with Data Series For more information please call 1-877-313-8881 or copy  more...

Microsoft Excel XP 2003 Level 3 Location: Vancouver Date: 2008-03-18 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 You will also receive a  more...

Microsoft Excel 2003 Level 3 Location: Vancouver Date: 2008-02-11 List Price: $229 Offered 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  more...

Microsoft Excel 2003 Level 2 (1 Day) Location: Vancouver Date: 2008-02-08 List Price: $199 Offered Price: $139.00 Seats Available: 1 Objectives Displaying and Printing Formulas Using the Insert Function Feature Mathematical and Financial Functions Statistical and Database Functions Creating a List Inserting an Excel Worksheet into a Word Document Opening and Saving Files in Different Formats Finding and Deleting Records  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...

Microsoft Excel 2003 Level 1 Location: Vancouver Date: 2008-01-28 List Price: $199 Offered Price: $139.00 Seats Available: 2 This one day Microsoft Excel Training course covers the fundamentals of what you will need to know to effectively use Microsoft 2003. Objectives Understanding the Excel Program Screen Using Menus, Toolbars and Creating a New Workbook Opening, Saving, and Manging a Workbook Moving the Cell  more...

Microsoft Excel 2003 Level 3 Location: Vancouver Date: 2008-01-24 List Price: $229 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  more...

Microsoft Excel 2003 - Introduction / Beginning Course Description Performance-Based Objectives Upon successful completion of this course, students will be able to: create and apply templates. create and modify charts. work with graphic objects. calculate with advanced formulas. sort and filter data. use Excel with the Web. SEE DAY TWO BELOW FOR ADDITIONAL TOPICS Welcome to Sonic Training!. (http://www.sonictraining.com  more...

SQL Server 2005 Analysis Services Learn to use Microsoft SQL Server 2005 Analysis Services (SSAS) to design and implement OnLine Analytical Processing (OLAP) cubes and data mining models to support Business Intelligence (BI) solutions. Includes concepts, procedures and practices based on real-world experience giving both the novice and experienced SQL Server 2005 developer the tools to build data warehousing and decision support  more...