Posts

Showing posts from 2015

Managing Disk Partitions

Image
Today I want to write about disk partition, probably you have seen that a computer has one or more drives (C:, D: and more) but it doesn't mean that there is actually such amount of physical drives, therefore they are called partitions. I consider that it's a best practice to always have an exclusive partition for your operating system and one o more for all you data, because if you have a problem that will require your system to be reinstalled then the reinstallation is not going to delete your data just the operating system. What do I have to do if I save my data and my operating system in one partition? Well, you must create a partition and for that I'm going to show you Gparted , this is a free tool and I recommend you to use the live version because it will be better to have it in a CD just in case. With the CD in your computer just turn on it and Grub will show you a screen like this, select the first option (the other ones are advanced).    Here select...

Recalling Outlook Message Once You Sent It

Image
Sometimes when you send a mail through Outlook and realizes that you want that mail back because you didn't mean to send it yet, there's an option. To recall a message you have to open the sent mail and go to 'Actions', then you have hit 'Recall This Message...'.   Once you use this option it's going to show a popup that will allow you to delete or replace the message. So, you have an ocassion to make things as you want.

Rotating Computer Screen

Image
Few weeks ago I went to a cellphone store and this store had a computer where clients could look for information. However, the screen looked like this: So it was useless for clients, fortunately there's a way to solve this easily, just press at the same time keys 'Ctrl' + 'Alt' and the arrow indicating where the top of the screen is going to be.   Now you can rotate your screen anytime you want.

Getting a Value Giving Column and Row on Excel

Image
Many times it's interesting to see how business requires you to use functions from Excel that you don't even know they exist. In this post I have the following mission: I want to know the value of a cell when I write the column and row, consider that column and row can have any identification.   To get the value from a table you must use 2 functions: Match and Index, Match function gives you the position of a given value in a range, therefore it's necessary to first get the position of the column and the row. Once you have both positions use them into Index function that is going to give you the value located in the position you put related to a given matrix.

Turn Horizontal Visio Swimlanes into Vertical Ones

Image
In one ocassion, a friend at work called me because she had a problem with Microsoft Visio , she was trying to draw a process flowchat but using swimlanes, this was not a problem until she realized that it would be better to use vertical swimlanes instead of horizontal ones.    But, when she tried to drag a vertical one it just put together to the previous swimlanes created before.  To avoid creating a new visio document and lost your work just go to 'Cross-Functional Flowchart' ribbon and select 'Orientation' and 'Vertical'.     And it's done, now you can work with vertical swimlanes or if you like it you can turn them back to horizontal ones.