Take Control of Unwieldy Excel Spreadsheets
Learn how to manage databases in Excel with this webinar. Learn the tools that will help large amounts of data seem more manageable, and easier to sort through and analyze. Understand what functions work best with large tables, and how you can automate repetitive steps with simple macros. Become a master of working with databases in Excel.Learning ObjectivesCreate and use Excel tables, as well as add, edit, search for, and delete records in a data list using a formUse VLOOKUP and HLOOKUP to aggregate data from multiple tablesSort records in a data list using a variety of methodsFilter data in a list using a variety of methods, as well as work with filtered dataCreate and work with subtotaled listsUse various database functions to summarize dataCreate, modify, and work with PivotTables, PivotCharts, and SlicersImport external data from a variety of sources into ExcelCourse Level - Basic/IntermediateWho Should AttendBusiness ownersCEO’s/CFO’s/CTO’sBank Managers and Bank TellersManagers of all levelsFinancial ProfessionalsAccountantsCPAsControllersFinancial ConsultantsIT ProfessionalsAuditorsHuman Resource PersonnelBookkeepersMarketersAnybody who uses Excel on a regular basis, and want to be more efficient and productiveWhy Should You AttendMicrosoft Excel has become the de facto spreadsheet application for business. But do you sometimes feel like you have rows and rows of data and it’s hard to make heads or tails of it? This class will help you learn how to manage databases in Excel, and get the most out of them.For 60-minutes, 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.
Single
Learn how to manage databases in Excel with this webinar. Learn the tools that will help large amounts of data seem more manageable, and easier to sort through and analyze. Understand what functions work best with large tables, and how you can automate repetitive steps with simple macros. Become a master of working with databases in Excel.
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
Course Level - Basic/Intermediate
Who Should Attend
- Business owners
- CEO’s/CFO’s/CTO’s
- Bank Managers and Bank Tellers
- Managers of all levels
- Financial Professionals
- Accountants
- CPAs
- Controllers
- Financial Consultants
- IT Professionals
- Auditors
- Human Resource Personnel
- Bookkeepers
- Marketers
- Anybody who uses Excel on a regular basis, and want to be more efficient and productive
Why Should You Attend
Microsoft Excel has become the de facto spreadsheet application for business. But do you sometimes feel like you have rows and rows of data and it’s hard to make heads or tails of it? This class will help you learn how to manage databases in Excel, and get the most out of them.
For 60-minutes, 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.