About this ebook
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
Read more from Alex Nordeen
Linux: Learn in 24 Hours Rating: 5 out of 5 stars5/5Learn SAP MM in 24 Hours Rating: 0 out of 5 stars0 ratingsPython: Learn Python in 24 Hours Rating: 4 out of 5 stars4/5Learn HANA in 24 Hours Rating: 5 out of 5 stars5/5Learn SQL in 24 Hours Rating: 5 out of 5 stars5/5Learn R Programming in 24 Hours Rating: 0 out of 5 stars0 ratingsLearn PMP in 24 Hours Rating: 0 out of 5 stars0 ratingsLearn SAP Basis in 24 Hours Rating: 5 out of 5 stars5/5Learn JavaScript in 24 Hours Rating: 3 out of 5 stars3/5Learn MongoDB in 24 Hours Rating: 5 out of 5 stars5/5Learn Operating System in 24 Hours Rating: 0 out of 5 stars0 ratingsLearn SAP SD in 24 Hours Rating: 5 out of 5 stars5/5Learn Data Warehousing in 24 Hours Rating: 0 out of 5 stars0 ratingsLearn SAP HR in 24 Hours Rating: 5 out of 5 stars5/5Learn Software Testing in 24 Hours Rating: 0 out of 5 stars0 ratingsLearn SAP BI in 24 Hours Rating: 3 out of 5 stars3/5C++ Learn in 24 Hours Rating: 0 out of 5 stars0 ratingsBusiness Analysis : Learn in 24 Hours Rating: 0 out of 5 stars0 ratingsLearn Selenium in 24 Hours Rating: 0 out of 5 stars0 ratingsLearn SQLite in 24 Hours Rating: 0 out of 5 stars0 ratingsLearn C Programming in 24 Hours Rating: 0 out of 5 stars0 ratingsLearn PHP in 24 Hours Rating: 0 out of 5 stars0 ratingsC# for Beginners: Learn in 24 Hours Rating: 0 out of 5 stars0 ratingsHacking : Guide to Computer Hacking and Penetration Testing Rating: 5 out of 5 stars5/5Learn Hadoop in 24 Hours Rating: 0 out of 5 stars0 ratingsLearn AngularJS in 24 Hours Rating: 0 out of 5 stars0 ratingsLearn Design and Analysis of Algorithms in 24 Hours Rating: 0 out of 5 stars0 ratingsLearn VBScript in 24 Hours Rating: 0 out of 5 stars0 ratingsLearn Cassandra in 24 Hours Rating: 0 out of 5 stars0 ratings
Related to Learn Excel in 24 Hours
Related ebooks
Excel : The Ultimate Comprehensive Step-By-Step Guide to the Basics of Excel Programming: 1 Rating: 5 out of 5 stars5/5Mastering Excel Macros: Introduction: Mastering Excel Macros, #1 Rating: 4 out of 5 stars4/5Excel 2021 Rating: 4 out of 5 stars4/5Mastering Excel: Starter Set Rating: 2 out of 5 stars2/5Excel VBA: A Beginners' Guide Rating: 4 out of 5 stars4/5Mastering Microsoft Excel 2016: How to Master Microsoft Excel 2016 in 30 days Rating: 5 out of 5 stars5/5Excel VBA Recipes Rating: 4 out of 5 stars4/5EXCEL: Microsoft: Boost Your Productivity Quickly! Learn Excel, Spreadsheets, Formulas, Shortcuts, & Macros Rating: 0 out of 5 stars0 ratingsSecrets of MS Excel VBA Macros for Beginners !: Save Your Time With Visual Basic Macros! Rating: 4 out of 5 stars4/5Microsoft Excel: Advanced Microsoft Excel Data Analysis for Business Rating: 0 out of 5 stars0 ratingsExcel :The Ultimate Comprehensive Step-by-Step Guide to Strategies in Excel Programming (Formulas, Shortcuts and Spreadsheets): 2 Rating: 0 out of 5 stars0 ratingsExcel 101: A Beginner's & Intermediate's Guide for Mastering the Quintessence of Microsoft Excel (2010-2019 & 365) in no time! Rating: 0 out of 5 stars0 ratingsExcel Guide for Success Rating: 5 out of 5 stars5/5The Ultimate Guide To Master Excel Features & Formulas. Become A Pro From Scratch in Just 7 Days With Step-By-Step Instructions Rating: 0 out of 5 stars0 ratings50 More Excel Functions: Excel Essentials, #4 Rating: 0 out of 5 stars0 ratingsExcel : The Complete Ultimate Comprehensive Step-By-Step Guide To Learn Excel Programming Rating: 0 out of 5 stars0 ratingsMicrosoft Excel Formulas: Master Microsoft Excel 2016 Formulas in 30 days Rating: 4 out of 5 stars4/5MrExcel LIVe: The 54 Greatest Excel Tips of All Time Rating: 5 out of 5 stars5/550 most powerful Excel Functions and Formulas Rating: 4 out of 5 stars4/5The Ultimate Excel VBA Master: A Complete, Step-by-Step Guide to Becoming Excel VBA Master from Scratch Rating: 0 out of 5 stars0 ratingsMastering VBA for Microsoft Office 365 Rating: 5 out of 5 stars5/5Hidden Gems of Microsoft Excel Rating: 0 out of 5 stars0 ratingsLearn Excel from Mr. Excel: 277 Excel Mysteries Solved Rating: 4 out of 5 stars4/5Data Analysis with Excel: Tips and tricks to kick start your excel skills Rating: 0 out of 5 stars0 ratingsMrExcel 2021: Unmasking Excel Rating: 0 out of 5 stars0 ratings
Applications & Software For You
Canva Tips and Tricks Beyond The Limits Rating: 3 out of 5 stars3/52022 Adobe® Premiere Pro Guide For Filmmakers and YouTubers Rating: 5 out of 5 stars5/5GarageBand For Dummies Rating: 5 out of 5 stars5/5Kodi User Manual: Watch Unlimited Movies & TV shows for free on Your PC, Mac or Android Devices Rating: 0 out of 5 stars0 ratingsLogic Pro X For Dummies Rating: 0 out of 5 stars0 ratings80 Ways to Use ChatGPT in the Classroom Rating: 5 out of 5 stars5/5Canva For Dummies Rating: 5 out of 5 stars5/5Learn to Code. Get a Job. The Ultimate Guide to Learning and Getting Hired as a Developer. Rating: 5 out of 5 stars5/5The Beginner's Guide to Procreate Dreams: How to Create and Animate Your Stories on the iPad Rating: 0 out of 5 stars0 ratingsPhotoshop - Stupid. Simple. Photoshop: A Noobie's Guide to Using Photoshop TODAY Rating: 3 out of 5 stars3/5Blender All-in-One For Dummies Rating: 0 out of 5 stars0 ratingsThe Basics of User Experience Design by Interaction Design Foundation Rating: 4 out of 5 stars4/5Digital Video Production Handbook Rating: 0 out of 5 stars0 ratingsPython Projects for Everyone Rating: 0 out of 5 stars0 ratingsThe Designer’s Guide to Figma: Master Prototyping, Collaboration, Handoff, and Workflow Rating: 3 out of 5 stars3/5Mastering ChatGPT Rating: 0 out of 5 stars0 ratingsMastering Photoshop Masks Rating: 5 out of 5 stars5/5Master In YouTube - How I Run 12+ Different Profitable YouTube Channels and Make 7 Figures From Them ! Rating: 0 out of 5 stars0 ratingsSketchUp For Dummies Rating: 4 out of 5 stars4/5YouTube Channels For Dummies Rating: 3 out of 5 stars3/5How to Publish Low Content Books Rating: 0 out of 5 stars0 ratingsMastering YouTube Automation: The Ultimate Guide to Creating a Successful Faceless Channel Rating: 0 out of 5 stars0 ratingsAnimation for Beginners: Getting Started with Animation Filmmaking Rating: 4 out of 5 stars4/5Wireframing Essentials Rating: 4 out of 5 stars4/5Design for Hackers: Reverse Engineering Beauty Rating: 4 out of 5 stars4/5
Reviews for Learn Excel in 24 Hours
3 ratings0 reviews
Book preview
Learn Excel in 24 Hours - Alex Nordeen
Learn Excel in 24 Hours
By Alex Nordeen
Copyright 2021 - All Rights Reserved – Alex Nordeen
ALL RIGHTS RESERVED. No part of this publication may be reproduced or transmitted in any form whatsoever, electronic, or mechanical, including photocopying, recording, or by any informational storage or retrieval system without express written, dated and signed permission from the author.
Table Of Content
Chapter 1: Introduction
What is Microsoft Excel?
Why should I learn Microsoft Excel?
The difference between excel and CSV file
Running Microsoft Excel
Understanding the Ribbon
Understanding the worksheet (Rows and Columns, Sheets, Workbooks)
Customization Microsoft Excel Environment
Important Excel shortcuts
Chapter 2: Getting Started
Basic Arithmetic
Formatting data
Setting the print area and printing (Print View)
Adding images to spreadsheets
Data validation
Data filters
Group and Ungroup
Chapter 3: Formula & Functions
What is a formula?
What is a function?
Common functions
Numeric functions
String functions
Date Time functions
V Lookup function
Chapter 4: Operators
What is a Logical Function?
What is a condition and why does it matter?
IF function example
Excel Logic functions
Nested IF functions
Chapter 5: Charts
What is a chart?
Types of charts
The importance of charts
Step by step example of creating charts
Conditional Formatting
Chapter 6: Case Study: Personal Finance Application using Excel
Why managing personal finance matters
Major components of a personal finance system
Using Excel to set personal budgets, record income and expenses
Visualizing the data using charts
Chapter 7: Macros
What is a macro?
Macro Basics
Step by step example of recording macros
What is VBA?
Visual Basic for Applications VBA basics
Step by step example of creating a simple EMI calculator
Chapter 8: Connecting Excel to External Data Sources
What is external data source?
MS Access external data source
Web external data source
Text file external data source
SQL Server external data source
Chapter 9: Pivot Tables
What is a pivot table?
Step by step tutorial on creating pivot tables
2-Dimensional pivot tables
Visualizing pivot table data using charts
Chapter 10: Advanced Charts
What is an advanced chart?
The importance of advanced charts
Step by step example of creating advanced charts
Chapter 11: Excel in the cloud: Office 365
Introduction to cloud computing
What is Office 365?
Advantages of Office 365
Disadvantages of Office 365
Chapter 1: Introduction
In this article, we will introduce you to excel and discover its capabilities and how we can take advantage of them to enhance our productivity. We will cover the following topics
What is Microsoft Excel?
Microsoft Excel is a spreadsheet program that is used to record and analyse numerical data. Think of a spreadsheet as a collection of columns and rows that form a table. Alphabetical letters are usually assigned to columns and numbers are usually assigned to rows. The point where a column and a row meet is called a cell. The address of a cell is given by the letter representing the column and the number representing a row. Let's illustrate this using the following image.
Why Should I Learn Microsoft Excel
We all deal with numbers in one way or the other. We all have daily expenses which we pay for from the monthly income that we earn. For one to spend wisely, they will need to know their income vs. expenditure. Microsoft Excel comes in handy when we want to record, analyze and store such numeric data.
Where can I get Microsoft Excel?
There are number of ways in which you can get Microsoft Excel. You can buy it from a hardware computer shop that also sells software. Microsoft Excel is part of the Microsoft Office suite of programs. Alternatively, you can download it from the Microsoft website but you will have to buy the license key.
The difference between excel and CSV file
CSV is the acronym for comma separated values
. It is used to store tabular data where the column names and row values are separated using commas. The following image illustrates this