Python for Excel Automation Part3 – Ajay Kumar

Offer: 17 Courses in 5999 Rs (550 Hrs).
22 Courses in 8500 and 10 Courses in 4500

0(0 Ratings)

Python for Excel Automation Part3

Categories Eng

About Course

How to automate Excel work with Python libraries like OpenPyxl and OS,Glob

What I will learn?

  • You will learn how to automate Excel spreadsheet faster and conveniently

Course Curriculum

Excel Automation

  • Project – Which Shop has Highest Item Sold
    18:49
  • Your doubt is explained – Change Values using criterias
    15:29
  • Export to Excel
    14:46
  • Create and Open Excel Workbook
    13:08
  • Append Data into Excel
    10:50
  • Append Data with more parameters
    22:47
  • Excel Sheets Commands
    23:28
  • Project Excel Compile Data from Sheets
    30:19
  • Data Compile from Folders and Files
    28:11
  • Project – Folder Compile Data Into different Sheets
    20:37
  • Introduction to OS library – File and Folders
    09:25
  • How to loop Folders
    08:40
  • How to link Excel Sheet Cells
    15:39
  • Project in Excel – Calc Average and Total Sales
    14:12
  • Copy Paste Data in Excel
    11:19
  • How local global variable works- More explanation
    15:19
  • Create a function – Copy excel range
    11:01
  • Now function for paste
    25:45
  • Excel project: Data Cleaning and Structuring
    00:00

Student Ratings & Reviews

No Review Yet
No Review Yet
1,499.00 2,800.00

A course by

Material Includes

  • Modules are available under lecture2 for you to download

Requirements

  • If you have seen Part1 and Part2 , then this is a good start for you.

Tags

Target Audience

  • Data Analysts, MIS , Workforce professionals who work on data - especially large complex data