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

Text Decoration, Change Text Color, Text Alignment, Change Text Case

This section will show you how to decorate your text in Microsoft Word Document. We will explore on making bold, italic, underline text. Making text bold A bold text appears with heavy weight and dark ink and we use bold text to give more emphasis on the sentence. How to make Bold Step 1 Select the text that you want to change to a bold font. Step 2 Click Font Bold [ B ] button in the Home tab Font...

Read More...

Understanding and Undo Changes with Microsoft Word Document

Microsoft word provides two important features called Undo, which is used to undo the previous action and second one is Repeat or Redo, which is used to repeat the previous action. Undo You can quickly reverse most commands you execute by using Undo. If you then change your mind again, and want to reapply a command, you can use Redo. For example, If you mistakenly delete text, you can use the Undo feature...

Read More...

Move, Copy, Cut & Paste, Find and Replace Text In Word Document

In this section, we will explore Microsoft Word Features on moving, copying, cutting and paste text in the word document file. Moving Text Sometime it is required to move a text from one location to another location in your document. You can move text from one location in a document to another by using drag-and-drop technique with the help of mouse. This tutorial will teach you how to use drag and drop technique to move a text. How...

Read More...

Entering, Select, Delete Text in Word Document

In this section, we will explore Microsoft Word Features on entering, select, and delete text in the word document file.In Microsoft Word, you can easily entering text or add text by putting your cursor on your document area and type the text that your want to add with your keyboard.Entering TextDocument area is the area where you type your text, select your text and delete text. So just keep your mouse cursor at the text insertion point...

Read More...

Microsoft Word Document Basic Features

In this tutorial, I will provide you the brief description about Basic feature of Microsoft Word Document. Microsoft Word has many feature s and in this section, it will covers typing, using the Backspace key, using the Delete key, inserting text, bolding, underlining, and italicizing. Type, Backspace, and Delete In Microsoft Word, you create documents by typing with keyboard. For example, if you want to create a document, you open Microsoft Word and then begin typing. You do not have to do anything when your text reaches...

Read More...

Introduction to Microsoft Word and Creating the first Word Document File

Microsoft Word is one of the tools in the Microsoft Office Suite; it is used to create document, report, eBook, etc. It has many features to work with text. It also provided the feature to the users to work behind the existing features and tools and can enhance its capabilities. To implement functionality beyond a regular Word, Microsoft Visual Basic programming environment is provided with Microsoft Office Word. This programming language...

Read More...

Getting Start with Microsoft word 2007

In this tutorial we will introduce the basic feature of Microsoft Office Word, one of the most popular of Suite in Microsoft Office Package. What is Ms. Word? It is a word processor application which is used for entering text to create the document and store this text in a file called Word Document with extension (.doc and .docx) Microsoft Office Word 2010 allows you to create and edit personal and business documents, such as letters, reports, invoices, emails and books Why should MS Word? MS Word is used for many...

Read More...

How to switch from main view to Endnote view

As I mentioned in the previous article, to make vba code work with endnote or footnote we need to switch the view to endnote or footnote view. In this article I show the code for switching view of word document. How to switch the view to endnote view First I use the function EndnotesExist to check whether there is endnote exists in the word document and then use ActiveWindow.ActivePane.View.Type to switch the view ≫ Detect Endnote FunctionEndnotesExist() As Boolean     DimStoryRange As Range    ...

Read More...