Advanced Data Entry and Formatting Techniques
Restricting cell entries
Applying custom number formats
Applying Conditional Formatting
Naming Ranges
Defining a Range name
Using a Range name in a Formula
Selecting a Range name
Using Advanced Functions
Using the VLOOKUP function
Using the HLOOKUP function
Using DSum and DAverage functions
Creating a Custom Workbook Template
Creating and modifying a Template
Basing a new workbook on a custom Template
Auditing a Worksheet
Tracing Precedents and Dependents
Tracing Errors
Watch and Evaluate formulas
Linking Multiple Workbooks
Entering a formula to link multiple workbooks |
Filtering and Summarising Worksheet Data
Adding Subtotals to a list
Applying an advanced Filter to a list
Outlining a worksheet
Analysing Data
Creating a Pivot table and Pivot chart
Creating and displaying a Scenario
Using the Analysis ToolPak
Using Solver
Importing and Exporting Data
Working with Excel and other Excel Users
Tracking changes
Sharing and Protecting workbooks
Merging revised copies of workbooks
Additional Advanced Excel Features
Using the Consolidation feature
Format Chart and Graphics
Modify File Properties |
