Instructor Led Workbooks Training Classes

MS Excel Advanced ...nd stronger management on calculations and worksheets and workbooks. Target Students: That already works on Excel and uses Excel on a daily base. Prerequisites: Windows xp/2003/2007/ MS Word xp/2003/2007 Basic / Ms Excel Intermediate Delivery Method: Instructor-led, group-paced, classroom-delivery learning model with structured hands-on activities. Benefits: Managing Workbooks,  more...

MS Excel Intermediate Course Specification: Course Length: 1 day/2 evenings Course Level: Intermediate Software: MS Excel xp/2003/2007 Professional Course Description: Excel Intermediate will concentrate on more advanced formulas and on formatting methods Target Students: That needs to know more about calculation formulas and databases Prerequisites: Windows xp/2003/2007/ MS Word xp/2003/2007 Basic, Ms Excel  more...

VB Excel ...The Range Property Flexible Ranges Range Contents Workbooks and Sheets Activating a Workbook Activating a Worksheet ThisWorkBook Objects, Properties and Methods Controlling Objects with their Properties Performing Actions with Methods Performing Multiple Actions on an Object Variables and Constants Variables Data Types Constants Control Structures  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...

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

Word and Excel 2003 XP Essentials In Microsoft Word learn the basics of entering text, the File, Save As command, opening and editing a document, scrolling in a document, searching in a document, AutoCorrect, selecting text, moving and copying text, basic character and paragraph formatting. Particular attention is paid to three essential skills - using tabs, tables and mail merging. In Microsoft Excel, start with the basics,  more...

Microsoft Excel - private, one on one training - INTERMEDIATE level ... Options Displaying and Customizing Toolbars Hiding Workbooks and Worksheets Freezing Panes Grouping and Ungrouping Worksheets MORE FORMATTING TECHNIQUES Styles, Guidelines and the Format Painter Conditional Formatting Hiding and Displaying Cells MORE FORMULAS AND FUNCTIONS DATABASE AND LIST MANAGEMENT CHARTS DRAWING AND PICTURE OBJECTS EXCEL AND OTHER APPLICATIONS  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 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 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...

Microsoft Excel Introduction (French Instructions, Eng Soft.) Participants who take this course will learn how to create and edit basic Microsoft Office Excel 2007 worksheets and workbooks. The basic outline of this course includes: Creating a Basic Worksheet; Performing Calculations; Modifying a Worksheet; Printing Workbook Contents; Managing Large Workbooks; and more  more...

Microsoft Excel 2003 XP Level I Tuesday Thursday 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 - 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 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 Macros  more...

Microsoft Excel 2007 - Module 1 Basic 2 Days * Create and edit a worksheet * Manage Excel workbooks * Enter formulas * Format data * Print and lay out a worksheet * Represent data in a chart  more...

Microsoft Excel 2007 - Level 1 This course is designed for people preparing for certification as a Microsoft Certified Application Specialist in Excel, who already have knowledge of Microsoft Office, Windows 2000 (or above), and who desire to gain the skills necessary to create, edit, format, and print basic Microsoft Office Excel 2007 worksheets. Performance-Based Objectives Upon successful completion of this course,  more...

Excel Introduction (2 Days) ... introduction of Excel, we provide 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  more...

Microsoft Excel - Intermediate Training (French Instructions) Location: Ottawa Date: 2008-04-11 List Price: $185 Offered Price: $148.00 Seats Available: 3 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. For more information please call  more...

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

Microsoft Excel 2002 (XP) Level I Location: Toronto Date: 2007-04-10 List Price: $80 Offered Price: $56.00 Seats Available: 2 Start with the basics, including elements of Excel screen, simple formulas, working with workbooks, worksheets, tabs, moving/copying worksheets, formatting labels and values, AutoFormat; basic functions (SUM, AVG, MIN, MAX, NOW, IF), printing, calculating percentages, relative/absolute cell references,  more...

Advanced Excel - two, 4-h sessions Class 1 will be held on March 20th, from 8:30 a.m. to 12:30 p.m. Class 2 will be held on March 27th, from 8:30 a.m. to 12:30 p.m. Participants attend both classes. This is an 8-hour hands-on, instructor-led course, presented as two, 4-hour sessions. Take your knowledge of Excel to the next level In this course you ll learn to create and use multi-page workbooks where you can perform  more...