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...

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...

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...

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...

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....

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...

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...

Read More...