Excel Magic 3: Automating Data Entry with Data Feeds

<p>The course is presented in three parts.</p>

<p><b>First,</b> 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.</p>

<p><b>Next,</b> the course raises 4 areas where data entry can be automated. They are when:</p>

<ul>

<li>Source is PDF files</li>

<li>Source is Online Tables</li>

<li>Source is Banking Statements</li>

<li>Source is Accounting Software</li>

</ul>

<p><b>Last,</b> we demonstrate how to connect to external data so as to obtain the real-time update of data &ndash; all without typing. They include:</p>

<ul>

<li>Converting PDF files to Excel files</li>

<li>Connecting to online data</li>

<li>Converting data using Excel formulas</li>

<li>Integrating with accounting system data</li>

</ul>

<p>Course Key Concepts: <b>Data entry, Data Feed, Data Type, Big data, IoT (Internet of Things), Cloud computing, Machine learning, Artificial intelligence, OCR (Optical Character Recognition), On-premise software, Application Programming Interface.</b></p>