[Guest Post] MS Excel: How to find the corresponding value for a given entry

Using the VLOOKUP function in Excel
Català - Castellano - Deutsch
Another Guest post by my brother about Excel. Imagine you have this list, where each letter has a value

Then you have a given list such as, and you want to have the value for each letter:

You just have to write the following: =Vlookup(value you want to find; matrix where the value has to be found; number of column where the value is;”false” if you want to find the exact value) In our example, this would mean you write in Sheet 2, Cell B2 the following: =vlookup(A2;Sheet1!A:B;2;FALSE) And the result would be:

Show me more...

[Guest Post] Some useful shortcuts for Excel

Some useful shortcuts for Excel. A guest post by my brother Jordi.
Català - Castellano - Deutsch
This is a guest post by my brother Jordi. A list of useful shortcuts for MS Excel that will make your workflow much faster. Here they come:

• Ctrl+”+”: Add a new column or row. Click on the column/row where you want to add and press “Ctrl” and at the same time the “+”.
• Ctrl+”-“: Delete a new column or row. Select the column/row want to delete and press “Ctrl” and at the same time the “-”.
• F2: Modify a cell. When you are in a cell, press F2 and you will be able to modify directly the cell without the need to double-click it.
• F4: Repeat an action: When you want to repeat and action you just performed, press F4 and the last action you made will be repeated.
• F9: recalculate the values. Sometimes the excel sheet are put into manual calculation, if you want the sheet to calculate and show you the values, pres F9
• Ctrl + “up arrow”/“down arrow”: Move to the first/last line with values: Press Ctrl + “up arrow”/“down arrow”

Show me more...