Computer Lessons

Mail Merge in Word YOUTUBE LINK:  https://youtu.be/YDFJ9Kce0e0 In simple words we can describe Mail Merge as merging two documents in which one consists of common letter to be sent to all those are mentioned in the second document.  So as described above the first documents contains the list in a table form and in other document there is the common letter to be sent. Steps of Mail Merge. 1. Type the list in table form and save the file and close.  2. Type the letter/ design envelope leaving spaces where you want to fill the columns made in the file containing table. 3. Go to Mailings Menu. 4. Click on Select Recipients. 5. Click on use existing list, select your file. 6. Place your columns at appropriate place using insert merge field. 7. Once you have done it all click on preview result to see the merged field. 8. Click on Finish and Merge to      a) Edit individual documents...     b) Print documents...     c) Send E-mail messages.. (for this your outlook should be configured) Exampl

CALCULATOR IN WINDOWS 10 Almost all of us know that there is a Calculator Software which comes with Windows. But most of us have not tried it other features. As earlier it was limited to Standard and Scientific Calculator, but now it is not limited to this only.  Standard Calculator looks like:  Here you see three parallel lines before Standard. When we press on these a list of calculators comes by clicking on which you can convert your calculator to the given option. All the options can be used easily but one should know about how to use and what's the use. The Calculator types available are: Standard Scientific Programmer Date Calculation Currency Volume Length Weight and Mass Temperature Energy Area Speed Time Power Data Pressure Angle If in case you want to use Currency than your Internet should be connected so that calculator can pick the Current Currency Conversion Rate. As currency rates change daily. Hope the information in this blog is useful. Please do leave a comment/que

Shortcut Keys in Tally   Character in a Word has been kept bold which can be used as shortcut key for doing that particular work. As in C reate Company C has been kept bold . When you press C/c you will get the screen of Create Company opened up.   Another thing that has been done is that there is an underline beneath the Character. A single underline means that, the partiular character is to be pressed with Alt key . As if we want to Shut Company we can see that it is written there as F1 : Shut Company. So to Shut the Company one has to Press Alt+F1 .   There are also some Characters with double underline beneath them. At the time of doing Voucher Entry of Purchase we can see a double underline beneath V which is written as V : As Voucher , in this case one has to press the character V with Ctrl Key.   The shortcut keys are assigned with different work at different screens as Alt + F1 is used to Shut Company when we are at Gateway of Tally, but the same is used to

DEFAULT SETTINGS IN PAGEMAKER In PageMaker whatever options in menu are not dim can be changed and when they are modified, it results in change in Default Setting of that particular option in PageMaker.  For example: As we can see in above image Document Setup is not dim where as Print option is dim. We can change the settings of Document Setup and whatever changes we will make to it, these changes will become default settings, that is when next time we select that option the changes done will appear. Now in Document Setup Default Page Size is set to Letter.  Whenever we click on New the page size appears as Letter. But if we want to change it to A4 or any other size we have to simply select Document Setup without opening any file (as you see in above image no file is open) & than change is to desired size.  Likewise if we want to set Column Guides we can go in Layout Menu and do the changes in it. After the change whenever we will create a new file it will come with columns in it.

Tally - Company Info.  (Select, Backup & Restore) Select Company - When we open Tally, if our company already exist than we have to select the company. For this we have to Press S or click on Select Company. Here we get window given below. Where we get a list of companies in our computer in the default directory/ path. If we have stored our company in some other drive we can give it in the path by pressing Shift + Tab (this is used to move backward within options). If we have more than one company with same name than we have to remember the number of our company which is given in front of it's name.  Backup: Backing up is saving your company in some other drive, which can be taken to other computer or can be kept at some other drive in same computer. You should know the exact location of the data which you want to take the backup of. For this when we click on backup we get  Source is the place from where we have to pick our company, here we can give path where our file is store

Tally - Company Creation Company Creation is very easy task in Tally.  Here I will try to explain all the points given in above image. Directory: Here we write the name of the drive and the folder where we want to save our work done for this company in Tally.  Name & Mailing Name: The name entered here will get displayed when we Select Company.  In above given image we have given Name - Manik Chand & Mailing Name as Manik Chand & Sons .  When we will select company only Manik Chand will get displayed. But when we will Print Bill than Manik Chand & Sons will appear as given in image below.  Address, Country, State, Pincode: Here we provide Address, Country, State, Pincode details of the company which we are creating. All appears at the time of printing. These are not necessary to be entered except for State & Country when you are simply using Tally to learn. Phone No,, Mobile No., Fax No., E-mail & Website: These are also entered accordingly, but are not requir

 Setting Default Application for Opening a File in Windows In Windows to change the Setting of Default Application for Opening a File is very easy. First of all we should know what is Default Application.   Default Application is the application which opens your file when you double click / press enter on it. There can be other applications also to open up your file. Here I will explain you how to change the settings so that the file opens with that particular application only whenever you open that file type.  How to see what is our default application for a file type? For this we have to see properties of the file. Press Alt + Enter key after selecting file to see the Properties of a file. It appears as given below. Under Type of File you can see its type is .jpg Opens with reflects the name of the application by which it will open. As in the above case it is written ACDSee Photo Manager.  How to Change the Default Application? By pressing on Change written after the Application name

MS-EXCEL  BASIC OPERATORS  (<, >, =, <=, >=, <>) YouTube link: https://youtu.be/s4qmKemxTMw When we use IF Function in Excel than these operators are required to check condition. This has been described in my channel link given above. Here I am going to explain the same in writing.  Using Less Than symbol (<) When we use less than symbol in a condition that means the value should be Less than the value mentioned. If given value is equal to or greater to the value it will return false.  For eg. IF(A1<500,"TRUE","FALSE") Using Greater Than symbol (>) When we use less than symbol in a condition that means the value should be Greater than the value mentioned. If given value is equal to or less to the value it will return false.  For eg. IF(A1>500,"TRUE","FALSE") Using Equal To symbol (=) When we use less than symbol in a condition that means the value should be  Equal to the value  mentioned. If given value is greater o