New Perspectives on Microsoft Office Excel 2007, Comprehensive Video Companion DVD / Edition 1by June Jamrich Parsons, Roy Ageloff, Patrick Carey, Dan Oja
Pub. Date: 07/10/2009
Publisher: Cengage Learning
Learn and retain the most challenging and important topics of Microsoft Office Excel 2007 using a medium that you probably use daily: video! NEW PERSPECTIVES ON MICROSOFT OFFICE EXCEL 2007, COMPREHENSIVE, VIDEO COMPANION contains 45 illustrative videos between 5-7 minutes in length that go beyond simply showing how to complete tasks. Each video begins with a
Learn and retain the most challenging and important topics of Microsoft Office Excel 2007 using a medium that you probably use daily: video! NEW PERSPECTIVES ON MICROSOFT OFFICE EXCEL 2007, COMPREHENSIVE, VIDEO COMPANION contains 45 illustrative videos between 5-7 minutes in length that go beyond simply showing how to complete tasks. Each video begins with a conceptual explanation and then is followed by a practical demonstration of that skill within the application. This video companion maps directly to the New Perspectives on Microsoft Office Excel 2007, Comprehensive textbook.
Table of Contents
Tutorial 1: Getting Started with Excel. Understanding Spreadsheets. Planning a Workbook. Working with Formulas. Introducing Functions. Tutorial 2: Formatting a Workbook. Formatting Data. Formatting Worksheet Cells. Working with Table Styles. Introducing Conditional Formats. Tutorial 3: Working with Formulas and Functions. Understanding Cell References When Copying Formulas. Understanding Function Syntax. Working with AutoFill. Working with Logical Functions. Working with Financial Functions. Tutorial 4: Working with Charts and Graphics. Creating Charts. Working on Chart Design. Creating a Column Chart. Creating a Line Chart. Tutorial 5: Working with Excel Tables, PivotTables, and PivotCharts. Creating an Excel Table. Sorting Data. Filtering Data. Analyzing Data with PivotTables. Tutorial 6: Managing Multiple Worksheets and Workbooks. Grouping Worksheets. Using 3-D References to Add Values Across Worksheets. Linking Workbooks. Creating a Custom Workbook Template. Tutorial 7: Using Advanced Functions, Conditional Formatting, and Filtering. Creating Nested IF Functions. Using Lookup Tables and Functions. Summarizing Data Conditionally. Using Advanced Filtering. Tutorial 8: Developing an Excel Application. Naming Cells and Ranges. Validating Data Entry. Protecting a Worksheet and Workbook. Recording a Macro. Tutorial 9: Developing a Financial Analysis. Working with Loans and Mortgages. Projecting Future Income and Expenses. Auditing a Workbook. Tutorial 10: Performing What-If Analyses. Working with What-If Analysis and Goal Seek. Using Scenario Manager. Finding an Optimal Solution Using Solver. Tutorial 11: Connecting to External Data. Working with Text Files. Using the Query Wizard. Creating a Web Query. Tutorial 12: Expanding Excel with Visual Basic for Applications. Working with the Visual Basic Editor. Retrieving Information from the User. Creating a Message Box.
and post it to your social network
Most Helpful Customer Reviews
See all customer reviews >