ADVANCED CALCULATIONS
- Using Lookup Functions
- Using Text Functions
- Breaking Apart Text Entries
- Using Date & Time Functions
- Using the Net Workdays Function
- Using Logical Functions & Fixing Errors
- Using Text in Calculations
- Using Financial Functions
- Using the Cumulative Interest Payment Function
10.Using Aggregate vs. Math Functions
SUBTOTALS & OUTLINES
- Creating Subtotals
- Working with Outlined Data
- Manually Creating Subtotals & Outlines
- Creating Custom Views
PIVOTTABLES
- Constructing PivotTables
- Modifying PivotTable Calculations
- Setting PivotTable Properties
- Using Filters & Slicers in the PivotTable
- Using the Report Filter & Updating Data
- Working with PivotTable Data in Formulas &PivotCharts
ADAPTING CHARTS FOR COMPLEX DATA
- Adding a Secondary Chart Axis
- Working with a Scatter Chart
- Hidden & Empty Cell Settings, Formatting Error Bars
- Adding a Trendline
|
|
ADVANCED DATA TOOLS
- Importing Data & Adding Hyperlinks
- Converting Text to Columns
- Linking to Databases & Removing Duplicate Records
- Consolidating Data
- Validating & Protecting Data
AUDITING CALCULATED VALUES
- Working with Circular References
- Tracing Precedents & Dependents
- Evaluating Formulas
- Using the Watch Window
- Error Checking
PERFORMING A WHAT-IF ANALYSIS
- Finding an Input Value with Goal Seek
- Displaying Options via Scenarios
- Including Variable Values through Data Tables
MACROS, VBA & SECURITY
- Macro Concepts
- Creating a Basic Macro
- Manipulating Cell & Range References
- A Brief Introduction to VBA
- Viewing & Editing VBA in Excel
- Making Macros Accessible
- Applying Security Settings
|