| Working with Advanced Formulas
Using names
Using decision-making functions
Creating nested functions
Using financial functions Lookups and Data Tables
Working with lookup functions
Creating data tables Advanced List Management
Creating subtotals
Validating cell entries
Exploring database functions Working with PivotTables and PivotCharts
Working with PivotTables
Rearranging PivotTables
Formatting PivotTables
Working with PivotCharts Exporting and Importing | Exporting and importing text files
Querying external databases Using Analytical Options
Working with Goal Seek and Solver
Working with scenarios
Working with views Working with Macros
Running and recording a macro
Viewing VBA code
Function procedures Interactive Web Pages
Creating interactive Web spreadsheets
Publishing PivotTables on the Web |
No comments:
Post a Comment