Yogendra Pratap Mishra

               Apply Cell Format with Format Painter Before I started to use format painter for applying... ...cell formatting, I was using paste special with the shortcut key. Here’s how to do this: Select the cell or a range from where you want to copy cell formatting. Go to ➜ the Home Tab ➜ Clipboard. Now, make a double click on the “Format Painter” button. As soon as you do this, your cursor will convert into a paintbrush. Now, you can apply that formatting anywhere in your worksheet, in another worksheet or, even in another workbook.

              Top 10 computer mouse tips everyone should know Most computer users don't take full advantage of the computer Mouse. Below are computer mouse tips and secrets that help you get the full potential of your computer mouse and increase your overall productivity while on the computer. Shift key and mouse click Many  text editors  and programs allow you to  highlight  all or portions of text using the  Shift key and the mouse. For example,  click  at the beginning of the text in the below text box. Hold down the Shift key, scroll to the bottom, and click at the end of the text to highlight all of the text. Bonus Tip:  Holding down the  Alt key  while dragging and highlighting text in a  text editor  allows you to selectively highlight text. Highlighting text this way is useful if the paragraph or other text is in a column. Note: This tip does not work in the above b...

          4 Speaking Rules you need to know! 1. Don't study grammar too much This rule might sound strange to many ESL students, but it is one of the most important rules. If you want to pass examinations, then study grammar. However, if you want to become fluent in English, then you should try to learn English without studying the grammar. Studying grammar will only slow you down and confuse you. You will think about the rules when creating sentences instead of naturally saying a sentence like a native. Remember that only a small fraction of English speakers know more than 20% of all the grammar rules. Many ESL students know more grammar than native speakers. I can confidently say this with experience. I am a native English speaker, majored in English Literature, and have been teaching English for more than 10 years. However, many of my students know more details about English grammar than I do. I can easily look up the definition and apply...

          English Speaking Basics - Section I English Speaking Basics is for English speaking beginners who need help to understand the basics of speaking English.  We will use very simple phrases and expressions to help you with your English speaking. 'I'm' is an abbreviation for the word 'I AM.' It is used in combination with other words to tell someone about yourself or to describe something you are doing. Here are some examples: "I'm so tired." "I'm confused." "I'm happy." "I'm twenty three years old." "I'm hungry." "I'm nervous." "I'm excited." "I'm leaving work." "I'm thirsty." "I'm from Seattle." You can also add descriptive words with 'I'm' such as: "I'm extremely tired." "I'm very happy." "I'm t...

Top YouTube tips and tricks According to Alexa, YouTube is the third most visited page on the Internet which means you have probably visited the page in the past. These tips and tricks help make your experience more enjoyable and if possible, productive. YouTube keyboard shortcuts YouTube has several keyboard shortcuts that can be used while watching YouTube. Keyboard shortcuts like pressing the spacebar to play and pause or using the arrow keys to fast forward and rewind can make a big difference while on YouTube. Share a video at any point Not everyone wants to watch a full video, link to the exact location you found most entertaining instead of making your friends or family watch the full video. To do this, get to the location you want and pause the video. Once paused right-click the video and select  Get video URL at current time  and then copy the link created. Alternatively, you can manually add the time by adding "#t=XXmXXs" at the end of...