Chapter 1 Creating Worksheets for Decision Makers Session 1.2 Getting Started Session 1.2 Entering Data, Saving Workbooks, and Printing Worksheets Chapter 2 Planning and Creating a Worksheet Session 2.1 Writing Formulas, Using Functions, and Copying and Moving Cell Contents Session 2.2 Printing and Documenting a Worksheet Chapter 3 Formatting a Worksheet Session 3.1 Aligning Data and Applying Character Formats Session 3.2 Advanced Formatting Chapter 4 Creating Charts Session 4.1 Creating an Excel Chart Session 4.2 Modifying and Improving a Chart Chapter 5 Exploring Excel's List Features Session 5.1 Creating and Using Lists Session 5.2 Creating Filters and Subtotals Session 5.3 Pivot Tables Chapter 6 Employing Functions Session 6.1 Using Data Validation, Names and IF and Index Functions Session 6.2 Using Financial and Date Functions Chapter 7 Developing Multiple Worksheet and Workbook Applications Session 7.1 Working with Multiple Worksheets Session 7.2 Working with Multiple Workbooks Chapter 8 Auditing, Sharing, Protecting, and Publishing Workbooks Session 8.1 Auditing a Workbook Session 8.2 Sharing a Workbook and Tracking Changes Session 8.3 Protecting and Publishing Workbooks Chapter 9 Using Data Tables and Scenarios Session 9.1 Creating and Using Data Tables Session 9.2 Using Scenarios Chapter 10 Using the Solver Session 10.1 Using Goal Seek Session 10.2 Solving Complex Problems Chapter 11 Importing Data Session 11.1 Importing Text Data and Web Data Session 11.2 Using Queries to Import Database Data Chapter 12 Automating Applications with Visual Basic Session 12.1 Creating Macros Session 12.2 Writing Sub Procedures and Custom Functions
