Mastering Excel® Database Management Tools

  • Business Enhancement Skills
  • Course Code: 62077
Time-Saving Shortcuts for Sorting, Filtering, and More…
Excel users who build and maintain database-like worksheets need to manage their data efficiently and they need to optimize their use of Excel’s many powerful and easy-to-use database commands and techniques. These are critical to anyone who maintains an Excel database. This course explores those features needed to modify, build, and manage an Excel database, including: validating data, using the Table feature, sorting, adding automatic subtotals, filtering, using the Advanced Filter (for complex filtering), and database analysis functions.
For 90-minutes, Excel expert Dennis Taylor will lead you through a full array of powerful and easy-to-use database commands and methods critical to effectively working with Excel databases.
In this webinar, you will learn how to improve your Excel database skills so that you can better summarize info-making better, more-informed business decisions. For example, you’ll discover:
  •  Easy-to-use methods to build and manage your database
  •  Specialized database functions that simplify your job
  •  Techniques to sort and filter data in order to identify business trends
  •  Tips and tricks to validate your data and guarantee accuracy

How You Will Benefit

After completing this course, you will understand and be able to apply a variety of Excel data manipulation tools to solve a variety of database analysis and management problems.



Who Should Attend


Related Courses

Stay Connected

Copyright © 2017 CANADIAN MANAGEMENT CENTRE - PROFESSIONAL DEVELOPMENT, MANAGEMENT & CAREER TRAINING | 33 Yonge Street, Suite 320, Toronto, Ontario M5E 1G4, Canada |