Quick Drop

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...

Why does Apple offer to take back your old iPhone? When Apple launches new iPhones, it gives the customers option to return their old iPhones and in return get a reduced price on the new ones (Apple Trade-In) This benefits both the customers and Apple in the following ways: Benefits to Us (the Customers): Customers get to purchase the new iPhones at a reduced price Customers get a chance to stick with iPhones and gives them one less reason to jump to Android (this can be looked at as a benefit to Apple as well) Benefits to Apple: It helps Apple sell a high percentage of their newly launched devices Helps Apple retain their customers by having them upgrade to their new devices If the older iPhones are in good condition, Apple repackages them and sells them as refurbished (used) devices again at a reduced price. This ensures that Apple's customer base continues to expand If the older iPhones are not in a good condition to be sold again, then Apple will disassemble the parts of the iP...