Excel 2007 Tutorial

This Excel 2007 Tutorial will introduce you to the basics and some intermediate leve features for using the Excel 2007 spreadsheet program.

You'll learn to create a spreadsheet, basic Excel workbook skills, work with cells, enter and manipulate data, apply formulas, format data, create and work with charts, and manage Excel workbooks.

Excel 2007 Ebook: The Ultimate Guide - $12.95

Excel 2007 Ebook

Get the Excel 2007 Ebook: The Ultimate Guide and receive all of the Excel 2007 tutorials in one handy reference guide. Purchase online easily with your credit card or PayPal and have the Ebook emailed to your email address (pdf format)

Price: $12.95. California residents pay 7.25% Sales tax. Delivered via email.

A. Setting Up Excel 2007

1. What’s on the Ribbon
2. Making Your Way Around the Ribbon
3. Customizing the Ribbon
4. Customizing the MS Office Button

B. Working with Excel 2007 Worksheets

1. Activating and Moving Between Worksheets
2. Selecting Multiple Worksheets
3. Adding a Worksheet to a Workbook
4. Deleting a Worksheet From a Worksheet
5. Changing the Name of a Worksheet
6. Changing the Sheet Tab Color
7. Rearranging Worksheets
8. Hiding and Unhiding Worksheets

Excel Training Excel Advanced Training

Instant Download! - Place your order right now and you'll have access to your videos online, immediately.

Two Volumes, One Low Price - These two volumes normally sell for $67 each, but if you act quickly you'll be able to purchase BOTH sets for only $59.95. Click Here!

 

C. Working with Excel 2007 Formulas

1. What are formulas
2. Order of operations
3. Relative and absolute referencing

D. Controlling the Worksheet View

1. Zooming in and out of a worksheet
2. Viewing a worksheet in multiple windows
3. Viewing workbooks side by side
4. Splitting a worksheet window
5. Freezing and unfreezing panes
6. Monitoring cells with the Watch window
7. Viewing using full screen
8. Creating custom views

E. Using Names to Work with Ranges

1. Creating range names
2. Moving to a named range
3. Using range names in forumulas
4. Managing named ranges
5. Creating a 3-d range name

F. Working with Cell Comments

1. Adding a comment to a cell
2. Reading comments
3. Showing and hiding comments
4. Editing comments
5. Formatting comments
6. Changing a comment shape
7. Printing comments
8. Deleting a comment

G. Working with Excel 2007 Charts

1. Creating a chart
2. Changing the chart layout
3. Changing the data orientation in a chart
4. Changing the chart type
5. Understanding chart types
6. Embedding a chart or a chart sheet
7. Moving and resizing an embedded chart
8. Adding a chart title
9. Adding axis titles
10. Changing the location of a chart legend
11. Adding data labels
12. Adding a data table to a chart
13. Changing the chart axis
14. Changing the gridlines
15. Formatting chart elements
16. Moving, resizing, and deleting chart elements
17. Deleting a chart
18. Printing a chart

H. Working with Graphics in Excel 2007

1. Inserting a shape
2. Inserting a picture
3. Inserting clip art
4. Inserting a SmartArt graphic
5. Inserting a text box
6. Inserting WordArt
7. Selecting objects
8. Resizing a graphic object
9. Reshaping a graphic object
10. Moving a graphic object
11. Aligning a graphic object
12. Copying a graphic object
13. Copying a graphic object
14. Deleting a graphic object
15. Grouping graphic objects
16. Stacking graphic objects
17. Formatting the fill of a graphic object
18. Formatting the outline of a graphic object

I. Conditional Formatting

1. Understanding conditional formatting
2. Applying highlight cells rules
3. Applying data bars
4. Applying color scales
5. Applying icon sets
6. Creating conditional formatting rules
7. Managing conditional formatting rules
8. Clearing conditional formatting rules

J. Using Functions

1. Using COUNT functions
2. Using the IF function
3. Using the VLOOKUP function
4. Using the HLOOKUP function
5. Using Concatenate
6. Using text to columns

K. Printing in Excel 2007

1. Preparing to print a workbook
2. Print preview
3. The page layout tab
4. Page breaks
5. The page layout view
6. Working with headers and footers

How to Link to This Page

It will appear on your page as: Excel 2007 Tutorial

 


Search for Tutorials
 

PowerPoint Tutorials: Microsoft PowerPoint 2003

Excel 2007 Tutorials
Excel 2007 Charts
Excel 2007 Graphics
Excel 2007 Worksheets
Excel 2007 Worksheet Views
Excel 2007 Formulas
Excel 2007 Named Ranges
Excel 2007 Cell Comments

Excel Video Tutorials
Lesson 1: Excel Basics
Lesson 2: Editing a Worksheet
Lesson 3: Making Bar and Circle Graphs
Lesson 4: Making a Gantt Chart
Lesson 5: Excel Keyboard Shortcuts

More Excel Tutorials at GuidesandTutorials.net

All Other Guides and Tutorials

Guides and Tutorials Blog
Listing of the latest tutorials published on the GuidesandTutorials website.
GuidesandTutorials: Audacity Tutorial - Record and Edit Audio
This Audacity tutorial will show you how to use the basic tools and procedures in the open source audio editing program, Audacity. Not just screen shots, but free narrated multimedia tutorials - You'll learn to use Audacity for recording and editing audio files that can be used for podcasting, mixing music and vocals, creating sound tracks, and other audio projects.
Audacity Tips & Tricks
Audacity tips and tricks submitted by users
Digital Photography Guide
This Digital Photography Guide will provide you with the basic information you need to take professional quality photogrphs with your digital camera.
GuidesandTutorials: Dreamweaver Tutorial
Dreamweaver Tutorial - this series of free Dreamweaver tutorials is just what you need to get up and running with Dreamweaver to create interesting and compelling web sites
GuidesandTutorials: Microsoft Excel 2003 Tutorial
This Excel 2003 Tutorial will introduce you to the basics of using the Excel 2003 spreadsheet program. You'll learn to create a spreadsheet, basic Excel workbook skills, work with cells, enter and manipulate data, apply formulas, format data, create and work with charts, and manage Excel workbooks.
Podcasting Tutorial
This Podcasting tutorial includes a step by step guide that will show you how to record, publish and promote your podcast. Using inexpensive equipment and free software, you'll be publishing podcasts in no time.
PowerPoint Tutorial - Microsoft PowerPoint 2003
This PowerPoint tutorial is just what you need to learn how to use PowerPoint 2003 to create effective and engaging presentations.
The PowerPoint 2007 Window
This PowerPoint 2007 tutorial will show you the features and how to get around the PowerPoint Window.
GuidesandTutorials: Free PowerPoint Templates
Free PowerPoint templates that you can download and use today. This is a growing library of free resources for PowerPoint users.
LCD Projector Guide and Tutorial
This LCD Projector Guide will assist you in the use and purchase of a digital LCD projector or DLP projector. It will discuss the differences between LCD and DLP projectors, size and portability considerations, lamp types and brightness, resolution, image quality and other considerations in the use and purchase of a digital projector.
Word Tutorial: Microsoft Word 2003
This Word tutorial is just what you need to learn how to use Word 2003 to create professional looking documents.
Word 2007 Workspace
This Microsoft Word 2007 Workspace tutorial will acquaint you with the new tools and features in the Word 2007 Window. It's changed significantly from previus versions and even experienced users will find this helpful.
Work at Home Jobs
This Work at Home Jobs tutorial will provide information on ways that you can put your skills and knowledge to use in creating part or full time income while working from home.
Guides and Tutorials: Free Guides and Tutoials Site Map
Free guides and tutorials on podcasting, digital video and audio, Audacity, RSS, multimedia development, educational technology, technology integration, K12 Technology, PowerPoint.
Suggest a New Technology Tutorial
Free Technology Tutorials on software and technology applications including PowerPoint tutorials, Podcasting tutorials, Dreamweaver tutorials, Audacity, Non-Linear PowerPoint, Digital Photography, RSS tutorial, and everything educational technology.
Adobe Acrobat 9 Tutorial
This Adobe Acrobat 9 Tutorial will show you how to create PDFs from MS Office applications, from Multipe files, from web pages and from several other types of documents.
GuidesandTutorials: Free Tutorials
Free Tutorials, software, hardware, and technology applications including PowerPoint, Podcasting, Dreamweaver, Audacity,
Excel 2007 Tutorial | GuidesandTutorials: Free Tutorials
This free Excel 2007 Tutorial will show you how to use all of the begginer and intermediate features in Excel 2007

This site proudly build with Site Build It!

Powered By SiteBuildIt

 

 

Excel 2007 Ebook: The Ultimate Guide - $12.95

Excel 2007 Ebook

Get the Excel 2007 Ebook: The Ultimate Guide and receive all of the Excel 2007 tutorials in one handy reference guide. Purchase online easily with your credit card or PayPal and have the Ebook emailed to your email address (pdf format)

Price: $12.95. California residents pay 7.25% Sales tax. Delivered via email.

Excel Video Tutorials
1. Excel Basics
2. Editing a Worksheet
3. Making a Gantt Chart
5. Excel Keyboard Shortcuts

Excel 2007 Tutorials
Excel 2007 Charts
Excel 2007 Graphics
Excel 2007 Worksheets
Excel 2007 Worksheet Views
Excel 2007 Formulas
Excel 2007 Named Ranges
Excel 2007 Cell Comments

More Excel Tutorials at
GuidesandTutorials.net

[?] Subscribe To This Site

XML RSS
follow us in feedly
Add to My Yahoo!
Add to My MSN
Subscribe with Bloglines