DESCRIPTION
This training program will familiarize attendees with data layout standards for optimizing data management tools. It will discuss data design tips, data validation, conversion of a list to a table, filter and advanced filter, subtotals and more.
Why Should You Attend:
Large amounts of data can become unmanageable fast. But with the data management and analysis features in Excel 2016, you can keep the largest spreadsheets under control. In this course, Dennis Taylor shares easy-to-use commands, features, and functions for maintaining large lists of data in Excel. He covers sorting, adding subtotals, filtering, eliminating duplicate data, and using Excel's Advanced Filter feature and specialized database functions to isolate and analyze data. With these techniques, you'll be able to extract the most important information from your data, in the shortest amount of time.
Learning Objectives:
- Become familiar with data layout standards for optimizing data management tools.
- Learn when and why to convert lists of data into tables.
- Learn to control data accuracy at creation time using data validation, including the popular pick-list feature.
- Learn to see just the important data at any time using filter, advanced filter, or the powerful and visual slicer feature.
- Learn how to control the order of data with sorting tools, including methods for sorting based on the order of a list, sorting by color or icon, sorting top-bottom and left-right, and sorting in random order.
- Using the subtotal command, learn how to insert automatic totals in a list and collapse/expand the display to show subtotals or details.
Session Highlights:
- Prepping data for analysis
- Working with different worksheets together
- Linking formulas across multiple workbooks
- Getting data from other sheets with 3D formulas
- Multiple-key sorting
- Setting single- and multi-level subtotals
- Using text, numeric, and date filters
- Filtering tables using slicers
- Using Advanced Filter
- Eliminating duplicate data
- Using SUMIF and COUNTIF functions for quick data analysis
- Working with the database functions such as DSUM and DMAX
Who Will Benefit:
This webinar will provide valuable assistance to nearly all Excel users - it is not industry specific, but is perhaps more widely used in:
- Banking, finance, and related fields
- Marketing Professionals
- Sales Professionals
- Investments
- Accounts and audit
- Credit unions and mortgage firms
- Human Resource Professionals