Excel Managing Databases

Excel Managing Databases

Course Description

Managing Databases in Excel

excel_tipThis class is for people who have to manage large tables of data within Excel. This class will teach students how to manage databases in Excel, and the tools and formulas that work best in dealing with this type of data. The class looks at database functions, macros, analysis tools, and viewing tips, to best work with large amounts of data.

Training Class Goal

Do you feel like you have rows and rows of data and it’s hard to make heads or tails of it? This class will help you learn how to manage databases in Excel and get the most out of them. You will learn how to analyze Excel data and how to better manage large tables of data in Excel. You will learn the most useful database functions in Excel to help you add, average, count and find information in your rows. You will learn how to use macros, which can help you automate repetitive steps in large lists of data.

PreRequisites

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

Topics Covered

Database Management Tools

  • Arranging and viewing large amounts of 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
  • The Amortization tool
  • Data Tables
  • Data Consolidation tools
  • Naming cell ranges
  • Database functions
  • Reference Functions
  • Other classes covering functions

What-If Analysis Tools

  • Goal Seek
  • Solver
  • Scenarios
  • Analysis toolpack

Macros

  • Planning & Recording
  • Running
  • Viewing and Editing VBA Code
  • Saving

Collaboration Tools

  • Tracking changes
  • Sharing and Merging Workbooks

Learn how to manage databases in Excel with this class. Learn the tools that will help your large amounts of data seem more manageable and easier to sort through and analyze. Understand what functions work best with large tables, and how you can automate repetitive steps with simple macros.

 

Upcoming Classes

Excel Managing Databases
Jul 17 8:00 am - 4:00 pm Excel Managing Databases Tech Center Excel Managing Databases Excel Managing Databases Training in Denver & Phoenix Class Price: $410 What’s included – a $1,500 value with: Face-to-face, live interactive class Retake – allows you to retake the entire... Mission Critical Systems 17-07-2018T08:00 17-07-2018T16:00 Active
Active 17-07-2018 Active 410.00 17-07-2018
Register Now
Excel Managing Databases
Aug 27 8:00 am - 4:00 pm Excel Managing Databases Phoenix Excel Managing Databases Excel Managing Databases Training in Denver & Phoenix Class Price: $410 What’s included – a $1,500 value with: Face-to-face, live interactive class Retake – allows you to retake the entire... Mission Critical Systems 27-08-2018T08:00 27-08-2018T16:00 Active
Active 27-08-2018 Active 410.00 27-08-2018
Register Now
Excel Managing Databases
Nov 7 8:00 am - 4:00 pm Excel Managing Databases Westminster Excel Managing Databases Excel Managing Databases Training in Denver & Phoenix Class Price: $410 What’s included – a $1,500 value with: Face-to-face, live interactive class Retake – allows you to retake the entire... Mission Critical Systems 07-11-2018T08:00 07-11-2018T16:00 Active
Active 07-11-2018 Active 410.00 07-11-2018
Register Now
Excel Managing Databases
Dec 6 8:00 am - 4:00 pm Excel Managing Databases Phoenix Excel Managing Databases Excel Managing Databases Training in Denver & Phoenix Class Price: $410 What’s included – a $1,500 value with: Face-to-face, live interactive class Retake – allows you to retake the entire... Mission Critical Systems 06-12-2018T08:00 06-12-2018T16:00 Active
Active 06-12-2018 Active 410.00 06-12-2018
Register Now

Bookings are closed for this class.

Live & In-Person

All of the classes on this page are taught by live instructors who are present in the classroom.