| |
| |
| |
| Getting Started with Excel | |
| |
| |
| Understanding Spreadsheets | |
| |
| |
| Planning a Workbook | |
| |
| |
| Working with Formulas | |
| |
| |
| Introducing Functions | |
| |
| |
| |
| Formatting a Workbook | |
| |
| |
| Formatting Data | |
| |
| |
| Formatting Worksheet Cells | |
| |
| |
| Working with Table Styles | |
| |
| |
| Introducing Conditional Formats | |
| |
| |
| |
| 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 | |
| |
| |
| |
| Working with Charts and Graphics | |
| |
| |
| Creating Charts | |
| |
| |
| Working on Chart Design | |
| |
| |
| Creating a Column Chart | |
| |
| |
| Creating a Line Chart | |
| |
| |
| |
| Working with Excel Tables, PivotTables, and PivotCharts | |
| |
| |
| Creating an Excel Table | |
| |
| |
| Sorting Data | |
| |
| |
| Filtering Data | |
| |
| |
| Analyzing Data with PivotTables | |
| |
| |
| |
| Managing Multiple Worksheets and Workbooks | |
| |
| |
| Grouping Worksheets | |
| |
| |
| Using 3-D References to Add Values Across Worksheets | |
| |
| |
| Linking Workbooks | |
| |
| |
| Creating a Custom Workbook Template | |
| |
| |
| |
| Using Advanced Functions, Conditional Formatting, and Filtering | |
| |
| |
| Creating Nested IF Functions | |
| |
| |
| Using Lookup Tables and Functions | |
| |
| |
| Summarizing Data Conditionally | |
| |
| |
| Using Advanced Filtering | |
| |
| |
| |
| Developing an Excel Application | |
| |
| |
| Naming Cells and Ranges | |
| |
| |
| Validating Data Entry | |
| |
| |
| Protecting a Worksheet and Workbook | |
| |
| |
| Recording a Macro | |
| |
| |
| |
| Developing a Financial Analysis | |
| |
| |
| Working with Loans and Mortgages | |
| |
| |
| Projecting Future Income and Expenses | |
| |
| |
| Auditing a Workbook | |
| |
| |
| |
| Performing What-If Analyses | |
| |
| |
| Working with What-If Analysis and Goal Seek | |
| |
| |
| Using Scenario Manager | |
| |
| |
| Finding an Optimal Solution Using Solver | |
| |
| |
| |
| Connecting to External Data | |
| |
| |
| Working with Text Files | |
| |
| |
| Using the Query Wizard | |
| |
| |
| Creating a Web Query | |
| |
| |
| |
| Expanding Excel with Visual Basic for Applications | |
| |
| |
| Working with the Visual Basic Editor | |
| |
| |
| Retrieving Information from the User | |
| |
| |
| Creating a Message Box | |