Module 1. Custom Formats

• Text
• Numbers
• Date

Module 2. Cell Fill

• With Numbers
• Dates
• Time
• Text

Module 3. Conditional Formatting

• With Text
• With Dates
• Values
• Icons

Module 4. Validating Data Capture

• Creating Validations
• Adding Informative Messages for Capture
• Adding Custom Capture Error Messages

Module 5. Formulas and Functions

• Differences between Formulas and Functions
• Applying Functions
• Logical IF Functions
• Nested IF
• Lookup Functions
• VLookup
• HLookup
• Database

Module 6. Convert Text to Columns

• Text Separation
• Convert to Date

Module 7. Sorting Information

• Sorting Information Types in Ascending and Descending Order:
• Alphabetical
• Numeric
• Chronological

Module 8. Filtering Information

• AutoFilter
• Advanced Filters

Module 9. Creating and Removing Subtotals

Module 10. Charts

• Most Common Charts
• Bar Chart
• Secondary Axis
• Chart Menu Tools
• Optional Chart
• Choropleth Maps
• 3D Maps

Module 11. Table

• Table Properties
• Table Design
• Table Menu

Module 12. Security

• Protecting Workbooks and Files
• Hiding and Showing Workbooks
• Protecting and Unprotecting Worksheets
• Hiding and Showing Sheets Calculation
• Locking and Unlocking Chart Objects
• Spreadsheet-Level Security
• Unlocking Cell Ranges
• Hiding and Showing Formulas

Module 13. Lists

• Creating a List
• Removing a List
• Linking a List to Functions
• Applying Totals to a List

Module 14. Hyperlinks

• Creating Hyperlinks
• Creating Hyperlinks from Text
• Creating Hyperlinks from Images
• Removing Hyperlinks
• Using Hyperlinks

Module 15. Consolidating Information

• Working with Multiple Workbooks

Module 16. Retrieving External Data

• From Text
• From the Web
• Access
• ODBC
• From the Web
• Combining Queries

Module 17. Analysis

• Goal Seek
• Scenarios
• Solver
• Forecasting

Module 18. PivotTables and Charts

• Design Area, Row, Column, Page, and Data
• Create a PivotTable
• Formatting
• Filters
• Calculated Fields
• Calculated Items
• Create a PivotChart
• Calculated Item Fields
• Slicer
• Timeline
• Move PivotTable
• Get Pivot Data Function

Module 19. Power Pivot

• Add Power Pivot Tab
• Power Pivot Window
• Import Access Database
• Diagram View
• Link Data
• Create PivotTable
• Calculated Fields

Module 20. Macros

• What is a Macro? • Macro Recorder
• Ways to Run a Macro
• Introduction to Excel VB
• Create a Custom Function
• Automate a Report
• Display External Images
• Create an Application with Macros
• Create PowerPoint Slides from an Excel Database