6/10/ · Excel can do anything from managing your office accounts to managing the data required for managing a whole country, you just need to know how to use it. Here in this article a few really cool Excel tips and tricks are mentioned that can help many users to improve the way in which they have used excel till date. 1. Adding Shortcuts To Top Menu. tricks. MOST POPULAR. VIDEOS GALLERIES. A Fun Waste Of Champagne. Daily Dosage Subscribe Unsubscribe 3 ; Share Video. Tweet Share on Facebook. HTML-code: Copy. Even The Horse Showed It's Sympathy For The Girl Who Just Couldn't Climb Up. Random Stuffs Subscribe Unsubscribe 3/12/ · The Windows Command Prompt tool, and many of its commands, might seem boring or even relatively useless at first glance, but as anyone who has ever used the Command Prompt very often can tell you, there's much to love! These Command Prompt tricks and other Command Prompt hacks will get you excited about many of the mundane-sounding Command Prompt commands like telnet, tree, or .

Tip: You can add a special magic touch to this trick by saying you are going to predict if the person will have good or bad luck. Divide the result by 13 in step 3 to get the result of 7 and predict good luck, or divide the result by 7 in step 3 to get the final number of 13 and predict that they are going to have bad luck.

Just make sure you fold it up enough that nobody can see the number. Tip: This works because repeating the digits in a 4-digit number twice is equal to multiplying the original 4-digit number by 10,, which is divisible by Try it!

Tip: This works because 10, is equal to x Dividing your 8-digit number by gets you an answer that is equal to your original 4-digit number x So, by dividing by your 4-digit number, you'll get 73 as an answer every time.

Tip: To try to keep your secret, you could have the person hit enter or the equals sign and pass you the calculator right away without letting them looking at the result on the screen.

To do a cool calculator trick, start by writing the number 73 on a piece of paper and folding the paper in half. Hand the paper to a volunteer, but don't let them look at what's on it!

Then, ask your volunteer to enter a 4-digit number into a calculator twice so there's an 8-digit number on the screen. When they're finished, ask them to divide the 8-digit number by on the calculator.

Now, ask them to divide that number by the original 4-digit number they entered. If they followed your instructions, the final number on the calculator should be 73, regardless of the number they entered at the beginning.

Tell them to look at the number on the sheet of paper they're holding. They'll be amazed that you predicted the right number! To learn how to read someone's mind using a calculator, keep reading!

Did this summary help you? Yes No. Please help us continue to provide you with our trusted how-to guides and videos for free by whitelisting wikiHow on your ad blocker.

Log in Facebook. No account yet? Create an account. Edit this Article. We use cookies to make wikiHow great. By using our site, you agree to our cookie policy.

Cookie Settings. Learn why people trust wikiHow. You can see what the latter 3 options do from the images accompanying this point.

This being a kind of normal copy and paste operation will only create a fixed transposed version of the original table.

For instance in the images below, you can see the data to be copied has 9 rows and 2 columns, and the area that we select after that has 9 columns and 2 rows.

A new transposed table is thus created, but it is a live copy of the original one, i. As you can see in the images below, when the data in B6 is changed, data in L10 automatically changes.

Entering Sparkline Microcharts Sparkline microcharts are small graphs or charts that you can place in a cell. They were introduced in MS Word and can greatly enhance the view-ability of our excel data.

There you would be asked to enter the destination location of your sparkline chart. Nikhil, Good tips, thanks.

I have a need to find a cool method to list out the differences between two lists of numbers. Basically this s areconciliation between two lists, What is being excluded from the two lists.

I do this manually data sorting both lists and comparing line by line. This is a time consuming method. What method do you suggest? LOG IN. Recover your password.

Your Comment Please enter your comment! Your Name Please enter your name here. Your Email You have entered an incorrect email address!

But Windows does allow you to change these colors to suit yourself and make things a bit more intriguing. If you would like the prompt in your cmd window to say something other than the default, you can use the following trick.

Hit Enter, and you will see the prompt in the cmd window change to your custom text. Fortunately, you can change that too. The method is very simple, and it uses Telnet.

The movie will start playing immediately. Hit enter. You can now check that the folder is indeed hidden inside Windows Explorer and can not be seen by anyone.

Copy Command Output to Clipboard If you have ever tried to copy stuff off the Command Prompt, you must have realized that it is exceedingly difficult, not to mention un-intuitive.

Hit Enter, and you will see that the cmd window shows no output. List all Installed Programs Another cool trick on the Command Prompt involves listing out all of the Windows 10 apps and programs that are installed on your PC.

This is particularly helpful if you need to uninstall a program using the Command Prompt. Hit Enter, and you will see a list of all the programs that are installed on your PC.

You can also use wmic to uninstall programs, directly from the cmd window. This is a really handy trick, especially if the folders you want to access are buried deep inside the filesystem.

This includes stats like factory specifications, full battery capacity, and the current capacity and these are updated with each session.

If you want a step by step direction for generating battery health on Windows 10 , click on the link to read the article.

The method also works on most common file types including documents and PDFs as long as you add the archive file first.

This is a good way of saving your sensitive files from curious friends or co-workers or even prevent them from being misused even in case of a data breach.

You can always right-click on any Command Prompt shortcut and choose Run as administrator but creating a shortcut to do the same thing can be a huge timesaver if you're a frequent Command Prompt power user.

To complete this Command Prompt trick, just create a Command Prompt shortcut on the desktop, enter the shortcut's properties and then select the Run as administrator box located in the Advanced button on the Shortcut tab.

The fact that the function keys actually do something in the Command Prompt is maybe one of the best kept secrets about the tool:.

Did you know that the prompt itself in the Command Prompt is completely customizable thanks to the prompt command?

It is, and when we say customizable, we mean really customizable. You can always execute prompt alone, without options, to return it to its sometimes boring default.

The help command does not provide help for every Command Prompt command. The help switch may not be the coolest Command Prompt trick you've ever heard of, but it's hard to disagree that it's one of the more useful.

Neither the help command nor the help switch offer much in the way of explaining how to interpret the syntax. See How to Read Command Syntax if you need help with that.

These little characters let you redirect the output of a command to a text file , giving you a saved version of whatever data the command produced in the Command Prompt window.

For example, let's say you're about to post a computer problem to an online forum and you want to provide really accurate information about your computer.

An easy way to do that would be to use the systeminfo command with a redirection operator. You could then attach the file to your forum post.

See How to Redirect Command Output to a File for more examples and a moe in-depth explanation of how to use redirection operators. One of the neatest little commands is the tree command.

With tree, you can create a kind of map of the directories on any of your computer's drives. Execute tree from any directory to see the folder structure under that directory.

With so much information created with this command, it's probably a good idea to export the results of tree to a file so you can actually look through it.

Tired of that Command Prompt title bar text? No problem, just use the title command to hack it to say whatever you like. For example, let's say your name is Maria Smith , and you want to express your ownership of the Command Prompt.

Execute this and the Command Prompt's title bar will change immediately:. The change won't stick, so the next time you open Command Prompt the title bar will be back to normal.

The title command is usually used to help give a custom appearance in script files and batch files —not that titling it with your name isn't a good idea!

Coole Tricks extra Coole Tricks erhalten. - Wie kann ich die Google Suchoperatoren in der Praxis nutzen?

Shapshay] published on June, Download. This amount is subject to change until you make payment. Beebom Staff - Apr 26, Shipping Casino Classic cannot be calculated. Sell now - Have one to sell? So in the future, if you face any issue, make sure to run this command on your Windows computer. Share your videos with friends, family, and the world. That's Cool!: 49 Awesome Tricks and Skills to Raise Your Cool Factor, ISBN , ISBN , Like New Used, Free shipping in the US. 1. Perform the French drop coin trick. Hold your left hand out in a cup position as though you were begging for money. Place a coin between your thumb and index finger and make sure it is visible to your audience. Move your right hand over your left hand to appear as though you are going to pick up the coin. In this video, I will teach you 10 incredible coin tricks that anyone can do. These tricks are fast, visual and easy to learn. I will teach you multiple ways. AMAZING TRICKS THAT REVEAL HIDDEN SECRETSHere are some amazing tricks to try at home with your friends and have some fun. If you draw on a glossy surface wit.

Internetauftritt und die dahinterstehende Technik zu Coole Tricks - Sichere dir deine MarTech Insights

Lezen Förderung der Selbstwirksamkeitsüberzeugung durch selbstbestimmtes Lernen: Interventionsstudie zu einem veränderten Unterrichtskonzept an einem Berufskolleg