|
Provided by: Maverick Enterprises Dive Into Microsoft Excel Worksheet BasicsExcel |
 |
Fundamentals of a Spreadsheet; Cells; Rows and Formulas
Create and Edit a Spreadsheet
Selecting and Entering Data into a Cell
Learn 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 a Spreadsheet
Selecting and Entering Data into a Cell
Learn 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
|
|
||||||||||||||||||
Training
Provided by Maverick Enterprises
Dive Into Microsoft Excel Worksheet Basics
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
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
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 more than 20 years of Technology Consulting Experience to the table. He is a Novell Certified Network Engineer, and a Certified Microsoft Office Specialist.
For over 10 years, Rob has been performing workshops, seminars and conferences in Software...
