Data Validation Pull down list How to put a blank in the first candidate in the pull-down. Formulas Date operation How to calculate dates. How to display the day of the week automatically from the date. How to get the last business day of the month. How to use the AVERAGEIFS function to calculate on the condition of “Containing a specific string”. How to use the SUMIFS function to calculate on the condition of “Containing a specific string”.(Microsoft Excel) How to use the COUNTIFS function to calculate on the condition of “Containing a specific string”.(Microsoft Excel) How to treat wildcards as normal characters in the COUNTIFS function. How to treat … Continue reading Tips. Others.(Microsoft Excel)