Home User: Excel 2007
Up to speed with Excel 2007
This is a hands-on introduction to the new look of Microsoft Office Excel 2007 provided by Microsoft. See how to do what you’re used to doing in Excel as you get up to speed. This course has received 4 out of 5 stars. Completion of the course takes 30 to 40 minutes.
About this course:
This course includes:
- Three self-paced lessons and two practice sessions for hands-on experience. Practices require Excel 2007.
- A short test at the end of each lesson; tests are not scored.
- A Quick Reference Card you can take away from the course.
Goals
- Get a handle on the new look of Excel.
- Find everyday commands on the Ribbon: Cut, Copy, Paste, Insert Sheet Rows, Insert Sheet Columns, and Sum.
- Save workbooks in the new Excel file formats.
Get to know Excel 2007: Create your first workbook
Learn how to create a workbook in Microsoft Office Excel 2007, how to enter and edit text and numbers, and how to add and delete columns and rows. This course is provided by Microsoft. This course has received 4 out of 5 stars. Completion of the course takes 30 to 40 minutes.
About This Course:
This course includes:
- Three self-paced lessons and three practice sessions for hands-on experience. Practices require Excel 2007.
- A short test at the end of each lesson; tests are not scored.
- A Quick Reference Card you can take away from the course.
Goals
This course includes:
- Three self-paced lessons and three practice sessions for hands-on experience. Practices require Excel 2007.
- A short test at the end of each lesson; tests are not scored.
- A Quick Reference Card you can take away from the course.
Get to know Excel 2007: Enter formulas
Get to know Microsoft Office Excel 2007 by learning how to enter formulas into worksheets and perform simple calculations. Then, ditch your calculator. This course is provided by Microsoft. This course has received 4 out of 5 stars. Completion of the course takes 40 to 50 minutes.
About This Course:
Goals:
After completing this course you will be able to:
- Do math by typing simple formulas to add, divide, multiply, and subtract.
- Use cell references in formulas, so that Excel can automatically update results when values change or when you copy formulas.
- Use functions (prewritten formulas) to add up values, calculate averages, and find the smallest or largest value in a range of values.
Learn how to figure out dates using formulas in Excel 2007
Use formulas in your Microsoft Excel spreadsheet to figure out dates. This course is provided by Microsoft. This course has received 4 out of 5 stars. Completion of the course takes 30 to 40 minutes.
About This Course:
This course includes:
- Two self-paced lessons and two practice sessions for hands-on experience. Practices require Microsoft Excel 2007.
- A short test at the end of each lesson; tests are not scored.
- A Quick Reference Card you can take away from the course.
Goals:
After completing this course you will be able to:
- Use formulas to find the number of days between dates.
- Determine the date that falls after a number of workdays.
- Find a date that falls after a number of years, months, or days.
Charts I: How to create a chart in Excel 2007
Charts make data visual. Instead of having to analyze columns of worksheet numbers, you can see at a glance what the data means. This course has received 4 out of 5 stars. Completion of the course takes 30 to 40 minutes.
About This Course:
This course includes:
- Two self-paced lessons and two practice sessions for hands-on experience. Practices require Excel 2007.
- A short test at the end of each lesson; tests are not scored.
- A Quick Reference Card you can take away from the course.
Goals
After completing this course you will be able to:
- Create a chart using the new Excel 2007 commands.
- Make changes to a chart after you create it.
- Understand basic chart terminology.