| Code: |
Author(s): Cheryl Brumbaugh Duncan
Date : 2007-10-30
Video Duration: 8 hrs / 115 tutorials
Format : ISO
Quality : Excellent
Language : English
ISBN-10 : 1934743216 |
Details of content covered:
Introduction to Excel 2007
Welcome to Excel 2007 (02:26)
Overview of Spreadsheets and Excel 2007 (01:47)
Overview of Course (03:18)
New in Excel 2007 pt. 1 (05:51)
New in Excel 2007 pt. 2 (04:56)
Understanding the Excel 2007 Workspace (04:34)
Introducing the New Excel 2007 Ribbon (06:21)
Using the Quick Access Toolbar (03:58)
Compatibility with Earlier Versions (05:32)
Installing Excel 2007
Considerations Before You Install (02:10)
Installing Excel (03:14)
Microsoft Excel 2007 He|p
Accessing Microsoft Excel 2007 He|p (00:42)
Using Excel 2007 He|p (03:45)
Using Microsoft Office On-line (02:07)
Accessing the Support Knowledge Base (01:48)
Working with Worksheets and Workbooks
Launching Excel (03:29)
Planning a Project (02:59)
Creating a New Workbook (05:18)
Adding and Deleting Data (04:58)
Importing Data into Excel (06:30)
Naming and Saving a Workbook (03:31)
Managing Multiple Worksheets (06:04)
Printing a Worksheet pt. 1 (02:22)
Printing a Worksheet pt. 2 (06:37)
Opening and Closing a Workbook (03:42)
Renaming and Deleting a Workbook (02:49)
Editing Techniques
Selecting Cells / Rows / Columns (03:47)
Cut / Copy / Paste (06:10)
Copy and Paste Special (03:29)
Editing or Replacing Content in a Cell (04:13)
Undo / Redo / Repeat Edits (05:57)
Adjusting Row Height (05:07)
Adjusting Column Width (02:55)
Inserting and Deleting Rows / Columns / Cells (05:55)
Merging and Splitting Cells (03:48)
Clearing a Cell (02:39)
Finding and Replacing Data (05:07)
Using AutoFill (05:12)
Customizing Excel 2007
Customizing the Excel Workspace (03:59)
Splitting the Screen (06:29)
Freezing and Locking Cells (04:35)
Hiding and Showing Rows / Columns / Sheets (04:35)
Using Different Views (04:41)
Arranging Multiple Workbooks (04:41)
Displaying Gridlines and Headings (04:23)
Setting a Trusted Location (03:51)
Using Excel Options (03:45)
Changing the Appearance of a Worksheet
Formatting Options in the Ribbon (02:57)
Formatting Text (06:18)
Formatting Numbers (04:02)
Adding Borders (05:26)
Adding Fill Colors and Patterns (05:09)
Using the Format Painter (05:02)
Using Cell Styles (03:20)
Using Document Themes (04:04)
Using Wrap Text (02:15)
AutoCorrect (03:48)
Setting Page Layout Options (04:20)
Adding Headers and Footers (04:59)
Setting Page Breaks (05:49)
Using Templates (03:58)
Using Conditional Formatting (04:28)
Working with Formulas
Using Formulas (04:03)
Formula Writing Made Easy (05:12)
Creating Simple Formulas (02:20)
Order of Operations (03:36)
Creating Formulas with Operators and Cell References (05:21)
Understanding Cell References (03:21)
Calculating Totals with AutoSum (07:03)
Common Functions (06:43)
Creating Formulas with Functions (07:14)
Creating Formulas with Nested Functions (07:09)
Creating and Managing Names (06:50)
Creating Formulas with Names (02:49)
Displaying and Printing Formulas (02:15)
Error Checking (05:19)
Common Errors When Creating Formulas (02:47)
Managing Data
Overview of Excel Data Handling Tools (01:09)
Creating an Excel Table (05:25)
Sorting an Excel Table (02:32)
Filtering an Excel Table (03:15)
Formatting Excel Table Data (02:27)
Working with Excel Table Rows and Columns (05:48)
Displaying and Calculating Table Data Totals (03:26)
Using Structured References (02:31)
Validating Data (07:04)
Linking Data Between Worksheets (05:19)
Linking Data Between Multiple Workbooks (06:24)
Exporting Data (04:59)
Charts and Graphics
Overview of Charts and Excel (02:14)
Understanding Chart Types (02:56)
Creating a Chart (06:06)
Changing the Chart Type of an Existing Chart (03:55)
Moving and Deleting a Chart (02:56)
Changing the Charted Data (06:04)
Editing Charts (04:20)
Formatting a Chart - Design Tab (04:16)
Formatting a Chart - Layout Tab (07:03)
Formatting a Chart - Format Tab (04:45)
Creating a Chart Template (03:02)
Applying a Chart Template (02:15)
Importing Graphics into Excel (07:06)
Modifying Imported Images (05:02)
Excel 2007 Plays Well with Others
Overview of Sharing and Collaborating (01:48)
Excel and Other Office Applications (07:18)
Using the Office Clipboard (03:40)
Creating PDF Files (02:53)
Opening and Saving Files in Other Formats (03:08)
Excel and Databases (02:34)
Using Queries (04:12)
Using with a Document Management Server (02:21)
Publishing an Excel Worksheet (01:06)
Excel XML Files (02:58)
Wrap Up (01:50)
Credits
About This Author (02:41)
Video Duration: 8 hrs / 115 tutorials bundled in an ISO format (9 parts), will require quicktime player for playing these files.
Thanks and all credits to the original uploader.
Enjoy!!!
| Code: |
http://rapidshare.com/files/297602523/Microsoft.Excel.2007_videos_.part01.rar
http://rapidshare.com/files/297603052/Microsoft.Excel.2007_videos_.part02.rar
http://rapidshare.com/files/297617680/Microsoft.Excel.2007_videos_.part03.rar
http://rapidshare.com/files/297617781/Microsoft.Excel.2007_videos_.part04.rar
http://rapidshare.com/files/297628427/Microsoft.Excel.2007_videos_.part05.rar
http://rapidshare.com/files/297793140/Microsoft.Excel.2007_videos_.part06.rar
http://rapidshare.com/files/298191801/Microsoft.Excel.2007_videos_.part07.rar
http://rapidshare.com/files/298209310/Microsoft.Excel.2007_videos_.part08.rar
http://rapidshare.com/files/298205930/Microsoft.Excel.2007_videos_.part09.rar
|