Thursday, February 28, 2013
Microsoft Office 365 is a subscription model and yet it is / can be, local installed software (Microsoft's strength) not just feature poor webapps. Here's a video detailing this:
Fast forward to the 6th minute for a quick demo and then start the video from scratch. The transcript is here and you can participate in a trial evaluation.
Wednesday, February 27, 2013
The COUNTIFS() function allows you to use more than one criteria for the statistic. Often, we think of this as for example, counting the row entries where Country is “Australia” and State is “NSW”
So in this case, there are two rows of Australia, NSW
and the COUNTIF expression is
However, we can also use multiple AND criteria on one parameter e.g. Count how many entries are between 20 and 30
In a related vein, for the visual Conditional Formatting, we can create more than one Rule on a Worksheet. Often, we may use a different Rules for different parts of the Worksheet. But, there’s nothing stopping you from using more than one Rule (as long as the Rules don’t overlap in scope) on the same cell block.
In case you want to look around:
Here’s a Microsoft produced video tutorial on SUMIF and COUNTIF functions:
and a downloadable Powerpoint Presentation on nested IFs