Computer Lessons

NEW METHOD TO VIEW/ WORK ON WHATSAPP ON YOUR LAPTOP/COMPUTER WhatsApp is a very popular mobile app. Most of us who work whole day on computers and also have to take phone calls at that time when we want to see the data of WhatsApp than Computer is the best way. In this blog I will tell you How to connect your WhatsApp on mobile with the computer.  Earlier we need to connect through a browser. But now there is a dedicated software for this.  First Browser Method Open any browser type web.whatsapp.com on address of browser.  You will get a page open as given below. Now open WhatsApp on your mobile and click on settings button i.e. 3 dots on top right. Here you will get option of WhatsApp Web. Click on it and you will get a screen to scan. Now scan the QR code that you are viewing on your computer screen. As soon as you scan the code your mobile gets connected to your computer. And you can work on WhatsApp on computer now.  Note: Net should be ON in both mobile and comp...

STICKY NOTES IN WINDOWS Windows provide us many useful Software to use, one of them is Sticky Notes . Whenever we have to write something for example a mobile number, an address we search for a paper and pen. But if you have your laptop and desktop open you need not to search for paper and pen simply type Sticky on Start and a Slip type image will come in front of you as given below.  Note: If you have already some notes pre stored on your computer than the list of notes will appear on screen. Here you can type whatever you want to note down.  Know the Buttons + (Ctrl+N)  -   This is used to open a New Sticky Note on the screen. ...  - This provides you to change the color of your note.       It has two more buttons.     Note List (Ctrl + H) - It shows you all the notes which you have taken.     Delete Note (Ctrl + D) - Will delete the note on which you are working. B (Ctrl+B) - Bold -  To bold the selection I (Ct...

  Template in MS-Word A template is a pre made format of different matters such as Resume, Letter, Fax, Newsletter, etc. You can also make your own format which you regularly use and save it as a Template.  For using a template in MS-Word you have to simply click on File Menu - New -  Sample Templates . You will find many more options but those will be downloaded from Microsoft Site.   Sample Templates get installed on your computer when MS-Office is installed.  Choose the template of your choice which you want to use. Double - click on it or simply press enter.  The format will be in front of you. Now edit the format as per your requirement. When you will save the format it will be saved as Word file and its extension will be .doc or .docx Template Example.  How to create a template? Whenever you want a format to be reused just create the format and while saving it choose Word Template in Save as Type to save it in a form of Template.  When you w...

SAVING POWERPOINT  FILE AS VIDEO AND IMAGE We all know how to save a file. We simply have to press Ctrl + S or in File Menu we have to select Save/ Save As to save file.  What if one wants to run his slides as a Video or wants to save them as an Image. The solution is simply save the file and change the type in MS-PowerPoint while saving the file.  FILE TYPES In PowerPoint to save a file as a video file choose File Type as Windows Media Video. When you click on save after selecting the file type it takes time depending on number of slides in your file.  Likewise, when you want to save the slides as an image file than you have to choose the file type as JPG/ PNG/ GIF etc. according to your requirement. Once you select your file type and click on save a dialogue box appears questioning Every Slide/ Current Slide Only/ Cancel . If you want to save every slide as an image than click on Every Slide , to save the current slide as an image click on Current Slide Only . or i...

  MAIL MERGE IN PAGEMAKER We all know about Mail Merge feature in MS-Word. Like Word PageMaker also provides us the facility to Mail Merge which is here known as Data Merge.  Data Merge can be found under Window Menu - Plug-in Palettes - Show Data Merge Palette . When we click on Show Data Merge Palette we get a new Tool Bar on Screen as Data Merge. On Data Merge Tool Bar we have to click on Select Data Source. Where we get a dialogue box which provides option to choose a file with extension CSV or TXT.  For making a CSV file we can easily use excel and feed the data required accordingly.  Now type a letter which has to be commonly send or matter on which data is to be merged. Here I will explain Data Merge with an Example. I had fed the following data in MS-Excel & save it as .CSV in my computer. .CSV which I had chosen shows as .CSV (comma delimited) While entering data always start with the very first cell of the sheet. And first row will always contain the h...

 CONVERTING TEXT TO TABLE BEFORE LEARING CONVERTING TEXT TO TABLE LETS KNOW ABOUT SOME FACTS OF  TABLES IN MS-WORD Table by default have 2 Rows & 5 Columns. Maximum number of Columns that can be inserted is 63 Maximum number of Rows that can be inserted is 32767 Table can be converted to simple text & vice-versa, options are available in 1.    INSERT MENU - TABLE - CONVERT TEXT TO TABLE 2.   W hen we have our cursor on table we get option of CONVERT TABLE TO TEXT under LAYOUT MENU. For converting simple text to table you can use any symbol of your choice to make a difference between data. EXAMPLE NAME,CLASS,SEC RAM,10,A HARI,10,B LILA,10,A Simply select the above data and go to table tab under insert menu and click on convert text to table. You will get a dialogue box where you have to choose the separate text at if you have given any other symbol other than comma (,). In other you have to define that symbol. Else you simply ...

HEADER & FOOTER IN MS-EXCEL MS-Excel also has the options of Header and Footer as there is in MS-Word. Here I would like to explain the Basic elements of Header and Footer in MS-Excel.  When we click on Header and Footer option in Insert Menu, we get a New Menu called Design. First Tab which we get under Header & Footer Design Menu is Header & Footer.   This is used to insert preset options given in the list to a document.  Second Tab - Header & Footer Elements .  Header & Footer opens up in a Page Layout view. It shows Ruler lines also and provides three spaces in Header & Footer area. Left, Center & Right.  It looks like: In these above given area we can fill the elements separately.  The options in elements are as follows: Page Number: This is used to Insert Page Number in the area given in Header of Footer. Number of Pages: This is used to insert the Total Number of Pages in a worksheet. Current Date: This is used to insert C...