Instructor Led Avg Training - Training Resources

Microsoft Excel 2003 XP Level I Saturday - skills Start with the basics including working with workbooks, tabs, moving/ copying worksheets, formatting labels & values, AutoFormat, applying basic functions (SUM, AVG, MIN, MAX, NOW) to data, calculating percentages & basic charts.  more...

Microsoft Excel 2003 XP Level I - Skills for change Start with the basics including working with workbooks, tabs, moving/ copying worksheets, formatting labels & values, AutoFormat, applying basic functions (SUM, AVG, MIN, MAX, NOW) to data, calculating percentages & basic charts.  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...

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

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

Word and Excel 2002 (XP) Essentials March 31, 2007 Time: 10:00 am - 03:00 pm Days Held: Sat Hours: 20 Weeks: 4 In this course, participants learn the basics of entering text, the File, Save As command, opening and editing in 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  more...

My SQL ...ems (SQL min and max functions) * Finding averages (SQL avg function) * Rows with missing data (null values) * Finding rows with missing data (SQL is null and is not null tests) * Sorting result rows (SQL order by clause, sorting in ascending or descending order with asc and desc) * Using column-name aliases for long-winded column names in select * Simple joins across multiple  more...