Excel Managing Databases

Excel Managing Databases

Course Description

Excel Managing Databases Training in Denver & Phoenix

excel_tip

Class Price: $450

What’s included – a $1,580 value with:

  • Face-to-face, live interactive class
  • Retake – allows you to retake the entire class if you need a refresher within 6 months
  • Workshop – get 1on1 help from an instructor on your own work projects to help you apply what you learned, up to 6 months after the class
  • Lunch & Learn session – choose from different topics to learn something new in the future
  • Hard copy training manual – to take notes and take with you for future reference
  • Quick Tip sheet – color reference card with the top tips from class
  • Just Tips Newsletter subscription – for ongoing monthly tips to help you learn even more!

 

 

Do you feel like you have rows and rows of data and it’s hard to make heads or tails of it? This Excel training in Denver & Phoenix 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.

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

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 Managing Databases
Feb 21 8:00 am - 4:00 pm Excel Managing Databases Tech Center Excel Managing Databases Excel Managing Databases Training in Denver & Phoenix Class Price: $450 What’s included – a $1,580 value with: Face-to-face, live interactive class Retake – allows you to retake the entire... Mission Critical Systems 21-02-2019T08:00 21-02-2019T16:00 Active
21-02-2019 Active 450.00 21-02-2019
Register Now
Excel Managing Databases
Apr 22 8:00 am - 4:00 pm Excel Managing Databases Phoenix Excel Managing Databases Excel Managing Databases Training in Denver & Phoenix Class Price: $450 What’s included – a $1,580 value with: Face-to-face, live interactive class Retake – allows you to retake the entire... Mission Critical Systems 22-04-2019T08:00 22-04-2019T16:00 Active
22-04-2019 Active 450.00 22-04-2019
Register Now
Excel Managing Databases
Jun 7 8:00 am - 4:00 pm Excel Managing Databases Westminster Excel Managing Databases Excel Managing Databases Training in Denver & Phoenix Class Price: $450 What’s included – a $1,580 value with: Face-to-face, live interactive class Retake – allows you to retake the entire... Mission Critical Systems 07-06-2019T08:00 07-06-2019T16:00 Active
07-06-2019 Active 450.00 07-06-2019
Register Now
Excel Managing Databases
Oct 3 8:00 am - 4:00 pm Excel Managing Databases Tech Center Excel Managing Databases Excel Managing Databases Training in Denver & Phoenix Class Price: $450 What’s included – a $1,580 value with: Face-to-face, live interactive class Retake – allows you to retake the entire... Mission Critical Systems 03-10-2019T08:00 03-10-2019T16:00 Active
03-10-2019 Active 450.00 03-10-2019
Register Now
Excel Managing Databases
Nov 1 8:00 am - 4:00 pm Excel Managing Databases Phoenix Excel Managing Databases Excel Managing Databases Training in Denver & Phoenix Class Price: $450 What’s included – a $1,580 value with: Face-to-face, live interactive class Retake – allows you to retake the entire... Mission Critical Systems 01-11-2019T08:00 01-11-2019T16:00 Active
01-11-2019 Active 450.00 01-11-2019
Register Now
Excel Managing Databases Phoenix Nov 1  8:00 am - 4:00 pm

450.00

Attendee 1



Live & In-Person

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