Microsoft has previewed new Office features targeted at students and teaches, however many are good for the wider public too. For example, Dictation is coming to Word for Windows, Word Online, PowerPoint for Windows, Outlook Desktop, OneNote Windows 10, and OneNote Online with support for at least nine languages. Source: Microsoft It’s being hyped as […]
Back in Excel 2013, Flash Fill was added, a nifty way to join or separate a string from other cells by example. If its seems to have disappeared from Excel 2016 for Windows, here’s how to get it back. In Excel 2013, Flash Fill worked automatically. Just typing the first example in a neighboring cell […]
Japan is a special country in many ways, even when it comes to buying Microsoft Office. The Japanese can buy Office in ways that Microsoft have dropped for the rest of the world. Office 365 Home and Personal plans are sold, by Microsoft’s count, in 246 countries and territories but not Japan. Microsoft Japan has […]
Microsoft charges quite different prices for Office 365 Home and Office 365 Personal, depending on the country. We decided to see how cheap or expensive Office 365 Personal plan can be, depending on where you live. Maya surfed through many different Microsoft sites to compile this list of countries and regions. Cheapest Office 365 Personal […]
We’ve talked, at length about Excel’s Rank()/Rank.EQ functions and coping with joint or equal rankings. What about Rank.AVG()? Rank.AVG() works differently for equal rankings because it returns an average of the combined rankings. For example, joint 3rd place getters will return the value ‘3.5’ by Rank.AVG() which is the average of ranks 3 and 4 […]
