Online Autoformat eLearning - Training Resources

Microsoft Excel 2002 Level 2 ...ial and logical formulas, and formatting worksheets using AutoFormat and predefined styles. This course introduces students to an additional set of basic spreadsheet features and acquaints students with the tools used in Microsoft Excel 2002. Students will learn to customize workbooks by changing worksheet attributes, use lists to store and organize worksheet data, use functions in financial  more...

Excel 2000 Level 2 This course introduces students to such Microsoft Excel 2000 features as working with lists, databases, templates, and functions; formatting and linking worksheets; and using 3-D references and Microsoft Map. Students will also learn how to use Excel to save and work with files as Web pages. This course introduces students to such Microsoft Excel 2000 features as working with lists, databases,  more...

Excel 2000 MOUS ...lected areas of instruction include using AutoCorrect and AutoFormat; understanding, using, and customizing templates; and working with data maps. Students will learn to apply the advanced features of Excel 2000 to work with records and ranges; sort, outline, and filter lists; and import and export data. PivotTables, PivotCharts, and data analysis tools and how to merge and link workbooks will  more...

Excel 2000 Proficient This course familiarizes students with many features of Microsoft Excel 2000, including entering text and formulas, moving data, formatting worksheet appearance, and manipulating charts. Students will also learn how to save and work with files as Web pages. This course familiarizes students with many features of Microsoft Excel 2000, including entering text and formulas, moving data, formatting  more...

Excel 2002 ...nancial and logical formulas, and format worksheets using AutoFormat and predefined styles. Finally, students will learn how to customize the Excel working screen with custom toolbars, menus, and macros. This course introduces students to basic spreadsheet features and acquaints them with the tools used in Microsoft Excel 2002 through real-life scenarios and projects. The students will learn  more...

Excel 2000 ...lected areas of instruction include using AutoCorrect and AutoFormat; understanding, using, and customizing templates; and working with data maps. Students will also learn how to apply the advanced features of Microsoft Excel 2000 to work with records and ranges, sort records, outline and filter lists, and import and export data. In addition, students will be taught how to use PivotTables,  more...

Excel 2000 Expert User ...lbar with their functions. Modify the pivot table data. Autoformat the pivot table data. Consolidate data in a pivot table. Create an interactive pivot table for the Web. Add a field to an interactive pivot table. Show grand totals in a pivot table report. Insert subtotals in a list. Change the summary function in a pivot table. Change the calculation type in a pivot table. Create a  more...

FrontPage XP Expert User Course Overview This course delivers instruction on the higher level skills required to work with Web sites in FrontPage 2002. Modification and structuring of Web sites are covered, as well as, design considerations and procedures fundamental to Web site customization that include the creation of dynamic pages, frames and tables. Finally, essential elements in client/server interaction, such as  more...

FrontPage XP Expert User ...149; Fill a table with repetitive data. • Apply an AutoFormat to a table. • Add a hover button to a Web page. • Add a banner ad to a Web page. • Add an Office Chart to a Web page. • Modify component properties. • Identify features of frames. • Create a frames page from a template. • Target content to a frame. • Modify the properties  more...

Word XP Proficient User ...ble in a document. • Create a table by using Table AutoFormat. • Add borders and shading to a table. • Merge cells in a table. • Modify rows and columns in a table. • Modify properties of a table. • Sort data in a table. • Calculate a formula in a table. • Create columns in a document before entering text. • Apply a column format to  more...

Excel 2003 Fundamentals ...ls. To identify options in the AutoFormat dialog box. Audience The target audience will range from new users to power users, although you can expect that the vast majority will have at least had some exposure to previous versions of Excel. Fundamental PC and Windows skills are assumed. Deployment Options e-Learning Accreditation NASBA credits: 4 CPE  more...