thetechpapa – Blog for tech support
The Tech Papa - All tech updates about Apple, iOS, Windows, Google, Android, Amazon, Home Automation, Solar and Tech Reviews
Excel Tips and Tricks includes all MS-Excel shortcuts, Excel hacks.
Countif function is a cool tool which allows you to get a count of specific item from a column in Microsoft Excel. Example used in this article displays a list of users who logged in to a website using different devices. And let’s check how to get a count of users who logged in using […]
Calculating time in Excel is a great tool for preparing employee time sheets. Format preparation required only for one time. Once it is done just by entering the ‘Start Time’ and ‘End Time’ Excel will Calculate time difference. As an example, for time calculation, we have used a simple table in Excel. By understanding the […]
In this we use ‘YEARFRAC’ function to calculate number of years between to dates. This trick can support you with age calculations or anything similar. The only drawback is it will only display the number of years. But even by mistake if you enter the smaller valve in ‘Start Year’ the larger valve in ‘End […]
This Excel Hack is to convert small letters into Capital letters using ‘=UPPER’ formular. Also, this helps you easily convert simple to capital using the Excel formular. Now you don’t need to copy paste the data into MS-Word and then convert the data into lower case. Also, in another post we have displayed how to […]
Among the list of useful Microsoft Excel Tricks converting capital letters into small / simple letters is most important. The formular used in this conversion is ‘=LOWER’. This can be used to convert a single cell or a range of cells at once. Step Guide to convert Capital letters into small letters in Excel Click […]
