|
|
Title |
Duration |
|
|
|
Introduction to Excel
This video walks you through the Excel 2007 interface, including the Office 2007 Ribbon and the Office button. The basic spreadsheet layout, changing worksheet views, analyzing data on-the-fly and things you must know about saving files in the new 2007 format are all covered.
|
00:26:33 |
|
|
|
Excel 2007 Basics
This video begins your journey of creating and manipulating data in Excel workbooks. Inserting text and numbers and AutoSumming values are demonstrated, as well as the advantages of the AutoFill command. Inserting and modifying rows and columns is another important component of spreadsheet manipulation discussed in this video.
|
00:26:00 |
|
|
|
Spreadsheet Formatting
Audiences sometimes feel overwhelmed by the amount of information stored in a spreadsheet. But with a few easy formatting tricks, the information can be easily understood and smartly displayed. Although Excel 2007 uses many formatting commands from earlier editions, there are also new styles and features, such as formatting data in a table.
|
00:26:36 |
|
|
|
Use Excel as a Database
Excel can be a powerful tool for storing and extracting data. The Sort and Filter commands are easy to use, and they facilitate data searching and analysis. This video also covers various formulas that can display such information as the maximum value in a specific field or the average of all data in a column
|
00:28:49 |
|
|
|
Charts
Charts are one of the best ways to reach your audience. With a quick glance, charts make it easy to understand the goal of your detailed spreadsheet. Excel 2007 has many tools and techniques for creating and modifying charts. In fact, you can create over seventy different types of charts. But charts aren’t the only type of graphic you can insert into your spreadsheet. Illustrations, such as pictures and Smart Art, can also be utilized to express your point visually.
|
00:24:57 |
|
|
|
Collaborate Data
Excel 2007 enhances collaboration among teams. Many people can update and share their results within the same file. As the owner of the file, you can limit what cells are editable and even who is allowed to access the information. This video covers how to share, protect and manage changes to worksheets and workbooks.
|
00:28:48 |
|
|
|
Consolidate Data
Sometimes normal business processes generate many separate worksheets that need to be combined for better reporting and analysis. Using the Consolidate tool, you'll manage worksheets by combining many related cell ranges into one cumulative range. Not only is there a tool that consolidates, there are also formulas you can create to summarize data
|
00:25:38 |
|
|
|
Pivot Tables
Pivot tables are a handy way of displaying unwieldy data in an easy-to-interpret model. These tables allow you to cross-tabulate information. The easy-to-use interface allows you to click-and-drag to rearrange data. You can also sort, filter and format the data as a table.
|
00:28:06 |
|
|
|
Basic Formulas
A major component of most spreadsheets is calculating data. This video sets you on the path to creating and modifying formulas. The insert function and the formula ribbon contain many of the tools you will use to reference and calculate data in your formulas. The difference between relative and absolute references is also explained here.
|
00:27:56 |
|
|
|
Conditional Formulas
It’s likely that analyzing data will be based on conditions. This Video covers using "If" formulas to conditionally summarize data. Conditional logic can also be the foundation for looking up data from a range and displaying the appropriate value based on set criteria.
|
00:24:37 |
|
|
|
Data Integrity
This video covers auditing and troubleshooting formulas, as well as enforcing data integrity. There are special tools you can use to view cells that precede the formula or that depend on the outcome of the formula’s calculations. The Display Formula button can also assist troubleshooting endeavors by making it easy to see all the formulas in your sheet at once. Excel 2007 even allows you to set data validation rules, which limit the type of information accepted into the worksheet.
|
00:27:21 |
|
|
|
Summarize Data
Worksheets often contain large amounts of similar data. The outlining and subtotaling features built into Excel 2007 help you easily summarize your spreadsheets. Conditional formatting brings your work to the next level by focusing on particular pieces of data, based on criteria. Conditional formatting can even utilize formulas to modify the way text looks.
|
00:26:07 |
|
|
|
Prepare for Printing and Distribution
The majority of worksheets will either be delivered electronically or printed. This Video covers preparing workbooks for distribution, including setting print options.
|
00:29:52 |
|
|
|
Data Security
Data security is paramount for computer users. The nature of many spreadsheets is to collect and analyze confidential information. This video covers important points about encrypting, setting passwords and using digital signatures. It also covers the extra steps you can take to protect your information and your computer.
|
00:24:28 |
|
|
|
What-If Analysis
Using Excel 2007's data tables, scenarios and goal seeking tools, you can model your data based on different inputs. This Video introduces you to all the available tools you’ll use when running what-if analysis.
|
00:24:25 |
