| Microsoft Excel 2007 Tutorials Online |
 |
|
Description Microsoft Excel 2007
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. |
| Sample - Preview the First 3 chapters of Microsoft Excel 2007 video free. Free learning Microsoft Excel 2007 online. |
01 Introduction to Excel 2007
0101 Welcome to Excel 2007
0102 Overview of Spreadsheets and Excel 2007
0103 Overview of Course
0104 New in Excel 2007 pt. 1
0105 New in Excel 2007 pt. 2
0106 Understanding the Excel 2007 Workspace
0107 Introducing the New Excel 2007 Ribbon
0108 Using the Quick Access Toolbar
0109 Compatibility with Earlier Versions
02 Installing Excel 2007
0201 Considerations Before You Install
0202 Installing Excel
03 Microsoft Excel 2007 He|p
0301 Accessing Microsoft Excel 2007 He|p
0302 Using Excel 2007 He|p
0303 Using Microsoft Office On-line
0304 Accessing the Support Knowledge Base
04 Working with Worksheets and Workbooks
0401 Launching Excel
0402 Planning a Project
0403 Creating a New Workbook
0404 Adding and Deleting Data
0405 Importing Data into Excel
0406 Naming and Saving a Workbook
0407 Managing Multiple Worksheets
0408 Printing a Worksheet pt. 1
0409 Printing a Worksheet pt. 2
0410 Opening and Closing a Workbook
0411 Renaming and Deleting a Workbook
05 Editing Techniques
0501 Selecting Cells / Rows / Columns
0502 Cut / Copy / Paste
0503 Copy and Paste Special
0504 Editing or Replacing Content in a Cell
0505 Undo / Redo / Repeat Edits
0506 Adjusting Row Height
0507 Adjusting Column Width
0508 Inserting and Deleting Rows / Columns / Cells
0509 Merging and Splitting Cells
0510 Clearing a Cell
0511 Finding and Replacing Data
0512 Using AutoFill
06 Customizing Excel 2007
0601 Customizing the Excel Workspace
0602 Splitting the Screen
0603 Freezing and Locking Cells
0604 Hiding and Showing Rows / Columns / Sheets
0605 Using Different Views
0606 Arranging Multiple Workbooks
0607 Displaying Gridlines and Headings
0608 Setting a Trusted Location
0609 Using Excel Options
07 Changing the Appearance of a Worksheet
0701 Formatting Options in the Ribbon
0702 Formatting Text
0703 Formatting Numbers
0704 Adding Borders
0705 Adding Fill Colors and Patterns
0706 Using the Format Painter
0707 Using Cell Styles
0708 Using Document Themes
0709 Using Wrap Text
0710 AutoCorrect
0711 Setting Page Layout Options
0712 Adding Headers and Footers
0713 Setting Page Breaks
0714 Using Templates
0715 Using Conditional Formatting
08 Working with Formulas
0801 Using Formulas
0802 Formula Writing Made Easy
0803 Creating Simple Formulas
0804 Order of Operations
0805 Creating Formulas with Operators and Cell References
0806 Understanding Cell References
0807 Calculating Totals with AutoSum
0808 Common Functions
0809 Creating Formulas with Functions
0810 Creating Formulas with Nested Functions
0811 Creating and Managing Names
0812 Creating Formulas with Names
0813 Displaying and Printing Formulas
0814 Error Checking
0815 Common Errors When Creating Formulas
09 Managing Data
0901 Overview of Excel Data Handling Tools
0902 Creating an Excel Table
0903 Sorting an Excel Table
0904 Filtering an Excel Table
0905 Formatting Excel Table Data
0906 Working with Excel Table Rows and Columns
0907 Displaying and Calculating Table Data Totals
0908 Using Structured References
0909 Validating Data
0910 Linking Data Between Worksheets
0911 Linking Data Between Multiple Workbooks
0912 Exporting Data
10 Charts and Graphics
1001 Overview of Charts and Excel
1002 Understanding Chart Types
1003 Creating a Chart
1004 Changing the Chart Type of an Existing Chart
1005 Moving and Deleting a Chart
1006 Changing the Charted Data
1007 Editing Charts
1008 Formatting a Chart - Design Tab
1009 Formatting a Chart - Layout Tab
1010 Formatting a Chart - Format Tab
1011 Creating a Chart Template
1012 Applying a Chart Template
1013 Importing Graphics into Excel
1014 Modifying Imported Images
11 Excel 2007 Plays Well with Others
1101 Overview of Sharing and Collaborating
1102 Excel and Other Office Applications
1103 Using the Office Clipboard
1104 Creating PDF Files
1105 Opening and Saving Files in Other Formats
1106 Excel and Databases
1107 Using Queries
1108 Using with a Document Management Server
1109 Publishing an Excel Worksheet
1110 Excel XML Files
1111 Wrap Up
12 Credits
1201 About This Author
sku |
|
