|
Provided by: Last Minute Training Microsoft Excel 2007 - Fast Track |
 |
Training
Provided by Last Minute Training
Microsoft Excel 2007 Level 1 a Fast Track
| | ID: saeft0 | Course Length: 1
| Module 0: Prerequisites
| Some Degree of Experience with Excel
Ability To Create Folder
Save a File To Folder
Efficient Use of Mouse and Keyboard
| Module 1: Getting Started
| What Is Ms Excel
Starting Excel
Closing and Saving Files
Exploring Properties
Closing Excel
| Module 2: Exploring the Excel Interface
| The Title Bar
The Office Button
The Quick Access Toolbar
The Ribbons: Home, Insert, Page Layout, Formulas, Data and Review
The Formulas Bar
The Name Box
The Worksheet
The Excel Pointers
The Status Bar
| Module 3: Editing Worksheets
| Working with Columns and Rows
Using the Name Box To Navigate
Creating Name Ranges
Working with Sheet Tabs
| Module 4: Data Entry
| Entering Alpha-numeric Values
Entering Numeric Values
Entering Dates
Editing Cells
Adjusting Columns Width
Working with Text Cells
The Autofill Command
The Auto Repeat Command
Using Undo Redo
| Module 5: Creating Formulas
| The Order of Precedence
Defining Functions and Formulas
Create Basic Formulas
Using Basic Functions
Understanding Relative and Absolute Addressing
Date Formulas
| Module 6: Basic Formatting
| Using the Home Ribbon
Working with the Font, Alignment and Number Group
| Module 7: Moving Data
| Drag and Drop
Cut, Copy and Paste
Understanding Smart Tags
Using Paste Special
| Module 8: Printing and Viewing the Spreadsheet
| Printing with Office Button
Using the View Ribbon
Understanding the Page Setup Window
Adding Headers and Footers
Sending To Pdf
Sending To E-mail
| Module 9: Getting Help
| Using the F1 Key
Using the Help Button
| Module 10: Lab
Pre-Requisites:
1. Some Degree of Experience with Excel
2. Ability To Create Folder
3. Save a File To Folder
4. Efficient Use of Mouse and Keyboard
|
|
||||||||||
Microsoft Excel 2007 - Fast Track
Microsoft Excel 2007 Level 1 Fast Track
| | ID: saeft0 | Course Length: 1
| Module 0: Prerequisites
| Some Degree of Experience with Excel
Ability To Create Folder
Save a File To Folder
Efficient Use of Mouse and Keyboard
| Module 1: Getting Started
| What Is Ms Excel
Starting Excel
Closing and Saving Files
Exploring Properties
Closing Excel
| Module 2: Exploring the Excel Interface
| The Title Bar
The Office Button
The Quick Access Toolbar
The Ribbons: Home, Insert, Page Layout, Formulas, Data and Review
The Formulas Bar
The Name Box
The Worksheet
The Excel Pointers
The Status Bar
| Module 3: Editing Worksheets
| Working with Columns and Rows
Using the Name Box To Navigate
Creating Name Ranges
Working with Sheet Tabs
| Module 4: Data Entry
| Entering Alpha-numeric Values
Entering Numeric Values
Entering Dates
Editing Cells
Adjusting Columns Width
Working with Text Cells
The Autofill Command
The Auto Repeat Command
Using Undo Redo
| Module 5: Creating Formulas
| The Order of Precedence
Defining Functions and Formulas
Create Basic Formulas
Using Basic Functions
Understanding Relative and Absolute Addressing
Date Formulas
| Module 6: Basic Formatting
| Using the Home Ribbon
Working with the Font, Alignment and Number Group
| Module 7: Moving Data
| Drag and Drop
Cut, Copy and Paste
Understanding Smart Tags
Using Paste Special
| Module 8: Printing and Viewing the Spreadsheet
| Printing with Office Button
Using the View Ribbon
Understanding the Page Setup Window
Adding Headers and Footers
Sending To Pdf
Sending To E-mail
| Module 9: Getting Help
| Using the F1 Key
Using the Help Button
| Module 10: Lab
Pre-Requisites:
1. Some Degree of Experience with Excel
2. Ability To Create Folder
3. Save a File To Folder
4. Efficient Use of Mouse and Keyboard
| | ID: saeft0 | Course Length: 1
| Module 0: Prerequisites
| Some Degree of Experience with Excel
Ability To Create Folder
Save a File To Folder
Efficient Use of Mouse and Keyboard
| Module 1: Getting Started
| What Is Ms Excel
Starting Excel
Closing and Saving Files
Exploring Properties
Closing Excel
| Module 2: Exploring the Excel Interface
| The Title Bar
The Office Button
The Quick Access Toolbar
The Ribbons: Home, Insert, Page Layout, Formulas, Data and Review
The Formulas Bar
The Name Box
The Worksheet
The Excel Pointers
The Status Bar
| Module 3: Editing Worksheets
| Working with Columns and Rows
Using the Name Box To Navigate
Creating Name Ranges
Working with Sheet Tabs
| Module 4: Data Entry
| Entering Alpha-numeric Values
Entering Numeric Values
Entering Dates
Editing Cells
Adjusting Columns Width
Working with Text Cells
The Autofill Command
The Auto Repeat Command
Using Undo Redo
| Module 5: Creating Formulas
| The Order of Precedence
Defining Functions and Formulas
Create Basic Formulas
Using Basic Functions
Understanding Relative and Absolute Addressing
Date Formulas
| Module 6: Basic Formatting
| Using the Home Ribbon
Working with the Font, Alignment and Number Group
| Module 7: Moving Data
| Drag and Drop
Cut, Copy and Paste
Understanding Smart Tags
Using Paste Special
| Module 8: Printing and Viewing the Spreadsheet
| Printing with Office Button
Using the View Ribbon
Understanding the Page Setup Window
Adding Headers and Footers
Sending To Pdf
Sending To E-mail
| Module 9: Getting Help
| Using the F1 Key
Using the Help Button
| Module 10: Lab
Pre-Requisites:
1. Some Degree of Experience with Excel
2. Ability To Create Folder
3. Save a File To Folder
4. Efficient Use of Mouse and Keyboard
About The Training Provider: Last Minute Training
Last Minute Training - Last Minute Training Corp. works similar to last minute discounted travel. We sell training seminars at deep discounts on a last minute basis. If you want to save 30 - 60 off high quality training seminars and have the flexibility to attend with only a few days notice check out our website and see if the training you are looking for is on sale. While your there set up and free account...
