Cognitive Computer Tricks

💻 These Cognitive  Computer Tricks make your work easier and faster. These  tricks must be  known to a computer science student .Of course that's very nice if  these tricks are known to everyone . But , here's the reason why I have specifically mentioned computer science students, that's their inevitable bond😝 with laptop/desktop .So, Readers have these tricks and apply them while working consequently you will learn them, broadening  your knowledge bank.✌

💨 Excel Tricks

  In excel, pressing F4 repeats the last command. For example if you select a cell and highlight it yellow, you can then highlight any other selected cell(s) yellow by pressing F4. Really handy trick that I use almost daily.

Contrary to popular belief, holding alt and pressing F4 isn't always a good idea.

Another use of F4 is to automatically insert $ into formula. Select the cell that you want to copy, highlight the portion of the formula that you want to remain constant, and hit F4. It's a lot nicer than manually entering them in if you have more than one or two that you want to add.

Some other very handy Excel keys:

• F2 to edit a cell (seems like no big deal but I use it all the time since I know of this)
• Shift + Space to select whole lines
• Ctrl + Space to select whole column
• Ctrl + Plus to insert cells
• Ctrl + Minus to delete cells
• Ctrl + 1 to edit cell format

💨 Snipping Tool

 Not enough people know about the snipping tool in Win 7! Presumably it's in 8/10 as well.

I see people doing a print screen and either dumping the entire thing into an email or pasting it into paint way way too often. Start -> Snipping Tool, all your screencap needs taken care of forever.

CMD/Shift/4 does the same thing for you OSX guys.

💨 A shortcut to any website

Whatever you type into the URL bar can be surrounded by www. & .com by pressing control + enter.

💨 An easy way to browse photos on a subreddit hands-free.

When viewing picture based subreddits, add a “p” into the url like so: redditP to get a picture slideshow of the posts on that subreddit. This is particularly useful when you want to browse a picture based subreddit ahemhands-free.

💨 A shortcut to downloading music.

Type -inurl:(htm|html|php) intitle:”index of” +”last modified” +”parent directory” +description +size +(wma|mp3) “weezer” into a google search bar.

And for other searches, replace “weezer” with whatever you’re looking for. It finds music downloads on public ftp and http sites.

💨 How to make your cursor move by words.

Most of the good ones are gone, but, holding control makes your cursor move by full words, instead of by characters.

So CTRL + backspace will delete the entire previous word. CTRL + arrow keys will jump to the start of the previous word.

💨 How to access video websites that are restricted in your country

 Youtube video or website not available in your country? Tryhttps://hola.org/ lets you proxy from a different country really easily.