• Home
  • Jobs
  • Courses
  • Advice
  • Login
  • Register
  • Employer ?
    • Login
    • Register
    • Employer Services
Find Course Providers Courses Advice
  • Products
    • Find Course Providers
    • Courses Advice
  • Advertise Your Courses
    Advertise Your Courses for Free

    Automate Excel Using Python - Xlwings | Series 1 | Simpliv

    Course by Simpliv LLC

    (Course Id: 244728 | 144 Views) Posted 00 UNK
    Category:
    Education, Information Technology
    How the course is given:
    Online
    When the courses is given:
    Flexible
    Qualification Level:
    Short Course/Training Certification
    Course Duration:
    02:19:42
    Price:
    $ 29.99
    Location:
    Fremont, CA 

    Registration is Available at Anytime

    View Courses by this company

    Course Description

    Description

    Master yourself to automate Industry-level datasets in Excel with hands-on experience on "2 Case Studies" using Python

    This course teaches how to automate Industry-level datasets maintained in Excel sheets using Python programming language.

    MS Excel is a very helpful tool for record-keeping. But the language that comes by default for macro is VBA, which is dated. And in the field of Data Analysis, Python has a lot of interesting packages which makes a job easy. Package like xlwings links any Excel with Python macros. Packages like Pandas, takes data into tabular format and also has customized filtering of rows or columns for complex data analysis. Packages like Matplotlib, Plotly enables to create different plots - line plot, Scatter plot, Heat map for finding the correlation b/w different parameters.

    In the Series, 2 Case studies has been picked from Industry process line. And correspondingly, Python macros are created to:

    • Reduce time in analysis
    • Enable customization using python packages
    • Reduce macros code lines in VBA codebase
    • Create customized User-defined modules by python functions

    Basic knowledge
    • Python Fundamentals
    • Excel (version 2007 or later)
    • Beginner developers who want to make their career on Data Science
    • People working as an Analyst, using Excel mostly

    What will you learn

    Students learn to:

    • Writing macros (in python) for their Excel sheets
    • Automate Excel without any VBA code (installed by default)
    • Build your own Formulas by coding User-defined Functions (UDFs) in Python
    • Practical hands-on experience with Industry level datasets
    • Automate, streamline and completely revolutionize your Excel workflow with Python macros
    • Master unique concepts, tools and case studies, which you won't find ANY other course, guaranteed
    • Get LIFETIME access to course materials and a 1-on-1 expert support
    • Continuous course updation when python packages updated with new features
    ENROLL COURSE

    About the Provider

    Simpliv is a global online learning marketplace that transforms lives by offering online training on a wide variety of topics. Created with the aim of making education accessible to all, Simpliv removes barriers to education among all communities, imparts life skills to learners, and bridges gaps in learning through cost-effective courses. Simpliv believes that learning has no boundaries. It brings learning to any person who wants to learn, whether it is management, technology, life sciences,... Read More

    Course Provider Contact

    Simpliv LLC
     39658 Mission Boulevard, Fremont,
    CA 94539, USA.
      Phone: +510-849-6155
      Email: sudheer@simpliv.com
    Saved

    Related Courses

      Flexible Education Courses

      Flexible Information Technology Courses

      Education Short Course/Training Certification Courses

      Information Technology Short Course/Training Certification Courses

      Education Courses in California

      Information Technology Courses in California

      All Education Courses

      All Information Technology Courses

      Courses at Simpliv LLC

    About Us

    Ethiojobs.net is the first online recruitment solution provider introduced in Ethiopia. The website advertises jobs across a wide range of job types by different employers, including private, local, international, multinational, who are hiring in Ethiopia.

    Job -Seekers

    • Find Jobs
    • Register
    • Post CVs
    • Job Alerts

    Employers

    • Login
    • Register
    • Post Jobs
    • Services

    Contact us

    • Snap Plaza 8th floor, Bole Next to The Millennium hall. Addis Ababa, Ethiopia

    • +251-116-67-33-24
      +251-924 91 08 47
    • info@ethiojobs.net
    • About Us
    • Contact Us
    • FAQ's
    • Courses Terms & Conditions
    • Privacy Policy
    • Sitemap

    © 2021 Powered by Ethiojobs.net. All Rights Reserved.