MS Excel Automation | Excel Data Analysis with Python

Course Overview

• Course Title: MS Excel Automation | Excel Data Analysis with Python
• Instructor: Faisal Zamir
• Target Audience:
  • Students with basic knowledge of MS Excel
  • Students with beginner-level experience in Python
• Prerequisites:
  • Basic knowledge of MS Excel
  • Basic knowledge of Python

Curriculum Highlights

• Key Topics Covered:
  • Introduction to Excel and Python-based Libraries
  • Creating and Manipulating Workbooks and Sheets
  • Inserting and Formatting Data
  • Generating Charts
  • Conditional Formatting
  • Sorting and Filtering Data
  • Working with Tables
  • Using Formulas and Data Validation
  • Protecting and Securing Workbooks
• Key Skills Learned:
  • Automate Excel tasks using Python
  • Create, modify, and format Excel workbooks and sheets
  • Insert and manipulate data, comments, and images
  • Generate various types of charts
  • Apply conditional formatting
  • Configure print settings
  • Filter and sort data
  • Work with tables and apply data validation
  • Use formulas for calculations
  • Protect and secure Excel workbooks

Course Format

• Duration: 7.5 hours on-demand video
• Format: Self-paced online course
• Resources:
  • 1 practice test
  • Assignments
  • 4 articles
  • 1 downloadable resource
  • Access on mobile and TV
  • Certificate of completion