Cape Town · Excel · 100% online

Macros, VBA and AI in Excel course in Cape Town

If you repeat the same clicks every day or every month, a macro can do them for you. This unit takes you from recording simple macros to writing VBA that refreshes data, formats a report and exports it to PDF. You'll also learn to use AI as a copilot, with Barty, your AI tutor, helping you check your code.

✓ Start free, no card needed   ✓ 19 schools for US$ 29/month   ✓ 100% online   ✓ 24/7 AI tutor

en.academiabarterrubio.com
Excel macros and vba course in Cape Town — super academy dashboard
Excel macros and vba course in Cape Town on your phone
What you will master

What do I learn in the Macros, VBA and AI in Excel course in Cape Town?

  • Record, run, and save macros to automate repetitive tasks
  • Understand VBA structure and write macros with variables, loops, and conditions
  • Automate a recurring report: refresh, format, export to PDF, handle errors
  • Use AI to draft formulas and VBA, and verify the results

Who it is for: Experienced Excel users who want to save time by automating recurring tasks and reports.

Lessons in this unit

  1. Recording Macros
  2. Introduction to VBA
  3. Automating Reports
  4. Excel with AI

Expert level · Excel school

Cape Town, Western Cape

How is Macros, VBA and AI in Excel used in Cape Town?

Excel teaches you to organise data, use formulas, build tables and create clear charts. Many Cape Town businesses, from logistics teams to small agencies and hospitality venues, track orders, rosters and budgets in spreadsheets. You could build a staff roster that calculates hours automatically, or a stock sheet that flags when supplies need reordering, saving time every week.

Many people in Cape Town learn online with AI because it fits around work, study and family life. Whether you work in tourism, financial services, the port or a creative studio, you can study at your own pace with Barty, an AI tutor available around the clock. Lessons, challenges and projects help you build practical skills you can use in your daily work, and you finish with a certificate of completion.

Industries in Cape Town

  • Tourism
  • Financial services
  • Port and logistics
  • Film and media
  • Technology
  • Wine and agriculture
Pricing

How much does it cost? 19 schools for less than a coffee a day

You are not buying one course: you join the whole super academy. 19 schools that can take your career and your business further: Excel, AI, marketing, sales, design, music production, public speaking and more, with 1,076 lessons, an AI tutor that never gets tired of explaining and a certificate at the end of every level. On the annual plan it is US$ 0.68 a day: less than a coffee.

Monthly

US$ 29/month

≈ R 490/month approx. at today's rate

  • All 19 schools
  • Barty, 24/7 AI tutor
  • Projects graded with AI
  • Cancel anytime
Start monthly
BEST VALUE · SAVE US$ 99

Annual

US$ 249/year

≈ R 4,200/year approx. at today's rate

☕ US$ 0.68 a day (≈ R 12): less than a coffee

  • Everything in the monthly plan
  • 12 months to master several schools
  • A certificate for every level
  • Your progress and portfolio always with you
I want the annual plan

Pay with a debit or credit card, or with PayPal. You are charged in US dollars; the amount in ZAR is a reference at today's exchange rate and your bank makes the final conversion.

Other Excel courses in Cape Town

Macros, VBA and AI in Excel in other cities

FAQ

FAQ: excel macros and vba course in Cape Town

Do I need programming experience to learn VBA?

No. You start by recording macros, then learn how VBA code is organised and write a simple macro with variables, a loop, and a condition. Barty can help explain each line as you practice.

Can AI write my Excel formulas and VBA code?

AI can act as a copilot to draft formulas, VBA code, and analysis, but you'll learn to always verify results before using them in a real report. The unit teaches that checking habit.

Can I study online from Cape Town at my own pace?

Yes. The course is 100% online, so you only need a device and a reliable internet connection. You can study at times that suit your work or family schedule, and Barty is available 24/7 to answer your questions whenever you get stuck. Many students use a phone for short lessons, though a computer is more comfortable for longer projects.

Is excel macros and vba course 100% online from Cape Town?

Yes. You study at en.academiabarterrubio.com on your phone or computer, at your own pace and with no fixed schedule. All you need is internet. Barty, the AI tutor, is with you 24 hours a day.

How much does it cost and what is included?

The membership costs US$ 29 a month or US$ 249 a year and includes all 19 schools, not just one course: interactive lessons, challenges, simulator, AI tutor and certificates of completion.

Do I get a certificate?

Yes. When you complete each level you receive a Barter AI Academy certificate of completion with a verification code that you can share on LinkedIn. It is issued by the academy; it is not an accredited degree.

➕ Plus included

Also learn Spanish, from beginner to fluent

Your membership also includes the Spanish school: listen to real phrases, practise your pronunciation with the microphone and get instant corrections from Barty, your AI tutor. From your first «hola» to Spanish for travel, work and business.

See the Spanish school →

What the plus includes

  • 5 levels: Basic to Crack
  • Listening and speaking exercises
  • Spanish for travel, work and sales
  • Placement test to start at your level

Start Macros, VBA and AI in Excel today from Cape Town

Create your account, choose your plan and start today. Your first lesson takes 7 minutes.

Create my free account →