SALIENT THINGS YOU SHOULD KNOW ABOUT EXCEL

CREATING LINKS: A workbook can be linked to permit consolidation of values from supporting workbooks to a master workbook. The source workbook contains the original data. The dependent ... Continue Reading →

Excel – FUNCTIONS

WHAT ARE FUNCTION? A function is a built-in formula that takes a series of value, uses it to perform an operation, and return the result of the operation. It can be used as a part of ... Continue Reading →

Excel – BASIC OF FORMATTING AND PRINTING

FORMATTING MANUALLY In order to make our Worksheet look good, we have to use some formatting techniques. Formatting refers to controlling the appearance of the Worksheet. Excel allows ... Continue Reading →

Excel – BASIC EDITING SKILLS

RETRIEVING AN EXISTING WORKSHEET A file, which has been saved, can be retrieved for re-use. Retrieving a file is possible from the file menu using the open option. On selecting he open ... Continue Reading →

MS-EXCEL

ESSENTIALS OF A SPREADSHEETS WHAT IS A SPREADSHEETS? The terms spreadsheet was coined from an old financial accounting practices. Huge calculations, including those which cloud have ... Continue Reading →

MS – Word, Shortcut keys

MS – Word – Shortcut keys Shortcut Key Description Shortcut Key Description Ctrl + A Select All Text Ctrl + Shift + A All Caps Ctrl + B Apply bold Ctrl + Shift + B Bold Ctrl ... Continue Reading →

MS – Word, MAIL MERGE

WHAT IS MAIL MERGE ? In many kinds of business documents, we find that the same matter is sent, possibly with some minor modifications, to different recipients. A classic example is ... Continue Reading →

MS – Word PAGE SETUP

PAGE SETUP We can control the appearance of a page using the page setup command of the file menu. It allows us to specify the size of a page, the margins to be used and the paper source ... Continue Reading →

MS – Word

INTRODUCTION TO WORD PROCESSING & WORD THE WORD PROCESSOR Since the time immemorial, the man has felt the need to keep the records, his exploits, victories, thoughts and expressions ... Continue Reading →

MS – Windows 98

INTRODUCTION TO WINDOWS You have a very powerful assistant at your side, in the form of your computer. But it has to be instructed in detail for every task you want it to perform. This ... Continue Reading →