948 Steps to 6 Figures by Learning Excel-VBA and Other Skills

Introduction

This is a work in progress

Excel is one of the most popular desktop applications ever developed. It's used in almost all companies to improve productivity.
But there's a little-known secret about Excel. Lurking in a hidden spot is a feature that turns Excel from a great tool to a power tool.
This tool goes by the name VBA (Visual Basic for Applications) also known as Macros. The Developer Tab is where you can write or record Macros to do your job faster.

You're about to take a journey, guided by me, to learn Excel/VBA and strive for a 6 figure salary.

There are no guarantees in life, but I promise you if you learn the skills in this you'll have the skills that will

help get you a promotion

impress your colleagues

Find a better job

Be more productive

How do I know it's possible to make 6 figures with Excel Skills? I've been doing it for many years.

I don't want to mislead you but 6 figures in certain areas of the US will be more difficult than in big cities. Also, certain applications will get you more money than others.

I will use the following terms to mean the same thing:

VBA

Macros

Code

Program

I've compiled 948 Steps to 6 Figures by Learning Excel-VBA and Other Skills.

I've laid out in this , in simple step-by-step lessons to go from someone with no knowledge of Macros to a VBA expert.

To become an expert at VBA, you must spend many hours, there are no shortcuts. But to get past the beginner level should take relatively a short time. It won't take long if you follow the instructions in this . I've worked for many companies using my Excel/VBA skills which have helped me earn a six-figure salary, build several websites, and have more fun on the job.

The reason I love Excel/VBA is because of its power and simplicity and ability to develop tools and spreadsheets that save time and make you highly skilled in your job.

A 6 figure salary might come from just Excel/VBA alone but to increase your odds, I will help you learn technologies, and skills. I'll also give you some information on:

SQL and Databases

HTML

CSS

JavaScript

ASP

Windows

Job skills

Getting a Job skills

How to Learn

How to Solve problems

Some of the many topics we will cover are:

Vlookups - Combining data from multiple sources

Charts - Summarizing data with graphs

Pivot Tables - Slicing and dicing data into different summaries

Understanding someone else's code

Conditional Formatting - Color coding based on a condition (ex. red if date expired)

Data Validation - Selecting data from a drop-down

Batch processes - running your macros unattended

Shortcuts - Doing what use to take 10 steps in 1 step

Testing - How to make sure your Spreadsheet works properly

Documentation - How to document what you've done

Actual work projects - Using actual on the job type projects and not how to do a bubble sort type of examples

Sending emails - Using Excel to connect with email

Connecting with Microsoft Apps (PowerPoint, Word, Outlook)

Processing files - Learn the various way of creating, deleting, and processing files

and many other useful techniques

We will be developing several tools that will make you more productive while using Excel.

Adding a Table of Contents with hyperlinks to other sheets

Developing a tool that will find why your spreadsheet is so large

Accessing a database from Excel

Scraping data from the web and saving it

Creating simple websites using ASP (Active Server Pages) which is a form of VBA

So buckle up and let's go on this journey to Excel/VBA Expertise.

Prerequisites

A copy of Microsoft Excel

Dual monitors - able to show VB Editor and Excel files at the same time

Experience using Microsoft Excel

Not Supported

This training doesn't support the following but may work:

Google Sheets

Non-windows computers

Mac
Chromebook

Alternative versions of Excel

How you will learn this?

The Immediate Window

The Macro recorder

Repetition

Small projects that build to big projects

You can't learn to swim from a , you must get in the water and swallow some of it to learn

The following topics are covered in this

Batch - Running unattended

- Modify other peoples' code
- Reverse engineer someone's code
- ASP aka VBScript
- Phone apps
- Juggling
- 20 years writing the book
- show cover of
- Make this fun
- Hide the chapters that the user can record
- Create a minimum document off of this
- Uses real-job examples
- Who is this book for ? students, maybe textbook, Speak with Rob K. about getting it published
- Macros are less scary
- It's learning a language
- Teach the top 80/20
- >