Posts

Showing posts from 2015

Unbrick or Recover Xiaomi Redmi 10A and other MTK devices

Case: Your Redmi 10A (probably other MTK devices too) is not turning on and doesn't react to any button pressed nor cable connection. Requisites:   Dead phone USB Cable  You tried tons of tutorials to unbrick the phone and didn't work This image Willingness to even use Linux to fix it (it's not hard) Steps: Create a bootable USB using the image downloaded. Make sure your computer allows booting from USB. Boot the computer from the bootable USB. When booting, a list of options will be shown. Pick the first one: Boot Live system. Once the system is loaded, go to the right-upper corner to connect to Wi-Fi. Once you have internet, use the Firefox browser (click on the icon in the left-upper corner) and download the Linux version of this tool (SP Flash) and save it in the desktop. Unzip the tool downloaded. Download the fastboot version of the stock ROM . Unzip the ROM, to have the folder and files. Click on 'MTK' icon that is in the desktop. In the command line opene

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.