Custom Search
Home > Computer > Microsoft Office > Last Minute Training > Computer and IT Certification Seminars > Microsoft Excel 2007 Level 1- Introduction 2 Days
Provided by: Last Minute Training

Microsoft Excel 2007 Level 1- Introduction 2 Days

Excel

 Last Minute Training
Training Provided by Last Minute Training Microsoft Excel 2007 Level 1 Introduction. In this course, participants will look at topics such as Exploring the Excel Interface; Editing Worksheets; Data Entry; Creating Formulas; Advanced Formatting; Moving Data; Working with Charts; Printing and Viewing the Spreadsheet; and Getting Help. There will also be an opportunity for Lab time, where participants can practice all that they hae learned. There are no prerequisites for this course; this course will run for two full days from 9:00 am until 4:00 pm at Montreal Road in Ottawa. Course materials and a certificate of completion from CBiT will also be provided to participants who complete this course.
This is primarily ilt training
Contact Last Minute Training for more information
Course Level:basic
Duration:2 days
Training Presented in:English
Microsoft Excel 2007 Level 1- Introduction 2 Days | Module 0: Prerequisites
|

1. Ability To Create Folder
2. Save a File To Folder
3. Efficient Use of Mouse and Keyboard

| Module 1: Getting Started
|

1. What Is Ms Excel
2. Saving a File As a Previous Version
3. Looking Excel 2007 Extensions
4. Dealing with File Formats
5. Exploring Properties
6. Modifying Default Values with Excel Options

| Module 2: Exploring the Excel Interface
|

1. The Title Bar
2. View and Use the Keyboard Shortcuts
3. The Office Button
4. The Quick Access Toolbar
5. The Ribbons: Home, Insert, Page Layout, Formulas, Data and Review
6. The Formulas Bar
7. The Name Box
8. The Worksheet
9. The Excel Pointers
10. The Status Bar

| Module 3: Editing Worksheets
|

1. Working with Columns and Rows
2. Using the Name Box To Navigate
3. Creating Name Ranges
4. Working with Sheet Tabs

| Module 4: Data Entry
|

1. Entering Alpha-numeric Values
2. Inserting Symbols
3. Using Undo Redo
4. Entering Numeric Values
5. Entering Dates
6. Editing Cells
7. Adjusting Columns Width
8. Working with Text Cells
9. The Autofill Command
10. Using Find and Replace
11. The Auto Repeat Command

| Module 5: Creating Formulas
|

1. The Order of Precedence
2. Defining Functions and Formulas
3. Create Basic Formulas
4. Understanding Circular Referencing
5. Using Basic Functions
6. Explore the Formula Ribbon
7. Understanding Relative and Absolute Addressing
8. Creating Formulas Using Name Ranges
9. Date Formulas

| Module 6: Advanced Formatting
|

1. Using the Home Ribbon
2. Working with the Font, Alignment, Number and Style Group
3. Creating New Style
4. Create a New Custom Date Format
5. Find and Replace Formats

| Module 7: Moving Data
|

1. Drag and Drop
2. Cut, Copy and Paste
3. Understanding Smart Tags
4. Using Paste Special

| Module 8: Working with Charts
|

1. Creating a Chart
2. Formatting a Chart
3. Modifying Charts with the Layout Ribbon
4. Adding Labels
5. Linking a Chart To a Word Document

| Module 9: Printing and Viewing the Spreadsheet
|

1. Printing with Office Button
2. Using the View Ribbon
3. Understanding the Page Setup Window
4. Adding Headers and Footers
5. Sending To Pdf
6. Sending To E-mail

| Module 10: Getting Help
|

1. Using the F1 Key
2. Using the Help Button

| Module 11: Lab
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...
Home > Computer > Microsoft Office > Last Minute Training > Computer and IT Certification Seminars > Microsoft Excel 2007 Level 1- Introduction 2 Days
Advertise With Us
Sell microsoft excel 2007 training?
This page was last updated on sb5- 10/10/08 at 14:13:56 - 19:25:12