Excel statistical functions have many Average / Mean options including Average with IF for filtering or mean with extreme values excluded. by David Goodmanson In a world which has more and more data, statistics are really important. They help you distill lots of numbers down so that you can see
If you regularly translate text from or to the same language, you can set default languages. Once you have set the languages, Microsoft Word will automatically translate the text as soon as you hit Translate, without you having to set the text each time. To set the default languages, go
Google Docs can be handy for sharing and working on documents with other people, but sometimes you just really need that file in Microsoft Word. No problem – it’s actually really easy to convert them. All you have to do is download the file and save it as a Word doc, Excel sheet or PowerPoint deck.
Famous London streets signs are selling for big bucks … or you can make your own in Word or PowerPoint for nothing. A sale of genuine London street signs by Westminster City Council included one for Abbey Road that sold for £37,200 (US$51,000). We thought that was a lot and
Some ‘not allowed’ or ‘prohibited’ symbols, they can be used in Word, PowerPoint, Excel or Outlook. No Smoking, No Phone, No Children, No Drinking, No Pedestrians, No Bicycles, Not Drinkable Water or Mute. The Unicode symbol list includes red circle with diagonal to stop, smoking, children under 18, Mobile Phones,
How to bulk convert old documents (.doc .xls .ppt) into the newer Office formats (.docx .xlsx .pptx etc.). Microsoft has never produced a simple bulk conversion tool for the masses, much to the annoyance of users and network administrators. Redmond probably made that choice for their own self-interest but some
A little-known Word shortcut lets you type Δ Θ Δ Ω Π plus other Greek and math symbols quickly and easily. Ctrl + Shift + Q changes to the Symbol font for the next letter only. Only in Word for Windows, I’m afraid. Not Word for Mac. It’s a very
Type the micron µ, micrometer or mu μ symbol in Word, Excel, PowerPoint and Outlook. Stuart H has an AutoCorrect suggestion: ” I need to use the symbol μ for micron (1/000 mm) and use mu for this. “ The Micrometre / Micrometer is one-millionth of a meter. The μ
Type the Ohm symbol Ω into Microsoft Word, Excel, PowerPoint or Outlook. Both in Office for Windows and Office for Mac. Also the unofficial Siemens symbol, an inverted Ohm ℧ . Ohm is a measure of electical resistance with the symbol Ω It’s an official SI Unit of measurement just
Here’s some power selection tricks in Microsoft Word for text, tables, pictures and more. You might think that selecting text and other things in Word is simple. Like many things in Office, there’s a lot more available than the simple methods that we all learn. There are quick ways to
Type the Greek letter Omega in upper case Ω or lower case ω in Microsoft Word, Excel, PowerPoint, or Outlook. Both in Office for Windows and Office for Mac. Omega (uppercase Ω / lowercase ω) is the twenty fourth and final letter of the Greek alphabet. It is used to often
Sometimes there’s more than one way to do something in Microsoft Word like having four blocks of text on a page with images or text breakout with flowing columns of text with a side-bar or break-out. “How can I do a magazine-like layout with four blocks of text, one in
Here are the best ways to get results from Microsoft Forms into an Excel workbook. Sadly they aren’t the elegant and efficient ways available in modern Microsoft Excel 365, 2021 or 2019 for Windows. We’ll explain how to get Microsoft Forms results into Excel for better filtering and analysis. Then
I said there are at least six tricks with the Excel Name Box and that’s before you get into using named rangers and objects. The Name Box lets you select a cells and give them a name or jump to an existing named range. It’s the same as going to
I found at least six uses for the Excel Name Box beyond just displaying the current cell address. The Name Box is an unassuming little box at the top of your Excel worksheet that you may not have thought about much, but it has a powerful range of uses for
Microsoft Word’s Sort feature is OK but has its limitations. We humans insist on variations of the simple ‘first and last’ name that confuse a computer. Here’s some name sorting traps and workarounds. For short lists, it’s probably enough to do a Word surname sort then manually adjust the list
Microsoft Word sorting is more powerful than it appears, with a few extra clicks you can sort last names or anything else in a list. Sort is one of those Word features that’s been around for a long time. These days it’s tucked away on Home tab in the Paragraph
An Outlook.com or Microsoft hosted mail storage quota can be anything from 2GB to 100GB. Here’s a full list of the mailbox limits, how to check your current usage and total allowed size. We’re talking here about Microsoft mailbox hosting services including Outlook.com. NOT the various and confusing types of
A full and searchable list of the measurements and multiplier prefixes available for Excel’s CONVERT function. This is a table of the abbreviations used in the Excel CONVERT() function. The basic units inbuilt to the function are all listed plus some of the common measures available using the Multiplier prefixes.
What happens to all the different windows open in Outlook for Windows when the software crashes? How can you restore the open windows when Outlook restarts? In case you didn’t know, it’s possible to have many windows open in Outlook. Many people don’t realize that because Outlook first starts with
Microsoft’s mail service Outlook.com might move Office Watch or Office for Mere Morals to Junk Email. Here’s how to stop it doing that for any email, The same advice applies to other newsletters and emails that are wrongly marked as Spam / Junk Email. The famous UK newsletter, Popbitch, is
Converting SVG icons into JPG is essential for older Word and Office versions that don’t have native icon/SVG support. Here’s some options for conversion or sourcing alternatives. SVG’s are great with many advantages for Office 365 and Office 2021/2019 users. Not everyone has the latest Microsoft Office or shares documents
Microsoft Word has almost all you need to make ‘hand written’ notes and letters for a fraction of the cost of a special service. Dig into some of the lesser known Word font and line spacing settings to get that ‘written by hand’ effect. The New York Times has a
Insert the Phi uppercase Φ, and Phi lowercase φ / φ symbols in Microsoft Word, Excel, PowerPoint, or Outlook. Both in Office for Windows and Office for Mac. Phi (uppercase Φ / lowercase φ / φ) is the 21st letter of the Greek alphabet. The uppercase symbol has various uses, such as the cumulative distribution function of standard normal deviation in
