Introduction to Excel VBA

In this topic we will understand the basics in Excel VBA. What can we do with Excel VBA? How it helps us with MS Excel.

.

Introduction to Excel VBA

EXCEL VBA is the acronym for Visual Basicfor Applications. It is an integration of the Microsoft’s event-driven programming language Visual Basic with Microsoft Office Applications such as Microsoft Excel. Excel VBA is a programming language for MS Excel Application. It allows you to automate the task which you are doing manually and repeatedly. Most of the times, we do the same kind of tasks daily in our daily work, you can automate it using VBA.

We can use Excel VBA for:

§  automating the repeated tasks

§  automating hourly, daily,weekly,monthly or yearly generated reports

§  preparing rich and interactive Excel Dashboards

§  connecting to various database to get the data and prepare the reports

§  building  the automated tools

§  interacting with other applications, including MS Office Tools using API

§  doing many more things using VBA based on your data and requirement

FOR EXAMPLE

» We fetch some data from different sources like database by using sql language and paste it in a worksheet and doing some manipulations and then we will format it and generate Automated Report

» We may extract some data from other file system like csv etc… to an Excel sheet, and then we will clean the data and create some reports and send through email..

» Many of us do the similar kind of work daily; there may be some change in the data but not the structure of the data, using vba to process steps which execute to deliver the output.

VBA HELPS…

Read More...

Indentation Paragraph, Set Line Spacing, Set Tabs

When you type information into Microsoft Word, each time you press the Enter key Word creates a new paragraph. As you know margin settings determine the blank space that appears on each side of a paragraph. For example, you can indent the first line of a paragraph, you can set the amount of space that separates paragraphs, and you can align a paragraph left, right, center, or flush with both margins. Styles are a set of formats you can quickly apply to a paragraph. For example, by applying a style, you can set the font, set the font size, and align a paragraph all at once. In this lesson, you will learn about the various formats you can apply to a paragraph and about styles.

Left Indentation

Left indentation means to move the left edge of the paragraph inward towards the center of the paragraph.

Read More...

Copying Moving and Pasting Data in Excel

When we are working with the data most of the time we may required to copy/move the data from one location (range) to another location. This tutorials will explains you Copying Moving and Pasting Data in Excel.

Moving a Range in Excel

We can Move the data from one range to another range by using either short cuts or in-built commands.
If you want to Move the data from one range another location:

First we need to Select the existing Range => Cut it => Choose a New Range => Paste it

Select Range to Move:

Cut it: Press Ctrl+ X or right click and select Cut command.

Choose a New Loaction:
 

Read More...

Formatting Data and Formatting Cells in Excel

Microsoft Excel provides us the tools to make rich formats, we can format the numbers, fonts, font color, background color, alignments and many more things we can do in Excel. This tutorial section will help you to learn Formatting Data and Formatting Cells in Excel.

We have many tools in Excel to work with Formatting

Home Tab

If you observe the Home Tab, you can see many commands to work with formats.

Font

We can use these commands to format the Fonts Styles like Bold, Underline, Italic, Font size, Background Color, Font Color etc. You can click on the icon at bottom-right corner to see the more Font Settings.

Read More...

Entering Data and Moving in Excel Worksheet

Entering Data and Moving in Excel Worksheet is very easy and you find that it is the time saver for data entry. You can enter any numbers, text, dates in Excel and you can format as per your requirement.

Entering Data

In order in enter data into your worksheet, you need to activate the cell by locate your mouse point to any cell When your cell is activated, it become Active Cell. Active Cell is the place where we enter the data. When we open a new Excel Workbook, by default it activates A1 (top-left corner of a Worksheet) position of a Worksheet and we can start entering the data.

We can see the cell A1 is activate and you can see the Address of the active Cell in the Address bar (rounded with red circle), you can also observe the sample text in A1.

We can also activate a Cell and enter the data in Formula bar.

Read More...

Getting Started with Microsoft Excel

In this section I will introduce the basic features of Microsoft Excel, one of the tools in the MS Office Package suite.

What is Excel?

Microsoft Excel is a very popular spreadsheet application. It has effectively become the standard and these days the word 'Excel' is synonymous with 'spreadsheet'. Excel is a spreadsheet application used to enter the data (text, numbers, etc…) to perform calculations, analysis and store it in a excel file. There are many built-in functions and formulas allow you to perform calculations and you can create attractive, readable presentations and rich visualized dashboards including charts, table,etc…

Why Should I Learn MS Excel?

MS Excel is used with many purpose because Excel:

§  has ability to Store Data and is easy to use and flexible to do the  any changes

§  can makes calculations of complex formulas

§  can works great as a basic reporting tool, you can Dashboards and Rich Visualized Templates

§  can interact with Other Applications and Databases

§  is widely using as Data Mining Tool to Process the data, Reporting and Presentations

§  has programming Capability, you can code and build the tools to automate your tasks known as “Macro”.

Starting Excel

You can start Excel by
1. Double Click on the Excel Icon on your Desktop
Or
2. Go To Run and type excel to Start Excel Application
Or
3. Click on Start Button => Select All Programs => Select Microsoft Office => Click On Excel to Start Excel Application

Exploring the Excel Interface

When you Start Excel Application, it will Open an Excel Workbook, It is the main file having collection of Worksheets. Each Worksheet look like table with Rows and Columns, and the smaller entity in the Worksheet is called a Cell where we can enter the data.

At the top of the Worksheet you can find Menu Bar also called Ribbon, collection of built-in functions and utilities are available to execute our tasks.

Entering and Editing Data

We can enter text, numbers,dates in a Cell and we can modify and update the existing data.

Formulas and Functions

There are number of formulas and functions available in Excel to deal with your data to get the required results.

Excel Built-in Tools

There are number of tools available in Excel, which help you to play with your data to achieve required results.

Read More...

Introduction to Microsoft Excel and Creating First Excel File

Microsoft Excel is one of the tools in the Microsoft Office Package suite; it is used to create spreadsheets. It has many in-built functions and tools to work with data and create different type of reports and dashboards. It also provided the feature to the users to work behind the existing tools and can enhance its capabilities. To implement functionality beyond a regular spreadsheet, Microsoft Visual Basic programming environment is provided with Microsoft Office Excel. This programming language is called as Visual Basic for Application (VBA).

In This Section:

§  What is Excel?

§  Why is it used?

§  Creating your first excel workbook.

What is Excel?

As mentioned above, Microsoft Excel is one of the tools in the Microsoft Office Package. It is a spreadsheet application, it have powerful tools to deal with the data and create different kinds of reports, dashboards, and tools.

Why is it used?

Almost every organization uses Excel for their day to day activities from requirement gathering to deliver and present the output using excel.

§  Preparing the different kinds of templates, Quality Checking Template, Process Flow Templates, Project ManagementTemplates, Cost Estimation Templates, etc…

Read More...