|
Provided by: Maverick Enterprises Dive Into Microsoft Excel Worksheet BasicsExcel |
![]() |
Training
Provided by Maverick Enterprises
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
|
|
||||||||||||||||||||
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 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...

