Excel Managing Databases

Course Description

Excel Databases Training in Denver & Phoenix

excel_tip

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, as well as better manage large tables of it. 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. Your instructor will be available to address all of your questions and lead you to a mastery of managing databases in Excel. Learn more about Excel training in Denver & Phoenix through Mission Critical.

Class Price: $410

Training Class Goal

This Excel Database class is for people who have to regularly manage large tables of data within Excel. Upon completing this course, students will know how to manage databases in Excel and have a mastery of the tools and formulas that work best in dealing with large sets of information. Students will gain an understanding of database functions, macros, analysis tools, and viewing tips, to best work with large amounts of data.

PreRequisites

Students must already have an 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 of tool pack

Macros

  • Planning and 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 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. Become a master of working with databases in Excel.

 

Upcoming Classes

Excel Basic
Sep 26 8:00 am - 12:00 pm Excel Basic Tech Center Excel Basic Excel Basic Training in Denver & Phoenix Class Price: $250 What’s included – a $1,180 value with: Face-to-face, live interactive class Retake – allows you to retake the entire class... Mission Critical Systems 26-09-2019T08:00 26-09-2019T12:00 Active
26-09-2019 Active 250.00 26-09-2019
Register Now
Excel Basic
Sep 26 8:00 am - 12:00 pm Excel Basic Phoenix Excel Basic Excel Basic Training in Denver & Phoenix Class Price: $250 What’s included – a $1,180 value with: Face-to-face, live interactive class Retake – allows you to retake the entire class... Mission Critical Systems 26-09-2019T08:00 26-09-2019T12:00 Active
26-09-2019 Active 250.00 26-09-2019
Register Now
Excel Basic
Oct 7 8:00 am - 12:00 pm Excel Basic Westminster Excel Basic Excel Basic Training in Denver & Phoenix Class Price: $250 What’s included – a $1,180 value with: Face-to-face, live interactive class Retake – allows you to retake the entire class... Mission Critical Systems 07-10-2019T08:00 07-10-2019T12:00 Active
07-10-2019 Active 250.00 07-10-2019
Register Now
Excel Basic
Oct 21 8:00 am - 12:00 pm Excel Basic Phoenix Excel Basic Excel Basic Training in Denver & Phoenix Class Price: $250 What’s included – a $1,180 value with: Face-to-face, live interactive class Retake – allows you to retake the entire class... Mission Critical Systems 21-10-2019T08:00 21-10-2019T12:00 Active
21-10-2019 Active 250.00 21-10-2019
Register Now
Excel Basic
Oct 22 8:00 am - 12:00 pm Excel Basic Tech Center Excel Basic Excel Basic Training in Denver & Phoenix Class Price: $250 What’s included – a $1,180 value with: Face-to-face, live interactive class Retake – allows you to retake the entire class... Mission Critical Systems 22-10-2019T08:00 22-10-2019T12:00 Active
22-10-2019 Active 250.00 22-10-2019
Register Now
Excel Macros
Oct 22 1:00 pm - 5:00 pm Excel Macros Phoenix Excel Macros Excel Macros Training in Denver & Phoenix Class Price: $250 What’s included – a $1,180 value with: Face-to-face, live interactive class Retake – allows you to retake the entire class... Mission Critical Systems 22-10-2019T13:00 22-10-2019T17:00 Active
22-10-2019 Active 250.00 22-10-2019
Register Now
Excel Macros
Oct 24 1:00 pm - 5:00 pm Excel Macros Tech Center Excel Macros Excel Macros Training in Denver & Phoenix Class Price: $250 What’s included – a $1,180 value with: Face-to-face, live interactive class Retake – allows you to retake the entire class... Mission Critical Systems 24-10-2019T13:00 24-10-2019T17:00 Active
24-10-2019 Active 250.00 24-10-2019
Register Now
Excel Basic
Nov 6 8:00 am - 12:00 pm Excel Basic Westminster Excel Basic Excel Basic Training in Denver & Phoenix Class Price: $250 What’s included – a $1,180 value with: Face-to-face, live interactive class Retake – allows you to retake the entire class... Mission Critical Systems 06-11-2019T08:00 06-11-2019T12:00 Active
06-11-2019 Active 250.00 06-11-2019
Register Now
Excel Basic
Nov 13 1:00 pm - 5:00 pm Excel Basic Phoenix Excel Basic Excel Basic Training in Denver & Phoenix Class Price: $250 What’s included – a $1,180 value with: Face-to-face, live interactive class Retake – allows you to retake the entire class... Mission Critical Systems 13-11-2019T13:00 13-11-2019T17:00 Active
13-11-2019 Active 250.00 13-11-2019
Register Now
Excel Basic
Nov 18 8:00 am - 12:00 pm Excel Basic Tech Center Excel Basic Excel Basic Training in Denver & Phoenix Class Price: $250 What’s included – a $1,180 value with: Face-to-face, live interactive class Retake – allows you to retake the entire class... Mission Critical Systems 18-11-2019T08:00 18-11-2019T12:00 Active
18-11-2019 Active 250.00 18-11-2019
Register Now
Excel Pivot Tables and Charts
Nov 19 1:00 pm - 5:00 pm Excel Pivot Tables and Charts Tech Center Excel Pivot Tables and Charts Excel Pivot Tables and Charts Training in Denver & Phoenix Class Price: $250 What’s included – a $1,180 value with: Face-to-face, live interactive class Retake – allows you to retake... Mission Critical Systems 19-11-2019T13:00 19-11-2019T17:00 Active
19-11-2019 Active 250.00 19-11-2019
Register Now
Excel Basic
Dec 4 8:00 am - 12:00 pm Excel Basic Westminster Excel Basic Excel Basic Training in Denver & Phoenix Class Price: $250 What’s included – a $1,180 value with: Face-to-face, live interactive class Retake – allows you to retake the entire class... Mission Critical Systems 04-12-2019T08:00 04-12-2019T12:00 Active
04-12-2019 Active 250.00 04-12-2019
Register Now
Excel Basic
Dec 13 8:00 am - 12:00 pm Excel Basic Phoenix Excel Basic Excel Basic Training in Denver & Phoenix Class Price: $250 What’s included – a $1,180 value with: Face-to-face, live interactive class Retake – allows you to retake the entire class... Mission Critical Systems 13-12-2019T08:00 13-12-2019T12:00 Active
13-12-2019 Active 250.00 13-12-2019
Register Now
Excel Basic
Dec 16 8:00 am - 12:00 pm Excel Basic Tech Center Excel Basic Excel Basic Training in Denver & Phoenix Class Price: $250 What’s included – a $1,180 value with: Face-to-face, live interactive class Retake – allows you to retake the entire class... Mission Critical Systems 16-12-2019T08:00 16-12-2019T12:00 Active
16-12-2019 Active 250.00 16-12-2019
Register Now
Excel Basic
Jan 6 8:00 am - 12:00 pm Excel Basic Westminster Excel Basic Excel Basic Training in Denver & Phoenix Class Price: $250 What’s included – a $1,180 value with: Face-to-face, live interactive class Retake – allows you to retake the entire class... Mission Critical Systems 06-01-2020T08:00 06-01-2020T12:00 Active
06-01-2020 Active 250.00 06-01-2020
Register Now
Excel Pivot Tables and Charts
Jan 9 8:00 am - 12:00 pm Excel Pivot Tables and Charts Tech Center Excel Pivot Tables and Charts Excel Pivot Tables and Charts Training in Denver & Phoenix Class Price: $250 What’s included – a $1,180 value with: Face-to-face, live interactive class Retake – allows you to retake... Mission Critical Systems 09-01-2020T08:00 09-01-2020T12:00 Active
09-01-2020 Active 250.00 09-01-2020
Register Now
Excel Basic
Jan 22 8:00 am - 12:00 pm Excel Basic Tech Center Excel Basic Excel Basic Training in Denver & Phoenix Class Price: $250 What’s included – a $1,180 value with: Face-to-face, live interactive class Retake – allows you to retake the entire class... Mission Critical Systems 22-01-2020T08:00 22-01-2020T12:00 Active
22-01-2020 Active 250.00 22-01-2020
Register Now
Excel Basic
Feb 4 8:00 am - 12:00 pm Excel Basic Westminster Excel Basic Excel Basic Training in Denver & Phoenix Class Price: $250 What’s included – a $1,180 value with: Face-to-face, live interactive class Retake – allows you to retake the entire class... Mission Critical Systems 04-02-2020T08:00 04-02-2020T12:00 Active
04-02-2020 Active 250.00 04-02-2020
Register Now
Excel Basic
Feb 18 8:00 am - 12:00 pm Excel Basic Tech Center Excel Basic Excel Basic Training in Denver & Phoenix Class Price: $250 What’s included – a $1,180 value with: Face-to-face, live interactive class Retake – allows you to retake the entire class... Mission Critical Systems 18-02-2020T08:00 18-02-2020T12:00 Active
18-02-2020 Active 250.00 18-02-2020
Register Now
Excel Lookups
Feb 21 11:00 am - 12:00 pm Excel Lookups Webinar Excel Lookups Excel Lookups Learn all about the power Excel functions called lookups. This class will explain the different varieties and how to use them. Class Price: $59 Training Class Goal Students... Mission Critical Systems 21-02-2020T11:00 21-02-2020T12:00 Active
21-02-2020 Active 0.00 21-02-2020
Register Now
Excel Basic
Mar 3 8:00 am - 12:00 pm Excel Basic Westminster Excel Basic Excel Basic Training in Denver & Phoenix Class Price: $250 What’s included – a $1,180 value with: Face-to-face, live interactive class Retake – allows you to retake the entire class... Mission Critical Systems 03-03-2020T08:00 03-03-2020T12:00 Active
03-03-2020 Active 250.00 03-03-2020
Register Now
Excel Pivot Tables and Charts
Mar 4 1:00 pm - 5:00 pm Excel Pivot Tables and Charts Westminster Excel Pivot Tables and Charts Excel Pivot Tables and Charts Training in Denver & Phoenix Class Price: $250 What’s included – a $1,180 value with: Face-to-face, live interactive class Retake – allows you to retake... Mission Critical Systems 04-03-2020T13:00 04-03-2020T17:00 Active
04-03-2020 Active 250.00 04-03-2020
Register Now
Excel Basic
Mar 17 8:00 am - 12:00 pm Excel Basic Tech Center Excel Basic Excel Basic Training in Denver & Phoenix Class Price: $250 What’s included – a $1,180 value with: Face-to-face, live interactive class Retake – allows you to retake the entire class... Mission Critical Systems 17-03-2020T08:00 17-03-2020T12:00 Active
17-03-2020 Active 250.00 17-03-2020
Register Now
Excel Basic
Mar 30 1:00 pm - 5:00 pm Excel Basic Westminster Excel Basic Excel Basic Training in Denver & Phoenix Class Price: $250 What’s included – a $1,180 value with: Face-to-face, live interactive class Retake – allows you to retake the entire class... Mission Critical Systems 30-03-2020T13:00 30-03-2020T17:00 Active
30-03-2020 Active 250.00 30-03-2020
Register Now
Excel Basic
Apr 14 8:00 am - 12:00 pm Excel Basic Tech Center Excel Basic Excel Basic Training in Denver & Phoenix Class Price: $250 What’s included – a $1,180 value with: Face-to-face, live interactive class Retake – allows you to retake the entire class... Mission Critical Systems 14-04-2020T08:00 14-04-2020T12:00 Active
14-04-2020 Active 250.00 14-04-2020
Register Now
Excel Basic
Apr 28 8:00 am - 12:00 pm Excel Basic Westminster Excel Basic Excel Basic Training in Denver & Phoenix Class Price: $250 What’s included – a $1,180 value with: Face-to-face, live interactive class Retake – allows you to retake the entire class... Mission Critical Systems 28-04-2020T08:00 28-04-2020T12:00 Active
28-04-2020 Active 250.00 28-04-2020
Register Now
Excel Macros
Apr 29 1:00 pm - 5:00 pm Excel Macros Westminster Excel Macros Excel Macros Training in Denver & Phoenix Class Price: $250 What’s included – a $1,180 value with: Face-to-face, live interactive class Retake – allows you to retake the entire class... Mission Critical Systems 29-04-2020T13:00 29-04-2020T17:00 Active
29-04-2020 Active 250.00 29-04-2020
Register Now
Excel Basic
May 12 8:00 am - 12:00 pm Excel Basic Tech Center Excel Basic Excel Basic Training in Denver & Phoenix Class Price: $250 What’s included – a $1,180 value with: Face-to-face, live interactive class Retake – allows you to retake the entire class... Mission Critical Systems 12-05-2020T08:00 12-05-2020T12:00 Active
12-05-2020 Active 250.00 12-05-2020
Register Now
Excel Pivot Tables and Charts
May 12 1:00 pm - 5:00 pm Excel Pivot Tables and Charts Tech Center Excel Pivot Tables and Charts Excel Pivot Tables and Charts Training in Denver & Phoenix Class Price: $250 What’s included – a $1,180 value with: Face-to-face, live interactive class Retake – allows you to retake... Mission Critical Systems 12-05-2020T13:00 12-05-2020T17:00 Active
12-05-2020 Active 250.00 12-05-2020
Register Now
Excel Basic
May 27 8:00 am - 12:00 pm Excel Basic Westminster Excel Basic Excel Basic Training in Denver & Phoenix Class Price: $250 What’s included – a $1,180 value with: Face-to-face, live interactive class Retake – allows you to retake the entire class... Mission Critical Systems 27-05-2020T08:00 27-05-2020T12:00 Active
27-05-2020 Active 250.00 27-05-2020
Register Now
Excel Basic
Jun 9 8:00 am - 12:00 pm Excel Basic Tech Center Excel Basic Excel Basic Training in Denver & Phoenix Class Price: $250 What’s included – a $1,180 value with: Face-to-face, live interactive class Retake – allows you to retake the entire class... Mission Critical Systems 09-06-2020T08:00 09-06-2020T12:00 Active
09-06-2020 Active 250.00 09-06-2020
Register Now
Excel Basic
Jun 23 8:00 am - 12:00 pm Excel Basic Westminster Excel Basic Excel Basic Training in Denver & Phoenix Class Price: $250 What’s included – a $1,180 value with: Face-to-face, live interactive class Retake – allows you to retake the entire class... Mission Critical Systems 23-06-2020T08:00 23-06-2020T12:00 Active
23-06-2020 Active 250.00 23-06-2020
Register Now
Excel Lookups
Jun 26 11:00 am - 12:00 pm Excel Lookups Webinar Excel Lookups Excel Lookups Learn all about the power Excel functions called lookups. This class will explain the different varieties and how to use them. Class Price: $59 Training Class Goal Students... Mission Critical Systems 26-06-2020T11:00 26-06-2020T12:00 Active
26-06-2020 Active 0.00 26-06-2020
Register Now
Excel Basic
Jul 8 8:00 am - 12:00 pm Excel Basic Tech Center Excel Basic Excel Basic Training in Denver & Phoenix Class Price: $250 What’s included – a $1,180 value with: Face-to-face, live interactive class Retake – allows you to retake the entire class... Mission Critical Systems 08-07-2020T08:00 08-07-2020T12:00 Active
08-07-2020 Active 250.00 08-07-2020
Register Now
Excel Basic
Jul 20 8:00 am - 12:00 pm Excel Basic Westminster Excel Basic Excel Basic Training in Denver & Phoenix Class Price: $250 What’s included – a $1,180 value with: Face-to-face, live interactive class Retake – allows you to retake the entire class... Mission Critical Systems 20-07-2020T08:00 20-07-2020T12:00 Active
20-07-2020 Active 250.00 20-07-2020
Register Now
Excel Pivot Tables and Charts
Jul 21 1:00 pm - 5:00 pm Excel Pivot Tables and Charts Westminster Excel Pivot Tables and Charts Excel Pivot Tables and Charts Training in Denver & Phoenix Class Price: $250 What’s included – a $1,180 value with: Face-to-face, live interactive class Retake – allows you to retake... Mission Critical Systems 21-07-2020T13:00 21-07-2020T17:00 Active
21-07-2020 Active 250.00 21-07-2020
Register Now
Excel Basic
Aug 3 8:00 am - 12:00 pm Excel Basic Tech Center Excel Basic Excel Basic Training in Denver & Phoenix Class Price: $250 What’s included – a $1,180 value with: Face-to-face, live interactive class Retake – allows you to retake the entire class... Mission Critical Systems 03-08-2020T08:00 03-08-2020T12:00 Active
03-08-2020 Active 250.00 03-08-2020
Register Now
Excel Basic
Aug 18 8:00 am - 12:00 pm Excel Basic Westminster Excel Basic Excel Basic Training in Denver & Phoenix Class Price: $250 What’s included – a $1,180 value with: Face-to-face, live interactive class Retake – allows you to retake the entire class... Mission Critical Systems 18-08-2020T08:00 18-08-2020T12:00 Active
18-08-2020 Active 250.00 18-08-2020
Register Now
Excel Basic
Aug 31 8:00 am - 12:00 pm Excel Basic Tech Center Excel Basic Excel Basic Training in Denver & Phoenix Class Price: $250 What’s included – a $1,180 value with: Face-to-face, live interactive class Retake – allows you to retake the entire class... Mission Critical Systems 31-08-2020T08:00 31-08-2020T12:00 Active
31-08-2020 Active 250.00 31-08-2020
Register Now
Excel Pivot Tables and Charts
Sep 1 1:00 pm - 5:00 pm Excel Pivot Tables and Charts Tech Center Excel Pivot Tables and Charts Excel Pivot Tables and Charts Training in Denver & Phoenix Class Price: $250 What’s included – a $1,180 value with: Face-to-face, live interactive class Retake – allows you to retake... Mission Critical Systems 01-09-2020T13:00 01-09-2020T17:00 Active
01-09-2020 Active 250.00 01-09-2020
Register Now
Excel Basic
Sep 14 8:00 am - 12:00 pm Excel Basic Westminster Excel Basic Excel Basic Training in Denver & Phoenix Class Price: $250 What’s included – a $1,180 value with: Face-to-face, live interactive class Retake – allows you to retake the entire class... Mission Critical Systems 14-09-2020T08:00 14-09-2020T12:00 Active
14-09-2020 Active 250.00 14-09-2020
Register Now
Excel Basic
Sep 29 8:00 am - 12:00 pm Excel Basic Tech Center Excel Basic Excel Basic Training in Denver & Phoenix Class Price: $250 What’s included – a $1,180 value with: Face-to-face, live interactive class Retake – allows you to retake the entire class... Mission Critical Systems 29-09-2020T08:00 29-09-2020T12:00 Active
29-09-2020 Active 250.00 29-09-2020
Register Now
Excel Basic
Oct 13 8:00 am - 12:00 pm Excel Basic Westminster Excel Basic Excel Basic Training in Denver & Phoenix Class Price: $250 What’s included – a $1,180 value with: Face-to-face, live interactive class Retake – allows you to retake the entire class... Mission Critical Systems 13-10-2020T08:00 13-10-2020T12:00 Active
13-10-2020 Active 250.00 13-10-2020
Register Now
Excel Lookups
Oct 23 11:00 am - 12:00 pm Excel Lookups Webinar Excel Lookups Excel Lookups Learn all about the power Excel functions called lookups. This class will explain the different varieties and how to use them. Class Price: $59 Training Class Goal Students... Mission Critical Systems 23-10-2020T11:00 23-10-2020T12:00 Active
23-10-2020 Active 0.00 23-10-2020
Register Now
Excel Basic
Oct 27 8:00 am - 12:00 pm Excel Basic Tech Center Excel Basic Excel Basic Training in Denver & Phoenix Class Price: $250 What’s included – a $1,180 value with: Face-to-face, live interactive class Retake – allows you to retake the entire class... Mission Critical Systems 27-10-2020T08:00 27-10-2020T12:00 Active
27-10-2020 Active 250.00 27-10-2020
Register Now
Excel Macros
Oct 28 1:00 pm - 5:00 pm Excel Macros Tech Center Excel Macros Excel Macros Training in Denver & Phoenix Class Price: $250 What’s included – a $1,180 value with: Face-to-face, live interactive class Retake – allows you to retake the entire class... Mission Critical Systems 28-10-2020T13:00 28-10-2020T17:00 Active
28-10-2020 Active 250.00 28-10-2020
Register Now
Excel Basic
Nov 9 8:00 am - 12:00 pm Excel Basic Westminster Excel Basic Excel Basic Training in Denver & Phoenix Class Price: $250 What’s included – a $1,180 value with: Face-to-face, live interactive class Retake – allows you to retake the entire class... Mission Critical Systems 09-11-2020T08:00 09-11-2020T12:00 Active
09-11-2020 Active 250.00 09-11-2020
Register Now
Excel Pivot Tables and Charts
Nov 10 1:00 pm - 5:00 pm Excel Pivot Tables and Charts Westminster Excel Pivot Tables and Charts Excel Pivot Tables and Charts Training in Denver & Phoenix Class Price: $250 What’s included – a $1,180 value with: Face-to-face, live interactive class Retake – allows you to retake... Mission Critical Systems 10-11-2020T13:00 10-11-2020T17:00 Active
10-11-2020 Active 250.00 10-11-2020
Register Now
Excel Basic
Nov 20 8:00 am - 12:00 pm Excel Basic Tech Center Excel Basic Excel Basic Training in Denver & Phoenix Class Price: $250 What’s included – a $1,180 value with: Face-to-face, live interactive class Retake – allows you to retake the entire class... Mission Critical Systems 20-11-2020T08:00 20-11-2020T12:00 Active
20-11-2020 Active 250.00 20-11-2020
Register Now
Excel Basic
Dec 3 8:00 am - 12:00 pm Excel Basic Westminster Excel Basic Excel Basic Training in Denver & Phoenix Class Price: $250 What’s included – a $1,180 value with: Face-to-face, live interactive class Retake – allows you to retake the entire class... Mission Critical Systems 03-12-2020T08:00 03-12-2020T12:00 Active
03-12-2020 Active 250.00 03-12-2020
Register Now
Excel Basic
Dec 17 8:00 am - 12:00 pm Excel Basic Tech Center Excel Basic Excel Basic Training in Denver & Phoenix Class Price: $250 What’s included – a $1,180 value with: Face-to-face, live interactive class Retake – allows you to retake the entire class... Mission Critical Systems 17-12-2020T08:00 17-12-2020T12:00 Active
17-12-2020 Active 250.00 17-12-2020
Register Now

Bookings are closed for this class.