|
Would you like to be a master at managing databases in Excel? Join Excel expert Tom Fragale for this 75-minutes session to learn the tools that will help manage, sort through and analyze large amounts of data. The speaker will help you understand what functions work best with large tables and how to automate repetitive steps with simple macros. The webinar also discusses additional Excel features, including the Table feature, PivotTable feature, Slicer feature, and the PowerPivot feature.
Key Learning Objectives- Create and use Excel tables, as well as add, edit, search for, and delete records in a data list using a form
- Use VLOOKUP and HLOOKUP to aggregate data from multiple tables
- Sort records in a data list using a variety of methods
- Filter data in a list using a variety of methods, as well as work with filtered data
- Create and work with subtotalled lists
- Use various database functions to summarize data
- Create, modify, and work with PivotTables, PivotCharts, and Slicers
- Import external data from a variety of sources into Excel
| |
| |
|
|
 | Tom Fragale
Tom Fragale is a computer professional with over 30 years experience. He has trained over 30,000 business people with online webinars, public seminars and on-site training. | | View More |
| |
| |
