Course Description
To best utilize Python is to make use of the numerous libraries, or extensions, at your disposal. Python is open-source, allowing users to modify and alter the code in creative ways. What this means is that many libraries have been developed to aid in complex and creative tasks that would be impossible or severely limited in Excel and Excel VBA.
Anyone can create and develop any number of libraries to support Python, which means the possibilities are endless.
Why ?
Create a custom function in Excel tru Pyton.
Your comfortablity of Excel in Python.
Speed up your data operations significantly by using Python.
Python loaded with more support excel libraries.
Libraries for just about anything in Python.
Prerequisite
Python fundamentals
Course Outline
The Begining
Introduction
Python and Library installation
With Python
Create a workbook
Playing with data o Accessing one cell o Accessing many cells o Values only
Data storage o Saving to a file o Saving as a stream
Loading from a file
Write a workbook
Course Outline :: Python VBA::
Read an existing workbook
Using number formats
Using formular
Optimised Modes o Read-only mode o Write-only mode
Inserting and deleting o rows and columns o moving ranges of cells
Working with libraries o Pandas o NumPy
Working with Charts
Excel Macro with Python
Library installation o Macro Functions
Introduction
Exposing Functions as Macros
Keyboard Shortcuts
Calling Macros From Excel
Excel VBA with Python o The Excel Object Model o Accessing the Excel Object Model in Python o Differences between VBA and Python
Case Sensitivity
Calling Methods
Named Arguments
Properties
Properties with Arguments
Programme scope, delivery arrangements and suitability are confirmed during enquiry.