Posts

Showing posts from 2018

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
2 comments
Read more

Using Styles in Word

Image
If you have to change the style of a Word document (like changing the color of the headings), you can do it manually by editing each text or you can edit the style only once.   For this, the recommendation is to set a style for the headings you work with, highlight the heading and go to "Styles" and select the one you want. Do this for all your headings.   Later, if you want to customize the style (like changing color) you can right-click on the style you are using and select "Modify...". In the new window edit the color for this style or other properties. Once you accept the edition, this will apply to the headings with the same style.   You will be able to change the style of your document easily by editing the style and no each text.
Post a Comment
Read more

Assigning Colors for Events in Outlook Calendar

Image
When you have many events in your Outlook calendar, it's useful to highlight them in different colors according to their categories.   It's possible to do this manually for each item, but you can set Outlook to do this automatically by right-clicking on an empty slot on the calendar and click on 'View Settings...'. In the new windows that appears, click on 'Conditional Formatting...'. The list of the rules already registered will be shown with the color assigned to each of them. Click on 'Add' and complete the field 'Name:' and select a color for this new rule. Then, click on 'Condition...'. There, you can set the filter for the events that will have the selected color by using different criteria.   Once the setting is finished Outlook will check each new item on the calendar to assign a color if it fits with the filters.
Post a Comment
Read more

Alternative for Screenshoting in Windows

Image
If the default way to get screenshots in Windows is to basic for you, let me introduce you Greenshot , a lightweight open source tool to make screenshots with the option to take a portion of the screen and then edit it. Once you make the screenshot, it's saved in the clipboard so you can use the capture immediately, but if you want, you can right click in the application icon in the taskbar and open the editor:   And add some marks and more: It's straightforward and has many options like capturing the mouse pointer, notifications, sound, default destination and more:   I use this tool as it's really practical, with many options and doesn't eat your memory, very recommendable. 
Post a Comment
Read more

Changing the color of the text when replying email in Outlook

Image
If you use Microsoft Outlook in your computer, you should have this application configured to reply emails by using blue fonts (not black):   To change this, just go 'File' and select 'Options' on the left: Then, go to 'Mail' and click on 'Stationery and Fonts...': In the new window, you will have fonts configuration, select the one in the section 'Replying or forwarding messages' and set the fonts as you like:   Now, when you reply or forward an email you will use the font as you set it.
Post a Comment
Read more

Using INDIRECT in Excel

Image
The INDIRECT function in Excel allows you to reference cells by typing the cell position (for instance: "B2"). To clarify this, look at the first example, you can see in the function bar that it's a direct reference.    In the following example, the indirect function is used with the parameter "D3" as text and brings the same result. Now, as the parameter of the indirect function is text, you can concatenate and build the cell reference by using other cells.      It's clear that using a direct reference (example 1) is better than using the indirect function, however, there are cases where is required to build functions dynamically depending on other values and the indirect function is a great tool to consider for these situations.
Post a Comment
Read more