Tutorvo
Menu
Courses Guides Pricing Log in Sign up
Excel VBA Beginner

Ranges & Cells

Point your code at exactly the right cells and read or write them without ever clicking.

8 lessons 56 min Certificate

  • One-time payment
  • 14-day money-back guarantee
  • Secure checkout with Stripe

About this course

Almost every macro reads or writes cells, so mastering ranges pays off immediately. This course covers the essentials in depth. You work with the Range object and Cells by row and column, and learn why referencing beats selecting. You read and write values, move around with Offset and Resize, and capture blocks of data with CurrentRegion and UsedRange. A dedicated lab finds the last row reliably, and the final lesson makes every reference explicit about its sheet so code never writes to the wrong place. Each lab is checked automatically. For VBA beginners who want a solid foundation before tackling larger automation projects.

Curriculum

Course content

8 lessons · 56 min · final exam

  1. The Range ObjectReading10 min
    Unlocked when you buy the course
  2. Cells(row, column)Reading6 min
    Unlocked when you buy the course
  3. Selecting vs ReferencingReading7 min
    Unlocked when you buy the course
  4. Reading and Writing ValuesReading7 min
    Unlocked when you buy the course
  5. Moving Around with Offset and ResizeReading6 min
    Unlocked when you buy the course
  6. CurrentRegion and UsedRangeReading7 min
    Unlocked when you buy the course
  7. Finding the Last RowReading7 min
    Unlocked when you buy the course
  8. Being Explicit About the SheetReading6 min
    Unlocked when you buy the course
  9. Final exam8 questions, 75% to pass, unlimited retries.

Certificate

Finish with a certificate you can verify

Complete every lesson and pass the final exam to receive a certificate of completion for this course, with a unique credential ID and a public verification page.

  • Names the course, your score and the date of issue
  • A verification link for your CV or LinkedIn profile
  • 8 questions, 75% to pass, unlimited retries.

A Tutorvo certificate confirms that you completed a course. It is not an official or professional qualification.

Illustration. Your certificate shows your own name, course and credential ID.

Before you buy

Questions about this course

Is this a subscription?

No. You pay $9.99 once for this course. There is no subscription and nothing renews automatically. Prices are in US dollars; taxes may be added where required.

What exactly do I get?

All lessons and labs of this course, the final exam and the certificate, including later updates to the course, for as long as Tutorvo offers it. Access is personal and tied to your account.

Can I get a refund?

Yes. If you are not satisfied, email hello@tutorvo.com within 14 days of buying and we refund the course in full via Stripe. The guarantee does not apply once a certificate for the course has been issued to you, or where there are signs of abuse.

When can I start?

Right after payment. Access starts immediately at your request; for consumers in the EU/EEA the statutory right of withdrawal therefore ends once access has begun, while our 14-day money-back guarantee applies regardless.

Do I need Excel or other software?

No. The labs run in a spreadsheet inside your browser on a laptop, tablet or phone. Function names and syntax follow Excel.

Is the certificate an official qualification?

No. It confirms that you completed all lessons of the course and passed its final exam. It is not an official, state-recognised or professional qualification. The name is taken from your profile when the certificate is issued.

Full details are in our Terms · hello@tutorvo.com

Browse all Excel VBA courses →
Excel VBA

VBA Basics

8 lessons · 55 min

BeginnerCertificate$9.99
Excel VBA

Logic & Loops

8 lessons · 55 min

BeginnerCertificate$9.99
$9.99one-time payment
Buy course