Excel Magic: Automating Data Entry with Data Feed | CPDFormula by learnformula
Excel Magic: Automating Data Entry with Data Feed
In this course you will learn how to avoid data entry and replace it with data feed from the systems.
schedule1h
4.3(41)
Lenny Wu
•
Financial Reporting Expert
38 Courses
• 2742 Reviews
Lenny is Senior Financial Analyst at Ausenco. Lenny has over 15 years combined experience in financial planning and analysis (FP&A), financial reporting and modeling, and compliance auditing.
Lenny s...
About this course
The course is presented in three parts.
First, the course introduces the concept of automatically connecting to the external data sources with latest technologies, in order to saving time by avoiding manual data entry as much as possible.
Next, the course raises 4 areas where data entry can be automated. They are when:
o Source is PDF files
o Source is Online Tables
o Source is Banking Statements
o Source is Accounting Software
Last, we demonstrate how to connect to external data so as to obtain the real-time update of data – all without typing. They include:
o Converting PDF files to Excel files
o Connecting to online data
o Converting data using Excel formulas
o Integrating with accounting system data