Microsoft Excel 2007 

Excel 2007 is the spreadsheet software in the Microsoft 2007 Office Suite. It allows you to store, organize, and analyze numerical and text data.

Includes course materials. Our class size is limited to two students, this provides more one on one time with our expert instructor. Hands on training.

After attending the class we provide you with a certificate of completion.

Price: $285 / Sale $185.00 / premium one day course

Students will learn the following lessons.

Intro to excel 2007

1. Setting Up Your Excel Environment 
   • How to minimize and maximize the Ribbon
   • Configure the quick access toolbar
   • Switch page views
   • Access Excel Options
2. Exploring and Setting Up Your Excel Environment - Video (5:19min)
3. Practice
   • Using the Zoom toolEnter text in a cell
   • Minimize and Maximize the Ribbon
   • Add two commands to the quick access toolbar

Starting a workbook

1. Create a New Workbook  
   • Insert Delete text
   • Inavigate a worksheet
   • Save an Excel Workbook
2. Your First Workbook - Video (5:13min)  
3. Edit and Delete Text
4. Saving Workbook Properties
5. Practice  
   • Create new blank workbook
   • Insert Delete text
   • Inavigate Tab key
   • Save Excel Workbook

modifying columns, rows, and cells

1. Modify Column Width and Row Height a Chart
2. Moving, Resizing, and Deleting Charts
   • Increase row height, columns
3. Insert Rows and Colunms
4. Practice
   • Open a Workbook
   • Insert a Colunm
   • Insert a row
   • Delete a column
   • Change the Width of a column using AutoAdjust
   • Change the height of a row

Formatting text

1. Use
   • Bold, Italic, and underline commands
   • Modify font style, size, and color
   • Apply borders and fill colors
2. Formatting Cells - Video (8:32min)
   • Format Text as Underlined
   • Change the Font Style
   • Change the Font Size
   • Change the Text Color
   • Add a Border
   • Fill Color
   • Numbers and Dates
3. Practice Challange - Suprise

Creating Simple Formulas

1. Simple Formulas - Video (10:47)
2. Create a Simple Formula that Adds Two NUmbers
3. Create a Simple Formula that Adds the Contents of Two Cells
4. Create a Simple Formula using the Point and Click Method
5. Create a Simple Formula that Multiplies the Contents of Two Cells
6. Create a Simple Formula that Divides One Cell by Another
7. Using Cell References

working with cells 

1. Working with Cells - Video (6:10min)
2. Move Information from one cell to another, cut, copy, paste, drag and drop information

Printing Workbooks 

1. Preparing to Print and Printing - Video (10:14)
2. View Spreadsheet in Print Preview
3. Modify Margins
4. Change Page Orientation
5. Insert a Break

excel basics 

Creating Complex Formulas 

1. Complex Formulas - Video (12:26min)
2. Complex Formulas
3. The Order of Operations
4. How to Write a Complex Formula
5. Absolute Reference
6. Practice Lesson

Working with basic functions 

1. Basic Functions - Video (11:34min)
2. Parts of a Function
3. Excel's Different Functions
4. Calculate the Sum of a RAnge of Data Using AutoSum
5. Edit a Function
6. Calculate the Sum of Two Arguments
7. Accessing Excel 2007 Functions
8. Practice Lesson

sorting grouping and filtering cells 

1. Sorting, Grouping, and Filtering - Video (10:13min)
2. Sort in Alphabetical Order
3. Sort from Smallest to Largest
4. Sort Multilevels
5. Ceate Groups with Subtotals
6. Collapse or Display the Group
7. Ungroup Select Cells
8. Ungroup the Entire Worksheet
9. Filter Data
10. Clear One Filter
11. Practice Lesson

formatting tables 

1. Formatting Tables - Video (3:34min)
2. Format Information as a Table
3. Modify a Table
4. Practice Lesson

aligning text 

1.  Aligning Text - Video (5:17min)
2. Align Text or Numbers in a Cell
3. Changing Vertical Cell Alignment
4. Changing Text Control
5. Practice Lesson

Working with worksheets 

1. Worksheets - Video (9:03min)
2. Naming Worksheets
3. Inserting Worksheets
4. Deleting Worksheets
5. Grouping and Ungrouping Worksheets
6. Freezing Worksheet Panes
7. Practice Lesson

Doing More With excel 

using templates 

1. Templates - Video (3:30min)
2. Create New Workbooks Using Templates
3. Create New Workbooks Using Office Online
4. Practice Lesson

using what-if analysis 

1. What-if Analysis - Video (5:18min)
2. Insert a Payment Function
3. What-if Analysis Tools
4. Use Goal Seek to Determine an Interest Rate
5. Practice Lesson

working with charts  

1. Charts - Video (9:25min)
2. Creating a Chart
3. Identifying the Parts of a Chart
4. Chart Tools
5. Change Chart Layout
6. Change Chart Style
7. Move the Chart to a Different Worksheet
8. Practice Lesson

using conditional formatting   

1.  Conditional Formatting - Video (5:17min)
2. Conditional Formatting Options
3. Apply Conditional Formatting
4. Remove Conditional Formatting Rules
5. Manage Conditional Formatting Rules
6. Practice Lesson

creating pivot tables   

1.  Pivot Tables Reports - Video (10:41min)
2. Why are they named Pivot Tables?
3. Create a Pivot Table Report
4. Add a Report Filter
5. Moving, or Pivoting Data
6.  Create a Pivot Chart
7. Practice Lesson

Back to Top

Web Design     

Call (360) 813-2987

 Software Training - Learn Word 2007, Excel 2007 and PowerPoint 2007

Website Package Sale $550 here

Website Portfolio here

One page website design to several thousand pages. Let us design you a professional website here

Search Engine Submission to hundreds of search engines Google, Yahoo, Bing, AOL, DMOZ, Yellow Pages and more view here.

Search Engine Optimization (SEO) view here.

Computer Services

.