Working with Multiple Worksheets and Workbooks
Using multiple worksheets
· Navigating between sheets
· Moving and copying sheets
· Linking worksheets
· Creating 3-D formulas
· Consolidating data
· Linking workbooks
· Creating a formula to link workbooks
· Using the paste link option
· Maintaining links
Using logical functions
·Naming ranges
·Creating named ranges
·Using named ranges in formulas
·The IF function (recap)
·Creating nested IF functions
·AND and OR functions
·Combining logical functions
Working with lookups
·The VLOOKUP function
Functions
·Creating a dropdown list using logical functions
·PMT
·AND
·OR
·INDEX
·MATCH
PivotTables and PivotCharts
·Using the PivotTable Wizard
·Rearranging PivotTables
·Using the PivotTable toolbar
·Creating PivotCharts
·Using Slicers to manipulate PivotTables
Using analytical options
·Using Goal Seek
·Using the solver add-in
·Working with scenarios
·Creating and saving scenarios
·Viewing screnarios
·The HLOOKUP function
Conditional formulas and formatting
·The IF function
·Conditional Formatting
·Based on a cell value
·Based on a formula
·Identifying cells with conditional formatting
·Copying conditional formats
Macros
·Creating macros
·Using the macro recorder
·Viewing and editing macro VBA code
|
