Managing Databases with Excel

Topic Covered

    Database Management Tools
        Arranging Data
        Filtering Data
        Conditional Formatting
        Sparklines
        Watch Window
        Group and Summarize Data
        Subtotal Data
        Removing Duplicates
        Custom Views
        Excel Workspace
        Page Break Preview
    Functions & Formulas
        Financial Functions and Data Tables
        Database functions
        Reference Functions
        Other classes covering functions
    What-If Analysis Tools
        Goal Seek
        Solver
        Scenarios
        Other classes covering IF Statements
    Macros
        Planning & Recording
        Running
        Viewing and Editing VBA Code
        Saving
    Collaboration Tools
        Tracking changes
        Sharing and Merging Workbooks