Converting Data into Information Using Excel | Jeffrey Schreier | Skillshare

Converting Data into Information Using Excel

Jeffrey Schreier, Don't be intimidated by Excel!

Play Speed
  • 0.5x
  • 1x (Normal)
  • 1.25x
  • 1.5x
  • 2x
5 Videos (43m)
    • Course Introduction

    • A little database know-how goes a long way

    • A single formula to master your data

    • A single reporting tool to create information

    • Yes, you can create good data from bad


About This Class


Welcome to my course "Converting Data into Information Using Excel"

This course is designed to help you grow beyond using basic Excel spreadsheet creation and formatting skills, and show you how to use Excel to add value in ways you were not previously exposed to. I specifically cover proper database creation, the vlookup formula, pivot table reporting, filtering and several text formulas including the "If" formula.

My sharing philosophy is to go beyond just explaining Excel techniques to showing you how to use them in ways that will be helpful to you. Everything I show comes from what I consider "best practices" during my 30+ years using using spreadsheets and Excel in my ongoing career.  

Please watch my introductory video and please enroll if you are interested.  I am confident that you will find it worthwhile.  The spreadsheet I used in the class lessons is attached in the class project section and you may use it as a learning aid to help you with your class project.





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


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