Excel with Python: Performing Advanced Operations

Python 3.7    |    Intermediate
  • 17 Videos | 1h 37m 3s
  • Includes Assessment
  • Earns a Badge
Likes 45 Likes 45
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 course
    apply styling elements to control the display of data in cells
    apply sophisticated styles and alignments to format cell contents
    use number formats to represent currencies and add comma separators
    apply formatting that varies based on the value contained in a cell
    choose from different in-built icon sets and rules to control cell formatting at a granular level
    insert images into Microsoft Excel files and control their size and location
    insert formulae into Excel workbooks
    use openpyxl to programmatically construct formulae in workbooks
  • use the $ operator to convert relative cell references into absolute ones
    use openpyxl to construct both absolute and relative cell references
    use VLOOKUP to lookup specific values from a range in Excel
    assign names to groups of cells and use those names in formulae to enhance readability
    use Excel pivot tables to dynamically analyze and group data
    use Pandas to read data from Microsoft Excel and perform pivoting operations
    use Pandas to perform multi-level indexing and access individual row values as well as index values
    summarize the key concepts in this course

IN THIS COURSE

  • Playable
    1. 
    Course Overview
    2m 12s
    UP NEXT
  • Playable
    2. 
    Working with Fonts and Styles
    6m 57s
  • Locked
    3. 
    Working with Borders and Colors
    5m 9s
  • Locked
    4. 
    Applying Number Formats
    8m 4s
  • Locked
    5. 
    Applying Conditional Formatting
    4m 31s
  • Locked
    6. 
    Using Advanced Conditional Formatting
    4m 49s
  • Locked
    7. 
    Working with Images
    3m 5s
  • Locked
    8. 
    Working with Formulae
    6m 56s
  • Locked
    9. 
    More Operations Using Formulae
    3m 29s
  • Locked
    10. 
    Using Absolute and Relative Cell References
    5m 52s
  • Locked
    11. 
    Programmatically Constructing Absolute References
    5m 28s
  • Locked
    12. 
    Using VLOOKUP
    6m 46s
  • Locked
    13. 
    Working with Named Ranges
    6m 8s
  • Locked
    14. 
    Working with Pivot Tables
    5m 42s
  • Locked
    15. 
    Using Pandas for Pivoting
    7m 48s
  • Locked
    16. 
    Leveraging Multi-level Indexing in Pandas
    5m 10s
  • Locked
    17. 
    Course Summary
    1m 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

Likes 28 Likes 28  
Likes 96 Likes 96  
Likes 67 Likes 67  

PEOPLE WHO VIEWED THIS ALSO VIEWED THESE

Likes 704 Likes 704  
Likes 94 Likes 94