CPE Course Surgent's Data Analytics Readiness Series: Excel Tables On-Demand Webcast
Location Webinar
Member Price
$39.00
Non-member Price
$69.00
Curriculum Information Technology
Field of Interest
Level Intermediate
Designed For
Accountants who want to transition to data analysis and have a basic knowledge of Excel and Excel formulas
Objective
- Understand the applicable Excel skills that will be required in making the transition to data analyst
- Apply skills learned to create and structure tables
- Determine the appropriate descriptive statistics to present them in a structured format
- Create structured references and understand their relation to formula creation
- Create formulas and apply troubleshooting techniques to formulas created
Highlights
- Creating a table
- Parts to a table
- Benefits of an Excel table
- Structured references
- How it helps to create formulas
- Formulas are column based not cell based
- Tables are data sources for Power Query
- Exercises- tables
- Creating a table
- Resizing a table
- Removing duplicates
- Descriptive Statistics using the Total Row
- Inserting a slicer
- Creating formulas using structured references
Instructors
Prerequisites
2+ years of experience working with Excel
Developer
Surgent McCoy CPE, LLC
