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