Microsoft Excel Training Courses

Name	Description
Microsoft Excel 365 Advanced - Key Features & Business Intelligence	This MS Excel Advanced course explores some specialized capabilities of Excel using the data analysis and business intelligence features. Participants will use key functions and features including PivotTables and Power Pivots for analysis of large data sets as well as creating user defined functions, automating data imports, building table relationship and using Power Pivot advanced Data Analysis and expanding Excel's capability using Python.
Supercharge your Excel skills with Python and OpenPyXl	This course is for people who are proficient at Excel and want to add in the power of Python, the world's best programming language for data analytics. It assumes no experience with programming and will start by demonstrating how to set up a development environment. It will then cover the basic programming required to work with Python, followed by a walk-through of the facilities that are available in OpenPyXl - the main library for working with Excel from Python. It will conclude with some practical examples to demonstrate the extra power that Python can give you when working with Excel.

Name

Description

Microsoft Excel 365 Advanced - Key Features & Business Intelligence

This MS Excel Advanced course explores some specialized capabilities of Excel using the data analysis and business intelligence features. Participants will use key functions and features including PivotTables and Power Pivots for analysis of large data sets as well as creating user defined functions, automating data imports, building table relationship and using Power Pivot advanced Data Analysis and expanding Excel's capability using Python.

Supercharge your Excel skills with Python and OpenPyXl

This course is for people who are proficient at Excel and want to add in the power of Python, the world's best programming language for data analytics.

It assumes no experience with programming and will start by demonstrating how to set up a development environment. It will then cover the basic programming required to work with Python, followed by a walk-through of the facilities that are available in OpenPyXl - the main library for working with Excel from Python. It will conclude with some practical examples to demonstrate the extra power that Python can give you when working with Excel.