Search
Log in
  • Home

  • Categories

  • Audiobooks

  • E-books

  • Magazines

  • For kids

  • Top lists

  • Help

  • Download app

  • Use campaign code

  • Redeem gift card

  • Try free now
  • Log in
  • Language

    🇧🇪 Belgique

    • FR
    • EN

    🇩🇰 Danmark

    • DK
    • EN

    🇩🇪 Deutschland

    • DE
    • EN

    🇪🇸 España

    • ES
    • EN

    🇫🇷 France

    • FR
    • EN

    🇳🇱 Nederland

    • NL
    • EN

    🇳🇴 Norge

    • NO
    • EN

    🇦🇹 Österreich

    • AT
    • EN

    🇨🇭 Schweiz

    • DE
    • EN

    🇫🇮 Suomi

    • FI
    • EN

    🇸🇪 Sverige

    • SE
    • EN
  1. Books
  2. Nonfiction
  3. Computer sciences

Read and listen for free for 30 days!

Cancel anytime

Try free now
0.0(0)

Learn Excel in 24 Hours

Learn to automate Excel using VBA (Visual Basic for Applications)

VBA is a event driven programming language and you can program any actions that you would do manually in an Excel.

You can automate Excel using VBA to pull data from multiple sources, process data, generate reports and graphs and so much more. Called as Macros they help automate repetitive task.

Here is what is included-

Table Of Content

Chapter 1: Introduction to Macros in Excel

What is a macro?

The importance of macros in Excel

What is VBA in a layman's language?

Macro Basics

Step by step example of recording macros in Excel

Enable Developer Option

Chapter 2: Your Fist VBA in Excel

What is VBA?

Why VBA?

Personal & business applications of VBA in excel

Visual Basic for Applications VBA basics

Enable Developer Option

Step by step example of creating a simple EMI calculator in Excel

Chapter 3: VBA Data Types, Variables & Constant

VBA Variables

Excel VBA Data-Types

Constant in VBA

Chapter 4: VBA Arrays

What is an Array?

What are Advantages of arrays?

Types of arrays

VBA Array Demonstrated with Example

Testing our application

Chapter 5: VBA Excel Form Control & Activex Control

Creating VBA Form/GUI controls in Excel

How to use ActiveX control in VBA

Prerequisite

Chapter 6: VBA Arithmetic Operators

Chapter 7: VBA String Operators

Chapter 8: VBA Comparison Operators

Chapter 9: VBA Logical Operators

Chapter 10: Excel VBA Call a Subroutine

What is Subroutine?

Why use subroutines

Rules of naming subroutines and functions

Subroutine practical example

Chapter 11: Excel VBA Function Tutorial: Return, Call, Examples

Chapter 12: VBA Range Objects

What is VBA Range?

Introduction to Referencing Objects in VBA

How to refer to Excel VBA Range Object using Range property

Refer to a Single cell using the Worksheet.Range Property

Cell Property

Range Offset property


Author:

  • Alex Nordeen

Format:

  • E-book

Duration:

  • 83 pages

Language:

English

Categories:

  • Nonfiction
  • Computer sciences

More by Alex Nordeen

Skip the list
  1. C++ Learn in 24 Hours

    Alex Nordeen

    book
  2. Learn DBMS in 24 Hours

    Alex Nordeen

    book
  3. Learn Operating System in 24 Hours

    Alex Nordeen

    book
  4. Learn Design and Analysis of Algorithms in 24 Hours

    Alex Nordeen

    book
  5. Learn VBScript in 24 Hours

    Alex Nordeen

    book
  6. Linux: Learn in 24 Hours

    Alex Nordeen

    book
  7. C# for Beginners: Learn in 24 Hours

    Alex Nordeen

    book
  8. Learn SQL in 24 Hours

    Alex Nordeen

    book
  9. Learn Selenium in 24 Hours

    Alex Nordeen

    book
  10. Learn C Programming in 24 Hours

    Alex Nordeen

    book
  11. Learn Hbase in 24 Hours

    Alex Nordeen

    book

Others have also read

Skip the list
  1. The Art of Laziness : Overwin uitstelgedrag en boost je productiviteit

    Library Library Mindset

    audiobookbook
  2. Wandelingen met Igor : De band tussen mens en hond van de steentijd tot nu

    Tiina Raevaara

    book
  3. Amerika Amerika : Unieke verhalen uit een diep verdeeld land

    Marieke de Vries

    book
  4. Engels vocabulaireboek

    Pinhok Languages

    book
  5. De grondbeginselen van Microsoft Excel : Het begrijpen en beheersen van de Microsoft spreadsheet

    Priscillia Mommens-Valenduc

    book
  6. Using Excel - 2023 Edition : The Step-by-step Guide to Using Microsoft Excel

    Kevin Wilson

    book
  7. Efficiency Best Practices for Microsoft 365

    Dr.Nitin Paranjape

    book
  8. Excel 2022 Beginner’s User Guide

    Kylie Cox

    book
  9. Gelukkig kunnen we wandelen : 52 weken lang wandeltips en inspiratie

    Annabel Streets

    book
  10. Hands-On Microsoft Teams

    João Ferreira

    book
  11. Frans vocabulaireboek

    Pinhok Languages

    book
  12. Improve your PivotTables with Excel : Manual

    Rémy Lentzer

    book

Help and contact


About us

  • Our story
  • Career
  • Press
  • Accessibility
  • Nextory One
  • Partner with us
  • Investor relations
  • Instagram
  • Facebook

Explore

  • Categories
  • Audiobooks
  • E-books
  • Magazines
  • For kids
  • Top lists

Popular categories

  • Crime
  • Biographies and reportage
  • Fiction
  • Feel-good and romance
  • Personal development
  • Children's books
  • True stories
  • Sleep and relaxation

Nextory

Copyright © 2025 Nextory AB

Privacy Policy · Terms ·
Excellent4.3 out of 5