Coding tutorials made easy.
YouTube • Facebook • Instagram • Website
Overview
-
Python Tutorials Explore how to use Python and supercharge you're analysis.
-
VBA Learn how to use VBA to automate your everyday task, check out how to use VBA with Python.
-
JavaScript Learn how to make new Office Add-ins using the JavaScript API.
-
SQL Get your data quickly by writing simple SQL statements.
-
Data Science Make smarter algorithms that leverage different models.
To learn more about Sigma Coding check out my website. This repository is managed by Alex Reed if you have any questions please reach out.
VBA Tutorials
VBA is the go to tool to help automate Office applications and take reptitive tasks and turn them into simple macros that save time and effort. The VBA object model is used across multiple applications and contains 100s of objects that can be controlled and manipulated. This section was intended for users who want to take a deep dive into VBA and explore not just Excel VBA but the other Office Applications. At this point, we currently have code for the following applications.
-
Excel VBA Explore the core concepts neeed to master Excel VBA. Along with this, take a deep dive into the different object heiarchies like Ranges, Pivot Tables, and Power Pivot.
-
Word VBA Explore how to manipulate and modify Word documents using VBA. Word documents are great for documenting a wide arrange of information, make VBA your friend and see how to format these documents uing VBA.
-
PowerPoint VBA PowerPoint is the go to presentation creator for any company, but help save time by exploring how to control links, shapes and other PowerPoint objects at your disposal.
Python Tutorials
Python is a powerful program language that is easy to use and learn, many who want to learn programming start with Python. In my tutorials, I am currently focusing on how to use Python the VBA object model. This opens up a whole host of new capabilities that we can now take advantage of.
-
Python VBA The Win32 library is a powerful library that allows for quick access into different Window objects. Unfortunately, documentation is hard to come by and when it is found it's hard to follow or difficult to apply it to your case. I wanted to make this easier for everyone by making tutorials and walking through the important steps to help grasp the fundamental concepts.
-
Python APIs APIs are an easy and standardized way to access information across different companies. Let's explore how to use popular APIs to capture valuable pieces of data.
Resources
| Object Library | Description |
|---|---|
| Excel VBA | This is the link to the Excel Object model documentation |
| PowerPoint VBA | This is the link to the PowerPoint Object model documentation. |
| Outlook VBA | This is the link to the Outlook Object model documentation. |
| Word VBA | This is the link to the Word Object model documentation. |