Since the tsunami and earthquake in Japan where part of the nuclear plant was destroyed of Fukuyima affecting much of the Japanese country, the world began to analyze carefully whether or not it is convenient to maintain parks nuclear power producers, with the danger that these plants would cause in the face of potential problems in them.While several countries announced…
The Excel tutorial Today is pretty simple, but the truth is that it can save you a lot of time when you have problems with formulas in an excel template.nnSuppose we have a simple list of data like the one we see below:nnnnn Then, we evaluate to do the following part function in Excel:n =SI(F3<G3,F3*G3,F3/G3)…
There are times that we have a text that should be seen as its own name and is like anything, the good thing is that excel has a function that is very simple to use and that really saves a lot of time, suppose we have the following text:nnnnnnY we need the text to be…
Today I bring you some key combinations that when it comes to working are quite effective, as they save you a lot of time, we start with this simple list of quick phones for excelnnnn nMoverse a la última celda de las celdas actuales: CTRL + FLECHA ABAJOnMoverse a la primera celda de las celdas…
There are times when we have a lot of data with spaces interspersed in excel where it can become quite complicated to remove all spaces by hand, so today we will see an excellent method for removing these spaces quickly and easily, suppose we have the following values:nnnnSelect all values, including empty spaces:nnnnnnY press the…
Learn how to create macros in Excel from the most basic to the most advanced with our new tutorial. Discover step by step how to automate tasks in your spreadsheet and optimize your time efficiently, click here and start now!
The functions in Excel simplify our existence a lot, since they save us a lot of work, we start:nThe function TIME:nWe can get only the time of a cell, for this we will use the function TIME() as shown below:nnNow as you’ll be imagining there are also functions minute() and second(), which are used in…
As many will already know HEC-RAS serves us in the case where we need to study a certain stretch of a river or a canal and we want to know how far the water would go if the flow reaches a certain value, in this way we will have the security that the main channel…
Another of the tasks that although they are quite simple, can give us one of the other headaches, this time it is about place the titles corresponding to a graph on excel. To achieve this we simply make a chart any, like the one we have below:nnnnnnnnTo be able to place the texts corresponding to…
Tired of fighting with units in Excel? Find out how to easily add m3/s and other units to your cells without complications and improve your productivity with this simple trick.