• 51 minutes

Leveraging Excel® for Data Analysis


What Is It?

Data input needs to be done well. As the saying goes, garbage in … garbage out. So it’s important that there is a process to organizing your data (spreadsheet, or stat software). This includes determining if your data needs cleaning, such as removing duplicates or other errors. In order to make a good analysis you will need to determine the type of analysis you need to do based on whether or not it’s statistical, are you identifying relationships, etc. This video reviews what data analysis is, why do people want to know about it and offers examples of data analysis tools.

Runtime: 51 minutes



Jay R. Carlson

Jay R. Carlson

  • Principal and co-owner of, an IT solutions company
  • Microsoft® Certified System Engineer (MCSE) as well as a Microsoft® Certified Database Administrator (MCDBA)
  • More than 25 years of experience in the IT industry and 20 years as a technical writer, including working as the technical lead at a top software company supporting their financial software
  • Through, co-wrote OfficeFest 2007, a self-published series of training modules that includes Using Microsoft® Excel® for Financial Analysis, Microsoft® Excel® Pivot Tables and Charts, as well as “Visual Basic for Applications in Microsoft® Excel® 2007”
  • Co-developed commercial SQL solutions and well-reviewed iPhone® applications
  • Graduate, Southern Illinois University; master’s degree in public administration with an emphasis in finance, University of Montana; associate’s degree in journalism

All of your training, right here at Lorman.

Pay once and get a full year of unlimited training in any format, any time!

  • Live Webinars
  • OnDemand Webinars
  • MP3 Downloads
  • Course Manuals
  • Audio Recordings*
  • Executive Reports
  • White Papers and Articles
  • Sponsored Live Webinars

Additional benefits include:

  • State Specific Credit Tracker
  • Members Only Newsletter
  • All-Access Pass Course Concierge

* For audio recordings you only pay shipping

Questions? Call 877-296-2169 to speak with a real person.

Sign Up Today

Access to all training products $699/year

Unlimited Lorman Training

With the All-Access Pass there is no guessing what you will need for your yearly training budget. $699 will cover all of your training needs for an entire year!

Easy Registrations

Once you purchase your All-Access Pass you will never be any further than one-click away from attending any Lorman training course.

Invest in Yourself

You haven't gotten to where you are professionally by luck alone; it's taken a lot of hard work and training. Invest in yourself with the All-Access Pass.