Data & AI1:1 mentoring

Excel & VBA for Programming

Master Excel formulas and PivotTables, then automate the boring work with macros and VBA code, at your pace.

Level:: Beginner to intermediate
Format:: 1:1 online mentoring

Free, no-obligation chat · Affordable plans that fit your budget · Start this week

1:1 personal attentionOne mentor, one student, at your pace.
Flexible timingsSessions that fit your week and time zone.
Affordable plansPlans that fit your budget.
Practise between sessionsShort problems that build confidence.

About this course

Learn Excel & VBA for Programming online

Excel is the tool most workplaces run on, and VBA lets you turn repeated clicks into a program. Learners usually struggle with formulas that break when copied, choosing between lookup functions, building PivotTables that answer the right question, and the jump from recording a macro to writing VBA code that is safe to reuse.

This course follows the standard Excel curriculum and the official VBA documentation: formulas and functions, lookup functions, tables, data cleaning, PivotTables and charts, then the macro recorder, the VBA language, working with the Excel object model, error handling, UserForms and automation of files and reports. Each module lists its topics and what you will be able to do at the end.

Learn with an affordable 1:1 online mentor who builds workbooks with you and explains each step with short examples. MentorNxt has free self-study lessons for Java and Python only, so Excel and VBA are taught through mentoring. Message us on WhatsApp or email, or fill in the short form, for a free, no-obligation chat. We will suggest a plan that fits your budget and flexible timings, and you can start this week.

Who this course is for

Students and graduates who want strong Excel skills for work
Office professionals who repeat the same steps every week
Finance, operations and HR staff who build reports in Excel
Beginners who want to learn programming through a tool they already use
Analysts preparing to move on to Power BI or Python

Outcomes

What you'll learn

Write reliable formulas using relative, absolute and mixed references
Look up data with XLOOKUP, INDEX and MATCH, and VLOOKUP
Clean and organise data using Excel Tables, sorting, filtering and validation
Build PivotTables, slicers and charts that summarise data clearly
Record a macro and then read, edit and improve the VBA code
Write VBA with variables, conditions, loops, procedures and functions
Control workbooks, worksheets and ranges through the Excel object model
Create UserForms and automate reports and file tasks safely

Skills you'll gain

Excel formulas
Lookup functions
Excel Tables
PivotTables
Charts
Data cleaning
Macros
VBA
Object model
UserForms
Error handling
Automation

Detailed syllabus

Excel & VBA for Programming syllabus

Every module lists its topics and what you will be able to do. Your mentor plans sessions around them and your own goals.

Module 1
Excel essentials and formulas
Working confidently with cells, formulas and references.
- The Excel interface, workbooks and worksheets
- Entering and formatting data
- Formulas and operator order
- Relative, absolute and mixed references
- SUM, AVERAGE, MIN, MAX and COUNT
- Named ranges
- Copying formulas and fill handle
- Common errors such as #REF! and #DIV/0!
By the end of this module you can
- Build formulas that copy correctly across rows and columns
- Trace and fix common formula errors
Covered in 1:1 mentoring sessions
Module 2
Logical, text, date and maths functions
The everyday functions that shape and clean data.
- IF, AND, OR and IFS
- IFERROR
- SUMIF, SUMIFS, COUNTIF and COUNTIFS
- LEFT, RIGHT, MID, LEN, TRIM and TEXTJOIN
- Dates with TODAY, EDATE and NETWORKDAYS
- ROUND and ROUNDUP
- Dynamic array functions: FILTER, SORT, UNIQUE
By the end of this module you can
- Combine functions to answer a business question
- Clean text and date columns with formulas
Covered in 1:1 mentoring sessions
Module 3
Lookup functions
Finding and joining data across tables.
- VLOOKUP and its limits
- XLOOKUP
- INDEX and MATCH together
- Exact versus approximate match
- Lookups across sheets and workbooks
- Handling missing matches
- Two-way lookups
By the end of this module you can
- Choose the right lookup function for a task
- Join two lists without copy and paste
Covered in 1:1 mentoring sessions
Module 4
Tables, data cleaning and validation
Keeping data organised, clean and safe to enter.
- Excel Tables and structured references
- Sorting and multi-level sorting
- Filtering and advanced filters
- Remove duplicates
- Text to columns and Flash Fill
- Data validation and drop-down lists
- Conditional formatting
- Protecting sheets and cells
- Introduction to Power Query
By the end of this module you can
- Turn a messy list into a clean Excel Table
- Stop bad data entering with validation rules
Covered in 1:1 mentoring sessions
Module 5
PivotTables and charts
Summarising large data sets and presenting them visually.
- Creating a PivotTable
- Rows, columns, values and filters
- Grouping dates and numbers
- Calculated fields
- Slicers and timelines
- PivotCharts
- Column, line, pie and combo charts
- Building a simple dashboard
By the end of this module you can
- Summarise thousands of rows in a PivotTable
- Create a one-page dashboard with charts and slicers
Covered in 1:1 mentoring sessions
Module 6
Macros and the VBA editor
Recording macros and finding your way around the Visual Basic Editor.
- Enabling the Developer tab
- Recording a macro
- Absolute and relative recording
- The Visual Basic Editor, Project Explorer and Immediate window
- Running a macro from a button or shortcut
- Macro security and file types such as .xlsm
- Reading recorded code
By the end of this module you can
- Record a macro and run it safely
- Open the VBA editor and read the code a macro produced
Covered in 1:1 mentoring sessions
Module 7
VBA language fundamentals
Variables, decisions, loops and procedures in VBA.
- Sub procedures and Function procedures
- Option Explicit and declaring variables with Dim
- Data types: Integer, Long, Double, String, Boolean, Variant
- Constants
- If...Then...Else and Select Case
- For...Next, For Each and Do...Loop
- MsgBox and InputBox
- Arrays
- Calling procedures and passing arguments
By the end of this module you can
- Write VBA procedures with variables, decisions and loops
- Create a custom function that you can use in a cell
Covered in 1:1 mentoring sessions
Module 8
The Excel object model
Controlling Excel from code through Application, Workbook, Worksheet and Range.
- The object hierarchy
- Workbooks and Worksheets collections
- The Range object and the Cells property
- Value, Formula, Offset and Resize
- Finding the last used row
- CurrentRegion
- With...End With
- Copy, paste and PasteSpecial
- Formatting from code
- Working with charts and PivotTables in VBA
By the end of this module you can
- Read from and write to ranges in code
- Loop through rows of data and change them
Covered in 1:1 mentoring sessions
Module 9
Errors, debugging and good practice
Writing macros that do not crash or damage data.
- Syntax, runtime and logic errors
- Breakpoints, stepping and the Watch window
- Debug.Print
- On Error GoTo and Resume Next
- The Err object
- Screen updating and calculation settings
- Naming, comments and structure
- Avoiding Select and Activate
By the end of this module you can
- Find a bug using breakpoints and the Immediate window
- Add error handling so a macro fails gracefully
Covered in 1:1 mentoring sessions
Module 10
Events and UserForms
Reacting to what the user does and building simple forms.
- Workbook and worksheet events
- Designing a UserForm
- Text boxes, combo boxes, option buttons and command buttons
- Form events and properties
- Validating form input
- Writing form data to a sheet
- Showing and hiding forms
By the end of this module you can
- Build a data entry form that saves to a worksheet
- Run code automatically when a sheet changes
Covered in 1:1 mentoring sessions
Module 11
Working with files and other applications
Automating tasks that span files, folders and Office apps.
- Opening, saving and closing workbooks
- Looping through files in a folder
- Importing text and CSV files
- Exporting to PDF
- Sending email with Outlook from VBA
- Controlling Word from Excel
- Early and late binding overview
- Scheduling with Application.OnTime
By the end of this module you can
- Combine many files into one workbook with code
- Send a report as a PDF without manual steps
Covered in 1:1 mentoring sessions
Module 12
Automation projects and next steps
Bringing the skills together and looking at what comes after VBA.
- Planning an automation from a manual process
- Designing inputs, steps and outputs
- Testing with sample data
- Documenting a macro for others
- Sharing workbooks and personal macro workbook
- Office Scripts and Power Automate overview
- From VBA to Python and Power BI
By the end of this module you can
- Plan and build a small automation from start to finish
- Decide when VBA is the right tool and when another tool fits better
Covered in 1:1 mentoring sessions

Ways to learn

How you can learn Excel & VBA for Programming

Excel & VBA for Programming mentor, 1:1 online

A mentor who knows this course plans sessions around your goal, explains each idea with fresh examples and checks your understanding. Personal attention, flexible timings in your time zone and affordable plans that fit your budget.

Talk to our team

How it works

Your learning journey

Four simple steps to start Excel & VBA for Programming with a mentor. A real person replies to you; there is no booking system.

Step 1: Talk to us
Message us on WhatsApp or email, or fill in the short form. The first chat is free, with no obligation.
Step 2: Get your plan
We listen to your goal, level and deadlines, then suggest a plan that fits your budget and timings.
Step 3: Learn with your mentor
Online 1:1 sessions with a mentor who knows your course, explains clearly and checks your understanding.
Step 4: Practise & track progress
Keep going between sessions with practice, and watch your confidence grow week by week.

Learn by doing

Projects and practice

Monthly sales report generator
Import a raw data sheet, clean it, build a PivotTable and chart, and use a macro to refresh and export the report as a PDF.
Invoice and quote tool
A UserForm that captures customer and item details, calculates totals with formulas and saves each invoice to a log sheet.
Folder consolidator
A VBA macro that loops through all workbooks in a folder and copies their data into one master sheet with the file name added.
Attendance tracker
A workbook with drop-down lists, conditional formatting and a macro that creates a summary for each month.

Your progress

What you'll be able to do

Milestones from the start, middle and end of the syllabus.

Build formulas that copy correctly across rows and columns
Early on
Write VBA procedures with variables, decisions and loops
Halfway
Plan and build a small automation from start to finish
By the end

FAQs

Excel & VBA for Programming: frequently asked questions

I have never programmed. Can I learn VBA?

Yes. VBA is a gentle first language because you can see the result in Excel straight away. You start with the macro recorder, then learn to read and write the code step by step with your mentor.

Is there a self-study option?

Our free self-study lessons exist for Java and Python only. Excel and VBA are taught through 1:1 mentoring, where a mentor builds workbooks with you and plans sessions around your goals.

Which version of Excel do I need?

Excel 2016 or later on Windows works for most of the course. Some functions such as XLOOKUP and dynamic arrays need Microsoft 365 or Excel 2021. VBA works in desktop Excel, but not in Excel for the web, so your mentor will check your setup in the first session.

Does VBA work on a Mac?

VBA runs in Excel for Mac, but some features, such as UserForms and links to other Office apps, are limited. Your mentor will point out the differences and adjust the examples.

Can I do only the Excel part or only the VBA part?

Yes. If you already use formulas and PivotTables, your mentor can start at the macro modules. If you only need formulas and reporting, you can stop before VBA.

Can I use my own work files?

Yes, if your employer allows it. Many learners automate a real task from their job. You can also practise with sample files from your mentor so no private data is needed.

How much does mentoring cost?

Mentoring is affordable, with plans that fit your budget. Tell us your goal and how often you would like sessions, and our team will suggest an option that works for you in a free, no-obligation chat.

How do I get started?

Message us on WhatsApp or email, or fill in the short form on this page. Our team replies, talks through your goal and level, and arranges a mentor at flexible timings in your time zone. You can start this week.

Free, no-obligation chat

Talk to our team about Excel & VBA for Programming

Tell us what you need. Our support team replies within one working day, by email or WhatsApp, whichever you prefer, and arranges your mentor.

Prefer to talk first?

Message the support team directly. We usually reply the same day.

Chat on WhatsApp Email us

Our mentors teach and explain. They never complete graded work, tests or assessments for students.

Keep going

Syllabus references

Last reviewed9 November 2026

Ready to start Excel & VBA for Programming?

Message us on WhatsApp or email, or fill in the short form. Our team replies with a plan that fits your goal and budget, and you can start this week.

Fill in the short form

WhatsApp Email us

Talk to us about a mentor

WhatsApp Email us

Learn Excel & VBA for Programming online

Who this course is for

What you'll learn

Skills you'll gain

Excel & VBA for Programming syllabus

Excel essentials and formulas

Logical, text, date and maths functions

Lookup functions

Tables, data cleaning and validation

PivotTables and charts

Macros and the VBA editor

VBA language fundamentals

The Excel object model

Errors, debugging and good practice

Events and UserForms

Working with files and other applications

Automation projects and next steps

How you can learn Excel & VBA for Programming

Excel & VBA for Programming mentor, 1:1 online

Your learning journey

Step 1: Talk to us

Step 2: Get your plan

Step 3: Learn with your mentor

Step 4: Practise & track progress

Projects and practice

Monthly sales report generator

Invoice and quote tool

Folder consolidator

Attendance tracker

What you'll be able to do

Excel & VBA for Programming: frequently asked questions

Talk to our team about Excel & VBA for Programming

Related courses

Power BI

SQL and Databases

Data Analysis with Python

Programming for Beginners

Python Programming

Syllabus references

Ready to start Excel & VBA for Programming?

Learn Excel & VBA for Programming online

Who this course is for

What you'll learn

Skills you'll gain

Excel & VBA for Programming syllabus

Excel essentials and formulas

Logical, text, date and maths functions

Lookup functions

Tables, data cleaning and validation

PivotTables and charts

Macros and the VBA editor

VBA language fundamentals

The Excel object model

Errors, debugging and good practice

Events and UserForms

Working with files and other applications

Automation projects and next steps

How you can learn Excel & VBA for Programming

Excel & VBA for Programming mentor, 1:1 online

Your learning journey

Step 1: Talk to us

Step 2: Get your plan

Step 3: Learn with your mentor

Step 4: Practise & track progress

Projects and practice

Monthly sales report generator

Invoice and quote tool

Folder consolidator

Attendance tracker

What you'll be able to do

Excel & VBA for Programming: frequently asked questions

Talk to our team about Excel & VBA for Programming

Related courses

Power BI

SQL and Databases

Data Analysis with Python

Programming for Beginners

Python Programming

Syllabus references

Ready to start Excel & VBA for Programming?