CPE Course Surgent's Data Analytics Readiness Series: Formulas, Named Ranges, and Formula Auditing 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 formulas to existing data and debug errors in formulas
- Understand the importance of naming conventions in Excel tables
- Understand the basic formula language and implementation guidance and be able to apply that guidance to common formulas used in data analytics
Highlights
- Named ranges- how they help in creating formulas
- Naming conventions and why they are important
- What you need to know to master formulas
- How to audit your formulas to limit errors
- Exercises- formulas
- Named ranges
- How to enter a formula- best practices to improve skill levels
Instructors
Prerequisites
2+ years of experience working with Excel
Developer
Surgent McCoy CPE, LLC
