Skip to main content

BASIC EXCEL FORMULAS

 MS OFFICE

MS Office introduced in the year 1987 has enhanced the speed of work and enriched the work life of an employee. With the introduction of this package by Microsoft all of a sudden dramatic changes occurred in the work system followed in the periods prior to 1987.  Earlier people were using WordStar and QuickPro, FoxPro, which has been replaced with latest and ultra modern package of Microsoft Office applications.  All of a sudden there occurred a dramatic change in the work style with the introduction of IBM Computers and other Companies also upgraded their Computer to run Windows and MS Office.  The easy and quick actions of these applications changed the technology and brought a revolution in the office work of each employee.

MS EXCEL

MS Excel is one of the packages application introduced by Microsoft.  Microsoft applications started spreading like anything its development was very quick and aspiring.  Even though MS Excel has been very helpful to people to do calculations but other applications like Power Point and MS Word has also brought considerable change in the working conditions of most of the Companies.  This change of system has helped in upgrading the status of Companies to grow.

  • What are the usage of MS Excel in routine work :-
  • Speed of Work has remarkably increased due to its introduction in Companies.
  • A Separate System Department has been evolved in Companies to look after the Computer Systems.
  • Due to work speed tremendous change in the Economical / Logical and Other Business Development took place.
  • Communication Strategy has been changed with the introduction of Video Conferencing.
  • Old Typewriters / Electronic Type Writers were replaced with New Ultra Modern Computers with Windows Installed and MS Office as a Package.
  • Drastic development of Companies and their status of work is upgraded.
  • Presentation methodology has been changed.
  • Calculation of difficult and large data has been submerged into the Excel Worksheets.
  • Ultra Modern Chart System of Excel Applications helped in drawing the graphs and relevant data pertaining to business growth.
  • Salary Sheets of employees were prepared through Papers has been replaced with Excel Payment Sheets.
  • Calculation of Allowances of employees were doing by hand has been taken to Excel.

IMPORTANT FORMULAS IN EXCEL

SUM OF VALUES :  

How to find out Sum of  Given Values in Excel?

In excel to find out Sum of Values-
Open Excel Work Book
In Sheet 1 Add Row Data of Products
Write Formula on the bottom of values '=Sum(B2:B6)' , '=Sum(D2:D6)'  
Press Enter

MULTIPLICATION OF VALUES :  

Consider we have given Product Quantity and Rate, then How to find out Total Value of the Given Products' Quantities:

Open Excel Work Book
In Sheet 1 Add Row Data of Products
Write Product Quantity and Product Rate then Go to Total Amount Column and write down the Formula  '=(B2*C2)' and Click Enter then the Total Amount will appear on the last column.  You can drag it down to get all Total Values in the stock and enter formula on the bottom Cell 'D7' ='Sum(D2:D6)'. 









MS WORD

Microsoft's Word application has been renowned for its easy usage.  Microsoft's word application brought revolution in typing jobs. Various typing jobs like preparing resumes, important letters, offers to candidates for jobs, purchase orders all these regular office work converted into MS Word's domain within a few years of its introduction in the year 1987.  Like Excel MS Word also brought static change in the work culture and every where the work becomes so fast and its introduction given way for better opportunities those idle candidates who does not know anything about computer could reach out to computers and word application made it easy to handle any type of communications.  Some of the benefits people enjoyed after introduction of Word application are -

Typewriters have been replaced with Modern day computers with latest technologies having installed Windows and MS Office.

There occurred a practice of making drafts.

The draft print out were corrected properly inside the computer itself without going for correction fluid.

In the old typewriter period correction fluids were abundantly used by every one, who normally commits mistake by those who are doing work without proper thinking.

Modern day software introduced many other fruitful out comes like inserting a Photo/image on the phase of the Resumes through the system itself, earlier the pasting work of photos were done with glue stick/gum tube.

Later on when different language packages were introduced poets / writers were turned to write their poems and stories in Computers.

Paper wastage reduced to great extend with introduction of MS Word, where people were making mistakes in the typewriter while typing letters etc. were torn abundantly and then type in another paper again if there is a mistake again you type it finalize.  But after introduction of word the work reduced drastically and the correction started from the Computer itself.

Even though WordStar was there previously but it was not suitable for easy corrections and the printing was not good after introduction of MS Word, many new fonts and printing different styles with borders etc. were introduced.

If the number of pages to be typed is too long then it was not easy to type and edit the long pages after introduction of MS Word this has been very smooth, you can type any number of pages and print it easily.

MS Word Introduction:

MS Word is an useful application for making classic documents with ease to handle the documentation scenario of the public at large.  The number of users of MS Word is still innumerable even though some other Software Companies have also introduced such applications even though the quality of MS Word cannot be compared with any other applications on the same grid.

What are the main features of MS Word Application :-

MS Word Application normally used to prepare notes, letters, offers, Purchase Orders, Contract related documents and do all other business related communications. This has paper settings for all types of documents, the users can opt their choice out of the different format of papers for eg. A4, Custom Size, A5, A3 are some of these type of Paper options

From the date of introduction till the current period the application has integrated and expanded its wings to newer areas and adopted basic features and other relevant techniques suiting to the current day world, which also provides the users various types of facilities and easy integration helped in multiplying the use of MS Word.


Comments

Popular posts from this blog

How to Use Mail Merge in Microsoft Word

How to Use Mail Merge in Microsoft Word Use mail merge to create and print too many letters and other documents to different persons. Mail merge is used to create a set of documents, such as a form letter(interview call/offer letters) that is sent to many candidates.  Each letter has unique information.  For example, in letters to candidates, each letter can be personalized to address each candidate by name.  The mail merge process requires the following steps: Set up the main document.  The main document contains contents which will be used in each document. Connect the document to a data source.  A data source is a file that contains the information to be merged into a document. Normally we can use excel file contains the names and addresses of the recipients of a letter.  Microsoft Office Word generates a copy of the main document for each item, or record, in your data file.  If your data file is a mailing list, these item...

APPRENTICE REGISTRATION

Those who have passed the technical education / non technical education can do apprenticeship from any one of the Industries situated in India.  In order to register in the Apprenticeship Portal you should possess qualification in technical / non technical fields. First of all you have to visit the website WWW.APPRENTICESHIP.GOV.IN  and click on the topic Apprentice Registration on the bottom of the Home Page of above Website. Please fill up all the details like Name, Father's Name, Age, Aadhar No., Mobile No., Qualification, Trade, University and the first preference i.e. if anybody having BSC Chemistry qualification can choose Chemical and for Sub-Heading Designated Trades Attendant Operator Chemical is to be selected for BSC Chemistry Qualification.  Attach required documents, photo and mark sheets. Upon successfully entering the details and captcha text you can click the submit button, which will guide you to another link and the link will tell you...

MAKE MONEY ONLINE

HOW TO MAKE MONEY ONLINE IN YOUR FREE TIME Making money is not so easy, for that you have to search so many ways and there should be some source to make money, else you should know something about making money.  You need good tactics to make people come in your way but I think all these are ways gone and is not applicable in today's world.  Today people are making money online and offline and there are too many sources to give you a considerable amount every month without going in front of any body and also particularly if you possess some specific skills. In todays' world a person with one PC or One Smart Phone can create wonders and he can work day and night to complete the task, because simply registering on a platform and sitting idle will not make you eligible to get money freely, such platforms are also available but I strongly recommend that you should put your hard efforts to make an entry into this career so that you will be able to realize what are the difficulties i...