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 27, 2019
13 Reviews (35 ratings)Reviews
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.
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
(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
(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 Manager at PayU / a Naspers group company)
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 .