|
Provided by: Maverick Enterprises Dive Into Microsoft Excel Worksheet IntermediateExcel |
![]() |
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
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
Maverick Enterprises - Maverick Enterprises offers Business, Technology and Communications training for the generation leading the digital revolution. Rob White brings over 19 Years of Technology Consulting Experince to the table. He is a Novell Certified Network Engineer, and a Certified Microsoft Office Specialst.
For more than 8 years, Rob has been performing workshops, seminars and conferences in Software...

