Excel with Python: Performing Advanced Operations

Learners can explore complex operations in Microsoft Excel workbooks including the use of conditional formatting named ranges and merged cells in this 17-video course. Microsoft Excel is the best prototyping tool for data analysis an interactive functional programming environment and a forerunner of Python. Begin by exploring how Python and its ecosystem of libraries are fast emerging as a popular choice for easy spreadsheet automation. Then observe the formatting alignment and other aesthetics in Python. You will work with the Python library openpyxl; examine data analysis the use of pivot tables and the locking of cell references by using the $ operator; and learn how to perform complex data analysis operations using pivot tables sorting and filtering and formulae with both absolute and relative cell references to enable efficient copy paste. You will learn to control the workbook appearance using conditional formatting and styles. Finally this course demonstrates how to leverage the Python Pandas library to read a spreadsheet to group and analyze data.