561,038 views
■ Programming school that will dramatically improve your business fighting power "code4biz" 🧑💻 ↓Click here for the briefing session↓ http://code4biz.jp/ * Deadline: Wednesday, March 23, 23:59 * There will be no second session for the time being 👨💻⬇︎Free LINE registration will release limited content soon ⬇︎👨💻 ✅Three ways of thinking that will dramatically improve the efficiency of programming learning ✅9 error solving methods that you must know ✅Important ways of thinking and three success stories for improving business efficiency through programming! etc... https://line.me/R/ti/p/@114eqgxg ■ Files used in the lecture https://drive.google.com/drive/folder... This video is a combination of all three videos published in the series on automating Excel operations with Python. Using Python, you can achieve various business efficiency improvements, but we believe that there is a considerable need for automating Excel operations. To achieve this automation, this video will show you everything from automatically consolidating Excel files to creating summary tables, implementing pivot tables and VLOOKUP functions that are often used in Excel, and formatting. 00:00 Introduction 01:03 Consolidating Excel files (invoices) 33:36 Creating summary tables and commonly used Excel functions 01:25:52 Formatting and output from PDF ■ Twitter / 03imanyu ■ Udemy https://www.udemy.com/user/jin-xi-han... #Excel operation with Python #Excel automation #Python automation