Skip to content
Skills and Automation

Visit my Youtube Channel

YouTube
  • Home
  • Master Class
  • How To
  • Tutorial
  • Project
  • Useful Code
Search
Skills and Automation
Menu

Create a PowerPoint Slide Deck With Dynamic Commentary

Create a FULL Corporate Style PowerPoint Slide Deck based on Tables and Charts from Excel using Excel VBA. Automate the repetitive task of creating routine slide desks every month.
Read More
Control Your Macro From A Worksheet

Build a Worksheet to Control the Flow of a Macro

Construct a reporting macro, where the user has the ability to control various elements of the macro flow. There is a lot of variety of code here, with a huge emphasis on error handling.
Read More
Sed Reports and Reconcile Responses

VBA Project – Send Reports and Reconcile Responses

Build a 2-Step VBA Automation Project from scratch. We will send customized reports out to team members and reconcile their responses back to our original dataset.
Read More

Create And Send Multiple PDF Reports

Build a project where we will create and send multiple PDF reports.
Read More
Copy Paste Difficult Data

Excel VBA: Copy Paste Semi-Structured Data

Explore how to deal with semi-structured data. We will build one macro to deal with multiple scenarios.
Read More

Excel VBA: Compare Data [Before & After Versions]

Compare before and after versions of a dataset using Excel VBA
Read More
Compare Data Excel VBA

Manipulate Raw Data Using Excel VBA [Project]

Convert downloaded data from an external source into the format we want using Excel VBA.
Read More
Learn Excel VBA

Learn Excel VBA

Learn Excel VBA. Build a real-world project from scratch. Gain amazing tips. Code with confidence.
Read More

Schedule A Daily Report To Be Sent By Outlook Email Using Excel VBA [Project]

View the supporting code for the Youtube video. In this project, we'll create a daily task to extract data, create a new template and email users.
Read More

Copyright © 2025 Skills and Automation

  • Home
  • Master Class
  • How To
  • Tutorial
  • Project
  • Useful Code