Duration
3 days
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
- Accessing one cell
- Accessing many cells
- Values only
- Data storage
- Saving to a file
- Saving as a stream
- Loading from a file
- Write a workbook
- Read an existing workbook
- Using number formats
- Using formular
- Optimised Modes
- Read-only mode
- Write-only mode
- Inserting and deleting
- rows and columns
- moving ranges of cells
- Working with libraries
- Pandas
- NumPy
Working with Charts
Excel Macro with Python
- Library installation
- Macro Functions
Introduction
- Exposing Functions as Macros
- Keyboard Shortcuts
- Calling Macros From Excel
Excel VBA with Python
- The Excel Object Model
- Accessing the Excel Object Model in Python
- 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.