more
Craig Hanson, Controller
In addition to his teaching experience, Craig has worked in various accounting and finance functions. As a certified CPA, CMA, and CGMA, he's become a master of Excel and understands its importance in business.
To Access This Course:
In this course we discuss how to make data that comes to us in a ‘dirty’ and unusable format useful. Many times, report writers give us data with subtotals or other information that are not very helpful at all. In this course we focus on how to make this data useful.
Finally, we explore new ways to create unique identification formulas that will enhance the relational database aspect of your data (i.e. COUNTIFS, SUMIFS, FIND, SEARCH, VLOOKUP, etc.)
Learning Objectives
- Identify situations wherein data from typical accounting systems fails to give us what we’re truly looking for (i.e. getting useless subtotals that make tallying and converting data to a tabular format tricky)
- Discover new ways to create useful management reports from systems that don't quite give us what we exactly are looking for by means of cleaning up this ‘dirty’ data.
- Explore new ways to create unique identification formulas that will enhance the relational database aspect of your data (i.e. COUNTIFS, SUMIFS, FIND, SEARCH, VLOOKUP, etc.)
Last updated/reviewed: November 25, 2020
18 Reviews (42 ratings)Reviews
Steve Meyers
(solo at none)
Supporting materials were missing workbooks for Accounts Payable, Accounts Receivable, and "Enhancing your lookup skill set". These workbooks are essential to follow along and for hands on learning.
The spreadsheet used as an example in the "Enhancing your lookup skill set" was way too complicated. Something much simpler could have been used and shown better, more practical examples of HLOOKUPs and VLOOKUPs functions
Anonymous
(Owner)
These course contains great information! I believe that it would be easier to understand it if the files in excel were provided. That way students could download and follow the files for the lectures. Overall, this is a very interesting course. You need to have basic knledge of formulas and Vlookups. I highly recommend it.
Bruce Reed
(Chief Financial Officer at PracticeLink)
This was one of the most practical applications of excel that I've seen in this series. Many of us at SMB need to deal with data that we get from the accounting system. The tricks and tips will go into practice right away.
Sherman Bamford
(Accountant at Carilion Clinic)
Presented a number of tools for distilling and cleaning up Excel data derived from ERP software programs. I found the information very useful. There should have been more demonstrations using large data sets.
Sheilah Brown
(Controller at SMB LTC)
Useful information on dealing with ERP data where the information is on more than one row, which is unfortunately all too common, and turning it into searchable information.
Wei Han Koh
(Finance at Private)
This course is clear but very basic. It would be great if the course provider could provide more advanced techniques too.
Radhesh Pradhan
(Accounting Manager at DGN Technologies Inc)
Great course. Very insightful. We need more courses like this specifically designed for "corporate accountants"
Anonymous
(Project Manager)
It overall provided a great understanding of the basic excel concepts to help clean up our work papers.
Anonymous
(Consultant)
Usually controller do not manipulate data so good idea for these working with them to learn these hints
Christopher Lynch
( at Sharpei Financial & Consultiong)
I wish instructor took some time to spell out some of conditions in functions he was demonstrating
Sally Fonstein
(Corp Controller at Ustream, Inc.)
Helpful to cleaning up data coming from a downloaded report from a system like QuickBooks.
Charles Tuggle
(Retired 2003 at Plant Engineer Pulp and Paper)
The text in the spreadsheet was too small to follow the instructor on a 17 inch monitor
scott ellis
(controller at self)
Good techniques for sorting large amounts of data to a format usable for accountants.
Anonymous
(Consultant)
Basic functions suited for someone who is not too familiar with Excel functions.
Anonymous
(Research Operations and Financial Office..)
I like this course with a step by step video so it is clear for me to follow.
Anonymous
(Entrepreneur)
Seemed a little repetitive in spots, but good intro content for Excel users.
Joel Barton
(None at In Transition)
Would have been nice to have the Excel files used to follow along.
Mucio Batista
(Treasury Lead at Ppro Financial Ltd)
Good course for begginers. Well presented.
Prerequisites
Course Complexity: Intermediate
No advanced preparation or prerequisites are required for this course but a general working knowledge of Microsoft Excel is preferred.
Education Provider Information
Company:
Illumeo, Inc., 75 East Santa Clara St., Suite 1215, San Jose, CA 95113
Contact:
For more information regarding this course, including complaint and cancellation policies, please contact our offices at (408) 400- 3993 or send an e-mail to .