Dive Into Microsoft Excel Worksheet Intermediate

Training Provided by Maverick Enterprises 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 filtering, sorting, and grouping Summarize and analyze data using PivotTables Using Excel data for Microsoft Word Mail Merges

Dive Into Microsoft Excel Worksheet Intermediate One Day of Microsoft Excel 2003 Intermediate

Unit 1: Working with large worksheets; Viewing options, Hiding, displaying, and outlining data, Printing large worksheets,

Unit 2: Using multiple worksheets and workbooks; Using multiple worksheets, Linking worksheets by using 3-D formulas, Consolidating data, Linking workbooks, Managing workbooks

Unit 3: Customizing Excel; Using the Options dialog box, Customizing toolbars and menus

Unit 4: Advanced formatting; Borders and shading, Using special number formats, Working with dates, Working with styles, Other advanced formatting

Unit 5: List management; Examining lists, Sorting and filtering lists, Advanced filtering

Unit 6: Advanced charting; Chart formatting options, Using combination charts, Using graphic elements

Unit 7: Documenting and auditing; Auditing features, Comments and text boxes, Protection
Workgroup collaboration

Unit 8: Using templates; Built-in templates, Creating and managing templates

About The Training Provider: Maverick Enterprises

More Microsoft Office Training Training from Maverick Enterprises

• Beginning Progress with Microsoft Project
• Dive Into Microsoft Excel Spreadsheets and Workbooks
• Dive Into Microsoft Excel Worksheet Basics
• Get on Track with MS Access Advanced
• Get on Track with MS Access Basics
• Get on Track with MS Access Intermediate
• Hit the Open Road With Microsoft Outlook and Explorer
• Hit the Open Road With Microsoft Outlook Basics
• Hit the Open Road With Microsoft Outlook Intermediate
• Intermediate Progress with Microsoft Project
• Making Progress with Microsoft Project
• Off the Ground with Microsoft Word Advanced
• Off the Ground with Microsoft Word Basic
• Off the Ground with Microsoft Word Documents
• Off the Ground with Microsoft Word Intermediate
• Out This World With Microsoft Office
• Revving up your Microsoft PowerPoint Presentations Advanced
• Revving up your Microsoft PowerPoint Presentations Basic