Quick Drop

Here is a cool way to take screen shots on galaxy devices. See the below GIF

Are you trying to capture something on your Android device's screen? Taking a screenshot on an Android device is a simple process that allows you to capture an image of whatever is currently displayed on your screen. This can be useful for a variety of reasons, such as sharing information with others or saving a record of something for later. In this blog post, we'll show you how to take a screenshot on Android. To take a screenshot on most Android devices, simply press and hold the Power and Volume Down buttons simultaneously for a few seconds. The screen will flash, indicating that a screenshot has been taken. You can then find the screenshot in your device's Gallery app or in the Screenshots folder of your device's storage. If your device has a home button, you may need to use a different method to take a screenshot. On some Samsung devices, for example, you can take a screenshot by pressing and holding the Power and Home buttons simultaneously. On other devices, you...

Below are the Wallpapers from Samsung Galaxy S21 These images can be downloaded directly

At WWDC 2021, Apple unveiled the all-new and exciting iOS 15. Download the iOS15 Wallpapers here.

When editing formulas in excel, it sometimes becomes difficult to input the required parameters correctly for the formulas.  Hence to help us we have an option to display the formula along with the input parameters in an input-friendly format. Check out below !! 1) When inputting a new formula in an excel cell, type the formula and then press CNTRL+A,  and below is what you get which helps in giving the correct input to the formula 2) The above shortcut will not when if you want to change an existing formula. So when changing the formula in a cell, select the cell and press SHIFT+F3 Now in the above case, we have multiple formulas in the same cell. You can see both the formulas in this format by just clicking on those formulas in the input bar at the top This pop-up for editing the formula is very helpful as it shows the output also as we give the inputs to the parameters of the formula.

The Scientific format displays a number in exponential notation. For example, a 2-decimal scientific format displays 12345678901 as 1.23E+10 How to get a number displayed in Scientific/Exponential Format? Select the cell(s) which contain the number(s) which need to be displayed in exponential format and then select the format "Scientific"  as shown in the below screen shot. Use the "Increase Decimal" & "Decrease Decimal" buttons (in the red box below) to be able to display the complete number. Below is the end result after increasing decimal places for the first number. How to get a number currently displayed in Scientific/Exponential Format to be displayed in normal format? If you input any number in an excel cell with 12 digits or more, excel will display that in the exponential format.  In our example the number is "1234567891012" and excel displays it in the exponential format as shown below: To remove the exponential format, change the ...

A quick trick of selecting a specific date across all Months & Years. In our example, we have the document date field in the filter on the Pivot and the document date has values from years 2019 to 2021 and I need to select the 20th of every month from 2019 to 2021.  Just input  */20/*  and we have the 20th across all months and years selected.

Below are Wallpapers from the newly launched iPhone 13 Click on the image and then download it.

Download the newly released Android 12 HD wallpaper below

A quick trick of selecting all the days of a month in a Pivot Date Filter.  In our example, we have the document date field in the filter on the Pivot and the document date has values from 2019 to 2021 and I need to select all the dates in the month of August 2021.  Just input 8*2021 and all the dates for the month of August 2021 get selected.

1) Pivot Date Filter - filtering all days of a month A quick trick of selecting all the days of a month in a Pivot Date Filter.  In our example, we have the document date field in the filter on the Pivot and the document date has values from 2019 to 2021 and I need to select all the dates in the month of August 2021.  Just input  8*2021  and all the dates for the month of August 2021 get selected. 2) Pivot Date Filter - Selecting a specific date across all Months & Years A quick trick of selecting a specific date across all Months & Years. In our example, we have the document date field in the filter on the Pivot and the document date has values from years 2019 to 2021 and I need to select the 20th of every month from 2019 to 2021.  Just input  */20/*  and we have the 20th across all months and years selected.

Method 1: Direct input of Formulas in a table in word document 1) Create a table and insert required data into it 2) In our example, we need to have a formula in the last column, it should be a multiplication of the 2 columns to its left. To do this keep the cursor on the cell which needs the formula then go to to "Layout" tab at the top and click on the button "Formula" 3) In our example, we can calculate the product using the following 2 formulas: =PRODUCT(LEFT) =C2*D2 Quick Notes: The word (LEFT) in the above Formula indicates that the formula will be applicable on all cells to the left of the cell where the formula is applied. The Cells can also be referred to how they are referred to in excels starting with A1 referring to the cell in the first column and the first row. The list of all possible formulas can be seen in the drop-down under "Past Function" In case of any value change in cells of the table, the formula will not auto-refresh like in excel...