Excel: Organizing Data for Analysis - Getting the Insights You Need October 19, 2021, 10:00am EDT October 19, 2021, 11:00am EDT

Does this seem familiar? You've gathered your data and put it into the computer.

Then you open your database or spreadsheet anxious to see what secrets it

reveals, only to discover that no matter what you do, you can’t generate the

analysis you want.

Often the problem is that the data are not organized in a way that can produce

the desired information. This webinar will show you how to set things up so you

can get from where you are to where you want to be.

This live, one-hour session will explain and demonstrate:

  • Key data analysis concepts, including field, record, table and relationship;
  • How to identify the data structures that will let you to make the analyses you need, and why there is no one size fits all solution;
  • How to decide what adjustments, if any, need to be made to an existing data structure to produce the one you need;
  • Tools and techniques for automating some of the adjustments, including
  • combining and splitting fields, and converting horizontal to vertical record structures;
  • What is required to join tables so you can connect data from several sources; and
  • How to test your data structure to make sure it works.

The examples will be demonstrated using Excel, but the principles are applicable

to databases, SQL, and other tools that can be used to parse and analyze data.

There will be plenty of time for questions, so come prepared

Presenter: Gerald Rosenthal, ComputerImages is a Boston-based computer training and consulting firm that provides instructor-led workshops on most of the widely-used Windows and Macintosh application software. All of our courses feature small class size, hands-on exercises, and an emphasis on student participation.

Key Topics

Excel: Organizing Data for Analysis - Getting the Insights You Need