Microsoft Excel Database Tools Training Course Outline

Audience: Those who need to use database tools to manage information stored in Excel worksheets. This Excel Database Tools course covers data sorting, creating forms to add, delete and change data. And how to use search criteria to generate reports.

Course Duration: 1 day

Course Availability: Monday – Saturday

Course Types: Group bookings, public courses, 1-2-1 sessions, bespoke tailored courses and office migrations.

Course Location: This Microsoft Excel Database Tools training course can be delivered either at our London training venue or at your offices. 

Tailored Course Content: Course content can be customised to meet your specific requirements, with scheduled dates to suit you.

At Course Completion

After completing this course, students will be able to:

  • Capture data for analysis
  • Manage the screen display
  • Create formulas to aggregate data
  • Enter data using the Data Form
  • Sort data
  • Calculate SubTotals
  • Use different methods of filtering data

Course Outline

Module 1: Data capture

  • Data Validation
  • Excel Ranges or Tables?
  • Converting a range to a table
  • Using Text to Columns to split data
  • Remove Duplicates

Module 2: Managing the display

  • Freeze Panes to lock the header rows or left-hand columns
  • Grouping data to hide and show columns

Module 3: Data formulas

  • Structured formulas
  • SUMIFS and COUNTIFS
  • DSUM, DCOUNT, DCOUNTA, DMIN, DMAX

Module 4: Data Form

  • Entering and editing records with Excel’s Data Form

Module 5: Sorting

  • Multiple-key sorts
  • Sorting using a Custom List
  • Sorting columns
  • Sorting based on cell colour, font colour or icon
  • Removing space characters

Module 6: SubTotals

  • Single and multiple-level Subtotals
  • Using the Outlining symbols

Module 7: Filtering

  • AutoFilter
  • Creating simple and compound criteria for filtering data
  • Filtering tools for Text, Number and Date fields
  • Using Advanced Filter to overcome the limitations of AutoFilter by using complex and calculated criteria
, Microsoft Excel Database Tools Training Course Outline
, Microsoft Excel Database Tools Training Course Outline