Data Analytics with Excel, VBA and Python - From the Ground Up

• There are no specific requirements needed to attend this course.

Data analytics is a crucial tool in business today. We will focus throughout on developing skills for practical hands on data analysis. The aim of the course is to help delegates to give evidence-based answers to questions: 

What has happened?

• processing and analyzing data
• producing informative data visualizations

What will happen?

• forecasting future performance
• evaluating forecasts

What should happen?

• turning data into evidence-based business decisions
• optimizing processes

The course itself can be delivered either as a 6 day classroom course or remotely over a period of weeks if preferred. We can work with you to deliver the course to best suit your needs.

Basic Excel

• Navigation
• Manipulating data
• Working with formulas and addresses
• Charts

Advanced Excel 

• Logical functions
• Scenario analysis
• Solver
• Macros
• First glimpse of code: VBA

VBA

• Data types
• Writing a function
• Controlling a program: conditional evaluation and loops
• Debugging techniques

Data Analytics with Python

• Introducing Python
• Variables and types
• Data manipulation in Python using Pandas
• Writing functions
• Data visualization using Matplotlib and Seaborn
• Data wrangling with Pandas

Introduction to Machine Learning with Python

• Linear Regression using scikit-learn
• Classification and regression trees with Python
• Classification using Support Vector Machines and Random Forests
• Clustering techniques using scikit-learn