|
Learning how to use Excel efficiently is very critical in today’s office jobs. Having a deep practical knowledge of Excel will turn you almost superhuman at work and increase your productivity. In this 75-minutes webinar, Excel expert Tom Fragale 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.
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 subtotaled 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
Mr. 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. His topics of expertise include: Access, Excel, Word, PowerPoint, Outlook, Crystal Reports, SQL Server, Visio, QuickBooks and SharePoint. His passion is training people and helping them get most out of their computers.
|
|
View More
|
|
|
|
|
Host This Webinar At Your Organization
Become a Speaker
