How to get collections for Office evaluators in Windows Follow these steps to verify that you have the right to install collections for Office evaluators on your device. If so, select the desired level of evaluation program and install the current build. Find out which programs are included in the Office evaluation program . Verification of compliance Open Read More
External Data (Connections) in Excel 2016 for Mac
These days we all live and work in a multi-device, multi-platform world, and so when building Office 2016 for Mac, one of our key objectives was to make it as easy as possible to transition from using Office for Windows to using Office for Mac and back again. That’s why you’ll notice an interface that’s consistent Read More
Jocky Piano – Rehearsal For 2021 Mother’s Day
Let’s play a song for 2021 Mother’s Day! Arietta By: Wolfgang Amadeus Mozart Performed By: Jocky Lai
How to Put Double Quotes (Quotation Marks) “” in Excel VBA?
I find the easiest way is to double up on the quotes to handle a quote. Some people like to use CHR(34)*: In this sample, the formula will check if D2 contains a space or not, Like ” ” and then decide which calculation to apply.
What is Cross-Report Drillthrough in Power BI and How to Use It?
With the Power BI cross-report drillthrough feature, you can contextually jump from one report to another report in the same Power BI service workspace or app. You can use cross-report drillthrough to connect two or more reports that have related content, and to pass filter context along with the cross-report connection. To initiate cross-report drillthrough, you select Read More
How to Count Unique Values in Excel 365 – UNIQUE Function
The Excel UNIQUE function returns a list of unique values in a list or range. Values can be text, numbers, dates, times, etc. Extract unique values from range Return value Array of unique values Syntax =UNIQUE (array, [by_col], [exactly_once])Arguments array – Range or array from which to extract unique values. by_col – [optional] How to compare and extract. By Read More