Date: 28 April 2011, 06:27
|
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!!!
|
DISCLAIMER:
This site does not store VTC - Excel 2007 on its server. We only index and link to VTC - Excel 2007 provided by other sites. Please contact the content providers to delete VTC - Excel 2007 if any and email us, we'll remove relevant links or contents immediately.