Dive Into Microsoft Excel Spreadsheets and Workbooks

Training Provided by Maverick Enterprises Keeping track of sales figures, statistics or mortgage payments has never been easier, or more difficult. Microsoft Excel gives you the power to develop formulas using built-in functions, Use charts and graphs to predict trends and understand relationships, Consolidate data from several worksheets into one, Find and organize information by filtering, sorting, and grouping, Summarize and analyze data using PivotTables, Learn data entry tips and shortcuts, Use Excel database information for Word mail merges

Dive Into Microsoft Excel Spreadsheets and Workbooks One Day of Microsoft Excel 2003 Basic

Unit 1: Getting started; Spreadsheet terminology, Exploring the Excel window, Getting help, Opening and navigating workbooks, Closing workbooks

Unit 2: Entering and editing data; Creating workbooks, Entering and editing labels and values, Entering and editing formulas, Saving and updating workbooks

Unit 3: Modifying a worksheet; Moving and copying data, Moving and copying formulas, Using absolute references, Inserting and deleting ranges

Unit 4: Using functions; Entering functions, Using AutoSum, Using AVERAGE, MIN, and MAX

Unit 5: Formatting worksheets, Formatting text, Formatting rows and columns, Number formatting, Using Format Painter and AutoFormat

Unit 6: Printing; Preparing to print, Page Setup options, Printing worksheets

Unit 7: Creating charts; Chart basics, Modifying charts, Printing charts

Unit 8: Web features; Saving workbooks as Web pages, Hyperlinks, Sending workbooks via e-mail




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 Worksheet Basics
• Dive Into Microsoft Excel Worksheet Intermediate
• 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