Automate Excel using Python - Xlwings | Series 1

Simpliv

Course

Online

£ 10 VAT inc.

The best Other Education courses

See all

See all

Description

  • Type

    Course

  • Methodology

    Online

  • Start date

    Different dates available

Master yourself to automate Industry-level datasets in Excel with hands-on experience on "2 Case Studies" using PythonThis 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

Facilities

Location

Start date

Online

Start date

Different dates availableEnrolment now open

About this course

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

Questions & Answers

Add your question

Our advisors and other users will be able to reply to you

Who would you like to address this question to?

Fill in your details to get a reply

We will only publish your name and question

Emagister S.L. (data controller) will process your data to carry out promotional activities (via email and/or phone), publish reviews, or manage incidents. You can learn about your rights and manage your preferences in the privacy policy.

Reviews

This centre's achievements

2021

All courses are up to date

The average rating is higher than 3.7

More than 50 reviews in the last 12 months

This centre has featured on Emagister for 6 years

Subjects

  • Install
  • MS Excel
  • Industry
  • Project
  • Data analysis
  • Access
  • Excel

Course programme

Introduction 2 lectures 08:37 About Instructor About the Course Introduction 2 lectures 08:37 About Instructor About the Course About Instructor About Instructor About Instructor About Instructor About the Course About the Course About the Course About the Course Chapter-0 - Basics 5 lectures 25:32 Tools ToolsVideoch_0_tut_1_tools.mp4 Description* Anaconda- Setup: Sublime Text 3- Setup: Packages: More: Tools part 2 ToolsVideoch_0_tut_1_tools.mp4 Description* Anaconda- Setup: Text 3- Setup: Packages: More: Python PythonVideoch_0_tut_2_python.mp4 Download Code Pandas Downloadcountries.csv Xlwings XlwingsSteps1. Open "Command Prompt", type `conda list` 2. If `xlwings` is not installed, then install using this - `conda install -c anaconda xlwings` 3. Install **addin** in Excel using this - `xlwings addin install` on the terminal. 4. Choose a directory and open a project there: `xlwings quickstart demo` 5. macro settings in the MS Excel - enable <kbd>Enable all macros</kbd> button in the `Trust Center >> Macro Settings >> Macro Settings` - enable <kbd>Trust access to the VBA project object model</kbd> button in the `Trust Center >> Macro Settings >> Developer Macro Settings`5. Print "Hello Xlwings!" 6. Add a UDF - `sumtwice()` References* Official website - Documentation - More - Chapter-0 - Basics 5 lectures 25:32 Tools ToolsVideoch_0_tut_1_tools.mp4 Description* Anaconda- Setup: Sublime Text 3- Setup: Packages: More: Tools part 2 ToolsVideoch_0_tut_1_tools.mp4 Description* Anaconda- Setup: Text 3- Setup: Packages: More: Python PythonVideoch_0_tut_2_python.mp4 Download Code Pandas Downloadcountries.csv Xlwings XlwingsSteps1. Open "Command Prompt", type `conda list` 2. If `xlwings` is not installed, then install using this - `conda install -c anaconda xlwings` 3. Install **addin** in Excel using this - `xlwings addin install` on the terminal. 4. Choose a directory and open a project there: `xlwings quickstart demo` 5. macro settings in the MS Excel - enable <kbd>Enable all macros</kbd> button in the `Trust Center >> Macro Settings >> Macro Settings` - enable <kbd>Trust access to the VBA project object model</kbd> button in the `Trust Center >> Macro Settings >> Developer Macro Settings`5. Print "Hello Xlwings!" 6. Add a UDF - `sumtwice()` References* Official website - Documentation - More - Tools ToolsVideoch_0_tut_1_tools.mp4 Description* Anaconda- Setup: Sublime Text 3- Setup: Packages: More: Tools ToolsVideoch_0_tut_1_tools.mp4 Description* Anaconda- Setup: Sublime Text 3- Setup: Packages: More: Tools ToolsVideoch_0_tut_1_tools.mp4 Description* Anaconda- Setup: Sublime Text 3- Setup: Packages: More: Tools ToolsVideoch_0_tut_1_tools.mp4 Description* Anaconda- Setup: Sublime Text 3- Setup: Packages: More: Anaconda- Setup: Sublime Text 3- Setup: Packages: More: Anaconda- Setup: Sublime Text 3- Setup: Packages: More: Tools part 2 ToolsVideoch_0_tut_1_tools.mp4 Description* Anaconda- Setup: Text 3- Setup: Packages: More: Tools part 2 ToolsVideoch_0_tut_1_tools.mp4 Description* Anaconda- Setup: Text 3- Setup: Packages: More: Tools part 2 ToolsVideoch_0_tut_1_tools.mp4 Description* Anaconda- Setup: Text 3- Setup: Packages: More: Tools part 2 ToolsVideoch_0_tut_1_tools.mp4 Description* Anaconda- Setup: Text 3- Setup: Packages: More: Setup: Text 3- Setup: Packages: More: Setup: Text 3- Setup: Packages: More: Python PythonVideoch_0_tut_2_python.mp4 Download Code Python PythonVideoch_0_tut_2_python.mp4 Download Code Python PythonVideoch_0_tut_2_python.mp4 Download Code Python PythonVideoch_0_tut_2_python.mp4 Download Code Code Code Pandas Downloadcountries.csv Pandas Downloadcountries.csv Pandas Downloadcountries.csv Pandas Downloadcountries.csv Xlwings XlwingsSteps1. Open "Command Prompt", type `conda list` 2. If `xlwings` is not installed, then install using this - `conda install -c anaconda xlwings` 3. Install **addin** in Excel using this - `xlwings addin install` on the terminal. 4. Choose a directory and open a project there: `xlwings quickstart demo` 5. macro settings in the MS Excel - enable <kbd>Enable all macros</kbd> button in the `Trust Center >> Macro Settings >> Macro Settings` - enable <kbd>Trust access to the VBA project object model</kbd> button in the `Trust Center >> Macro Settings >> Developer Macro Settings`5. Print "Hello Xlwings!" 6. Add a UDF - `sumtwice()` References* Official website - Documentation - More - Xlwings XlwingsSteps1. Open "Command Prompt", type `conda list` 2. If `xlwings` is not installed, then install using this - `conda install -c anaconda xlwings` 3. Install **addin** in Excel using this - `xlwings addin install` on the terminal. 4. Choose a directory and open a project there: `xlwings quickstart demo` 5. macro settings in the MS Excel - enable <kbd>Enable all macros</kbd> button in the `Trust Center >> Macro Settings >> Macro Settings` - enable <kbd>Trust access to the VBA project object model</kbd> button in the `Trust Center >> Macro Settings >> Developer Macro Settings`5. Print "Hello Xlwings!" 6. Add a UDF - `sumtwice()` References* Official website - Documentation - More - Xlwings XlwingsSteps1. Open "Command Prompt", type `conda list` 2. If `xlwings` is not installed, then install using this - `conda install -c anaconda xlwings` 3. Install **addin** in Excel using this - `xlwings addin install` on the terminal. 4. Choose a directory and open a project there: `xlwings quickstart demo` 5. macro settings in the MS Excel - enable <kbd>Enable all macros</kbd> button in the `Trust Center >> Macro Settings >> Macro Settings` - enable <kbd>Trust access to the VBA project object model</kbd> button in the `Trust Center >> Macro Settings >> Developer Macro Settings`5. Print "Hello Xlwings!" 6. Add a UDF - `sumtwice()` References* Official website - Documentation - More - Xlwings XlwingsSteps1. Open "Command Prompt", type `conda list` 2. If `xlwings` is not installed, then install using this - `conda install -c anaconda xlwings` 3. Install **addin** in Excel using this - `xlwings addin install` on the terminal. 4. Choose a directory and open a project there: `xlwings quickstart demo` 5. macro settings in the MS Excel - enable <kbd>Enable all macros</kbd> button in the `Trust Center >> Macro Settings >> Macro Settings` - enable <kbd>Trust access to the VBA project object model</kbd> button in the `Trust Center >> Macro Settings >> Developer Macro Settings`5. Print "Hello Xlwings!" 6. Add a UDF - `sumtwice()` References* Official website - Documentation - More - Open "Command Prompt", type `conda list` 2. If `xlwings` is not installed, then install using this - `conda install -c anaconda xlwings` 3. Install **addin** in Excel using this - `xlwings addin install` on the terminal. 4. Choose a directory and open a project there: `xlwings quickstart demo` 5. macro settings in the MS Excel - enable <kbd>Enable all macros</kbd> button in the `Trust Center >> Macro Settings >> Macro Settings` - enable <kbd>Trust access to the VBA project object model</kbd> button in the `Trust Center >> Macro Settings >> Developer Macro Settings`5. Print "Hello Xlwings!" 6. Add a UDF - `sumtwice()` References* Official website - Documentation - More - Open "Command Prompt", type `conda list` 2. If `xlwings` is not installed, then install using this - `conda install -c anaconda xlwings` 3. Install **addin** in Excel using this - `xlwings addin install` on the terminal. 4. Choose a directory and open a project there: `xlwings quickstart demo` 5. macro settings in the MS Excel - enable <kbd>Enable all macros</kbd> button in the `Trust Center >> Macro Settings >> Macro Settings` - enable <kbd>Trust access to the VBA project object model</kbd> button in the `Trust Center >> Macro Settings >> Developer Macro Settings`5. Print "Hello Xlwings!" 6. Add a UDF - `sumtwice()` References* Official website - Documentation - More - Chapter-1 - Case study I 9 lectures 55:07 Infographic View Data Prepare Code Define Sheets View Code History Sheet_1 to DataFrame to Sheet_2 Figure, Axes Show Plot Add Legends Chapter-1 - Case study I

Additional information

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

See related categories

Automate Excel using Python - Xlwings | Series 1

£ 10 VAT inc.

The best Other Education courses

See all

See all