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

Back to Course List Add to Cart View Cart