Excel with Python: Performing Advanced Operations
Python 3.7
| Intermediate
- 17 Videos | 1h 29m 33s
- Includes Assessment
- Earns a Badge
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.
WHAT YOU WILL LEARN
-
discover the key concepts covered in this courseapply styling elements to control the display of data in cellsapply sophisticated styles and alignments to format cell contentsuse number formats to represent currencies and add comma separatorsapply formatting that varies based on the value contained in a cellchoose from different in-built icon sets and rules to control cell formatting at a granular levelinsert images into Microsoft Excel files and control their size and locationinsert formulae into Excel workbooksuse openpyxl to programmatically construct formulae in workbooks
-
use the $ operator to convert relative cell references into absolute onesuse openpyxl to construct both absolute and relative cell referencesuse VLOOKUP to lookup specific values from a range in Excelassign names to groups of cells and use those names in formulae to enhance readabilityuse Excel pivot tables to dynamically analyze and group datause Pandas to read data from Microsoft Excel and perform pivoting operationsuse Pandas to perform multi-level indexing and access individual row values as well as index valuessummarize the key concepts in this course
IN THIS COURSE
-
1.Course Overview2m 12sUP NEXT
-
2.Working with Fonts and Styles6m 57s
-
3.Working with Borders and Colors5m 9s
-
4.Applying Number Formats8m 4s
-
5.Applying Conditional Formatting4m 31s
-
6.Using Advanced Conditional Formatting4m 49s
-
7.Working with Images3m 5s
-
8.Working with Formulae6m 56s
-
9.More Operations Using Formulae3m 29s
-
10.Using Absolute and Relative Cell References5m 52s
-
11.Programmatically Constructing Absolute References5m 28s
-
12.Using VLOOKUP6m 46s
-
13.Working with Named Ranges6m 8s
-
14.Working with Pivot Tables5m 42s
-
15.Using Pandas for Pivoting7m 48s
-
16.Leveraging Multi-level Indexing in Pandas5m 10s
-
17.Course Summary1m 27s
EARN A DIGITAL BADGE WHEN YOU COMPLETE THIS COURSE
Skillsoft is providing you the opportunity to earn a digital badge upon successful completion of this course, which can be shared on any social network or business platform
Digital badges are yours to keep, forever.YOU MIGHT ALSO LIKE


BOOK
Job Ready Python

BOOK
Pandas in Action