Back

Price

Free
(for 1 month access)

Level

Any Level

Instructor

Jeffrey Schreier

Skills you will learn

Feedback, Reporting

About this course

07c3a5cc

This course is an addition to my first course by the same name, but it will stand on it's own if you want to take it first.  Both courses together will greatly increase your data handling and reporting capabilities in Excel.

  1. Text-to-Columns - for breaking data into multiple columns.
  2. Find-Replace - a simple way to get rid of unwanted repetitive data.
  3. Concatenation - this time we learn how to combine text from multiple columns into one.
  4. Subtotals - a great grouping and reporting tool.
  5. Filters - we revisit filters to learn more about how they can greatly improve your data handling and reporting capabilities.

The spreadsheet used in the class is attached in the project section so you can use it as a learning aid.

I hope you enjoy the class and please leave feedback!

LORE ADVANTAGE

Lore delivers value at the intersection of learning, interests and skills.

Learn from Domain Experts

Access learning options recommended by industry experts, professionals and thought leaders.

Search & Compare

Quickly search, select and add learning options to your learning list.

Personalize your feed

Tell us more about yourself to access the latest learning options, curated just for you.