Course Outline:
Section 1: Enhancing Workbooks
Section 1.1: Customizing Workbooks
Section 1.2: Preparing a Workbook for Multiple Audiences
Section 1.3: Managing Themes
Section 1.4: Creating and Using Templates
Section 2: Working with Multiple Workbooks
Section 2.1: Consolidating Data
Section 2.2: Linking Cells in Workbooks
Section 2.3: Merging Workbooks
Section 3: Analyzing and Presenting Data Section 3.1: Create Sparklines
Section 3.2: Create Scenarios
Section 3.3: Perform A What-if Analysis
Section 3.4: Perform A Statistical Analysis with the Analysis Toolpak
Section 4: Importing and Exporting Excel Data
Section 4.1: Exporting Excel Data
Section 4.2: Importing a Delimited Text File
Section 5: Analyzing Data with Pivot Tables, Slicers, and Pivot Charts
Section 5.1: Creating a Pivot Table
Section 5.2: Filtering Pivot Table Data
Section 6: Automating Worksheet Functionality
Section 6.1: Updating Workbook Properties Workbook Properties
Section 6.3: Applying Conditional Formatting
Section 6.4: Adding Data Validation Criteria
PAYMENT
For payment information email:
[email protected]