|
|
|
|
Course Number:
|
07XL01 |
 |
Course Title:
|
Microsoft Excel 2007 Foundation |
No classes scheduled.
|
Know someone who
needs this course? |
 |
|
|
Length:
|
1 Day(s)
|
|
Description:
How to open, interact and close excel; how to create, open, save and close a workbook; Excel file types; how to switch worksheets; the active cell; how to explore a worksheet, use zoom help, online and offline features.
What you will learn:
- About and exploring your workbook; getting help in Excel 2007; the Quick Access Toolbar, Home Tab, Insert Tab, Page Layout, formulas, Data and Review Tab; working with and Basic Excel Features; moving your data; Smart Tags and Options Buttons; editing Tools; modifying cells and data; Cell Formatting; enhancing a Worksheet's appearance; work with Charts; using the View Tab; managing a Single and Multiple Window; printing workbooks.
Audience:
Foundation Level - comprehension of using a computer, mouse ad keyboard.
Prerequisites:
- Basic knowledge of Windows concepts, such as using the mouse and keyboard, as well as spreadsheet programs.
Outline:
- Section One: Getting Started
- Lesson 1.1: Starting Out
- Lesson 1.2: About Workbooks
- Lesson 1.3: Exploring Your Workbook
- Lesson 1.4: Getting Help in Excel 2007
- Section Two: The New Interface
- Lesson 2.1: The Quick Access Toolbar
- Lesson 2.2: The Home Tab
- Lesson 2.3: The Insert Tab
- Lesson 2.4: The Page Layout Tab
- Lesson 2.5: The Formula Tab
- Lesson 2.6: The Data Tab
- Lesson 2.7: The Review Tab
- Section Three: Excel Basics
- Lesson 3.1: Working with Excel 2007
- Lesson 3.2: Basic Excel Features
- Lesson 3.3: Moving your Data
- Lesson 3.4: Smart Tags and Options Buttons
- Lesson 3.5: Editing Tools
- Section Four: Editing Your Workbook
- Lesson 4.1: Modifying Cells and Data
- Lesson 4.2: Cell Formatting
- Lesson 4.3: Enhancing a Worksheet's Appearance
- Lesson 4.4: Working with Charts, Part 1
- Lesson 4.5: Working with Charts, Part 2
- Section Five: Printing and Viewing your Workbook
- Lesson 5.1: Using the View Tab
- Lesson 5.2: Managing a Single Window
- Lesson 5.3: Managing Multiple Windows
- Lesson 5.4: Printing your Workbook
|
|
|