TrimMean() function is a slightly different and useful measure than the regular Excel Average(). It’s still an average/mean but without the high and low, extreme or outlier values in the list. Average() (and its partners AverageA() and AverageIFS() use all the values in the array or list provided. TrimMean() excludes the highest and lowest extreme […]
How does Microsoft Word’s spell check go with the 2021 Words of the Champions list from the US annual spelling bee? Each year the Scripps National Spelling Bee releases a Words of the Champions study list to educators, featuring up to 800 new words. We grabbed a selection of the most difficult words (called “Three […]
Type the Weary / Distraught face 😩 into Microsoft Word, Excel, PowerPoint or Outlook. Both in Office for Windows and Office for Mac. Weary / Distraught face 😩 emoji is also called Wailing, Frustrated or Sadness. How Weary / Distraught face 😩 looks in different fonts. Here’s some examples of how Weary / Distraught face […]
Microsoft Word seems to have two pairs of shortcuts that do the same thing – increase or decrease the font size. This is how they are different. The shortcuts are: Ctrl + Shift + < or Ctrl + Shift + > – which are also buttons on the Home tab. Ctrl + [ and Ctrl […]
The Office Watch “Shortcut of the Week” tips for Outlook, Excel and PowerPoint from 2005 in the one convenient place. Tip 1 – Outlook navigation The Outlook navigation shortcuts could be more intuitive but here they are: Switch to Mail CTRL+1 Switch to Calendar CTRL+2 Switch to Contacts CTRL+3 Switch to Tasks CTRL+4 Switch to […]
