CPE Course Get & Transform data in Excel

January 26, 2018

11:30AM — 1:30 PM

Location Webinar

Member Price $60.00
Non-member Price $94.00

Curriculum Continuing Education

Field of Interest

Level Beginning

Designed For

Accountants who use Excel 2016 for Windows.

2.00 credits

Add to Cart View Cart

Objective

  • Recall the steps to create a new query.
  • Identify commands that transform data.
  • State the process to return the transformed data to Excel.

Highlights

  • Get & Transform Query
  • Flattening data
  • Splitting and combining columns
  • Formatting data
  • Unpivoting summarized data

Instructors

Prerequisites

None.

Developer

California Society of CPAs

Back to Course List Add to Cart View Cart