Using Python With Excel

Descripción

Excel can be a blessing and a curse. Working with small amounts of data and simple operations? Excel is your go-to tool. However, Excel's limitations show themselves whenever you need to work with large amounts of data and perform the types of complex operations necessary to compile key analytics, and pushing a spreadsheet past its comfort zone usually means slower performance. Enter Python, rapidly becoming one of the world's most popular programming languages. As a powerful tool that can speed up your data operations, Python, in conjunction with Excel, lets you inspect, clean, and filter data, along with the ability to create memorable and dynamic reports that deliver crucial business insights. Through the pandas and openpyxl libraries, you'll load and reshape data, build and format workbooks directly through code, and automate reporting work that used to take hours by hand. Whether it's converting data, creating visually striking graphs and charts, or shaping large amounts of data in any number of useful ways, you'll find a new-found ease and efficiency with Python that would be otherwise unattainable in Excel alone. By the end of this course, you'll combine data from multiple sources and build fully automated, visually polished Excel reports.