Provided by: Last Minute Training

Microsoft Excel 2007 - Fast Track

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
This is primarily ilt training
Course Level:basic
Duration:1 days
Training Presented in:English
Training Provided by Last Minute Training
  • A asked: WANT TRAINING TO BE EXPERT IN EXCEL
  • C asked: location course duration (start time - end time) is this a step up from basic? what is the cost
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
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...
Want to market your 2007 training?
Custom Search
tcw11-v473M-12/25/11-08:02:31-()[B]-[A]-[A] -07:22:18