Excel for Data Cleaning and Use of Macros
Excel’s extensive functionality can best be judged by three of its most essential characteristics for the accountant:
A) Ease with which a user can convert and summarize thousands of lines of raw data, even if these are imported from other applications like SAP
B) Flexibility to accommodate changes at very short notice, thereby relieving somewhat the added pressure of tight deadlines; and
C) Formula/function structure underpinned by logical steps that are simple to follow
Importing data into Excel
Importing data into Excel from other applications in CSV, TXT format entails:
• Performing changes and formats on the data available
• Merging data from more than one source
• Summarizing data into ...
Get MS Excel, Second Edition, 2nd Edition now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
