Converting Data into Information Using Excel - Part 2 | Jeffrey Schreier | Skillshare

Converting Data into Information Using Excel - Part 2

Jeffrey Schreier, Don't be intimidated by Excel!

Play Speed
  • 0.5x
  • 1x (Normal)
  • 1.25x
  • 1.5x
  • 2x
6 Videos (37m)
    • A quick primer on the course content

      1:14
    • Text to Columns can be a great data creation tool

      8:12
    • Find_Replace is not just for word processing

      2:41
    • Concatenation is a lot easier to use than to say

      4:35
    • More with the powerful filtering tool

      10:09
    • Subtotals has many great uses

      10:00

About This Class

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!

48

Students

--

Projects

  • --
  • Beginner
  • Intermediate
  • Advanced
  • All Levels
  • Beg/Int
  • Int/Adv

Level

Community Generated

The level is determined by a majority opinion of students who have reviewed this class. The teacher's recommendation is shown until at least 5 student responses are collected.

Jeffrey Schreier

Don't be intimidated by Excel!

I am a CPA with many years of financial experience in the corporate world. During this time I have developed a large toolbox of Excel and Access techniques that I have continually relied on and perfected..

I am glad to share this knowledge on SkillShare.

See full profile

Report class