Though Microsoft Excel has been around for many years, Excel 2007 has an entirely new look and feel. Many new features have been added to improve productivity and workflow. In this in-depth VTC course, VTC Author Cheryl Brumbaugh-Duncan explores using Excel to create, manage, and analyze spreadsheet data. Users will learn to develop all the necessary worksheets and workbooks for financial and informational data, for a company that distributes healthy snacks to companies throughout a city. The course steps the participant through the various topics and skills needed to master Excel 2007 and provides a fun project for applying the new knowledge. Work Files are included. To get started learning Microsoft Excel 2007, click on one of the movie links below.
Overview of Spreadsheets and Excel 2007
Understanding the Excel 2007 Workspace
Introducing the New Excel 2007 Ribbon
Using the Quick Access Toolbar
Compatibility with Earlier Versions
Considerations Before You Install
Accessing Microsoft Excel 2007 He|p
Using Microsoft Office On-line
Accessing the Support Knowledge Base
Selecting Cells / Rows / Columns
Editing or Replacing Content in a Cell
Inserting and Deleting Rows / Columns / Cells
Customizing the Excel Workspace
Hiding and Showing Rows / Columns / Sheets
Displaying Gridlines and Headings
Creating Formulas with Operators and Cell References
Calculating Totals with AutoSum
Creating Formulas with Functions
Creating Formulas with Nested Functions
Displaying and Printing Formulas
Common Errors When Creating Formulas
Overview of Excel Data Handling Tools
Working with Excel Table Rows and Columns
Displaying and Calculating Table Data Totals
Linking Data Between Worksheets
Linking Data Between Multiple Workbooks
Changing the Chart Type of an Existing Chart
Formatting a Chart - Design Tab
Formatting a Chart - Layout Tab
Formatting a Chart - Format Tab
Overview of Sharing and Collaborating
Excel and Other Office Applications
Opening and Saving Files in Other Formats
Using with a Document Management Server
Every course on the vtc.com website contains free movies that let you assess the quality of our tutorials before you subscribe - just click on the blue links to watch them. Become a member today to access over 100,000 instructional videos!
Sign Up NowIf you are already an active vtc.com member, please log in to access the tutorials.