Excel Managing Databases

This class will provide you with tools for managing databases and database type data in Excel. Learn formulas, analysis tools, and macros to automate repetitive operations.

Training Class Goal

Students will learn how to get the most out of Excel databases. They will learn how to analyze Excel data and better manage large amounts of data in Excel.

Prerequisites

Understanding of Excel fundamentals including formatting, navigation and basic formulas.

Excel Managing Databases Training Topics

• 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