Once upon a time there was just one ‘Microsoft Outlook‘ but these days there are at least eleven current programs or services under the ‘Outlook’ name * and two programs called “Outlook for Windows”. That’s before counting past versions that are still supported. You’re totally excused for being confused because
Compare one set of numbers with another list of values using ChiTest() in Excel. It compares two sets of numbers and gives a single number to show how different the sets are. ChiTest() or ChiSq.Test() sounds like a complex formula that only expert statisticians can understand – not at all!
Until now, Excel for iPad could use PivotTables already setup in desktop Excel. Now you’ll be able to make and edit PivotTables too. An Excel for iPad PivotTable looks the same as in other Excel’s Being able to make last minute changes to a PivotTable on the iPad is very
Our Christmas Card and Email Manager uses some of Excel’s power to keep track of your Christmas messages (casrds, letter and emails), both sending and receiving. It’s available to download and use, for a limited time. Microsoft has a Christmas Card template for Excel but, to be honest, it’s pretty
Do you ever wish you could take back an email that you sent too soon or with a mistake? You’re in luck because Outlook lets you delay sending messages for a certain amount of time after you hit Send. It’s like having a second chance to prevent a mistake. We’ll
Once you know the ‘secret’ shortcuts, it’s easy to type the umlaut vowels ä ë ï ö ü Ä Ë Ï Ö Ü in Word and Outlook but, alas, it’s not the same in Excel or PowerPoint. There are alternatives in Windows and Mac if you’re not using Word. There’s
There are two different year-round Microsoft 365 discount offers available to US and Canadian military in all branches. Office-Watch.com talked about these Military Appreciation offers before, going back more than a decade. There are TWO different military related discounts – the Military Appreciation Edition and the Home Use Program. Military
Office Lens is a good app for iPhone, iPad and Android devices. If you want to convert photos into a Word document (as text) or PDF, the Office Lens is the way to go. Lens has a wonderful straightening trick that turns an off-center photo into something ‘straight on’ which
Here’s some common circle and sphere calculations that you might remember from school (or long forgotten) but now as Excel formula using Pi 𝜋 or as Excel calls it, Pi(). Many formulas rely on Pi 𝜋 so Excel has a function Pi() which inserts it to 14 decimal places. That’s
Add some extra flair to your plain Excel charts by inserting pictures or graphics within the chart. It’s remarkably easy and enhances charts a lot. You can simply enhance your graph by inserting a business logo in the chart area. Or you might want to add images to replace the text labels. You may want to insert an image of money to represent dollars spent,
OneNote for iPad is finally getting superscript and subscript text formatting options, ten years after the app was released. We’ll show where to find it on the Home tab and the keyboard shortcuts. It’s true, Subscript and Superscript are only now coming to OneNote for iPad (released in 2013). Microsoft
An easier way to put images into an Excel workbook. IMAGE() is a new function which imports an external picture into a cell. We’ll explain how it works and some ways that Image() doesn’t go far enough. Image() lets you drop an picture into a cell with some options to
Use Excel to figure out the percentage discount or increase, for example the difference between the original and sale prices. We’ll show you the Excel formula and some practical tricks beyond the official answer. Percentage discount formula The basic formula is: (Original – Sale) – to figure out the difference
Insert the Right arrow → into Microsoft Word, Excel, PowerPoint or Outlook. Both in Office for Windows and Office for Mac. The official Unicode name is ‘Rightward Arrow” → but it can be called ‘Right pointing’ ‘Right facing’ or just ‘Right Arrow’. Want more arrows or pointers? Check out all
There are at least NINE simple statistics formulas and functions in Excel that can summarize a list of numbers into something easy to understand. Often Excel has lists of numbers or money that makes little sense until you add a summary like this: We have a table called CountbyState and
Calculating the Standard Deviation is simple using Excel’s in-built functions. Understanding Standard Deviation isn’t hard either. We’ll explain the five different STDEV() functions and which one you should choose. Standard Deviation in Excel The standard deviation measures the variation from the average or mean of a sample set of values.
Of course, there are emoji suitable for St Patrick’s Day; four leaf clover, shamrock, top hat, two for beer and a rainbow. Here they are, how they look on different devices and the codes to find them. Emoji for St Patrick’s Day Like all emoji, use with care on web
Make Excel mobile for iPhone or iPad read aloud a workbook. Great for double-checking figures from a printed source. The options aren’t very good but we’ll explain what might be possible. Excel 365 does not have a Read Aloud or Speak feature similar to Word for iPhone/iPad let alone Word
It is possible to display your Mac screen to another person or even let someone take control of your Mac to fix a problem or help learn a computer skill. We’ll explain how to find and start the Screen Sharing app in macOS and an alternative. Windows has a similar
PowerPoint 365 (Windows, Mac and iOS) can now use separate caption files for audio inside a presentation and also export the captions with media. What’s new are captions for audio files like a transcript of a lecture or even song lyrics for a PowerPoint ‘sing-a-long’. There’s a catch but one
There’s a better, more selective way to choose which shapes, images or other objects to ‘Morph’ between slides in PowerPoint 365, 2021 and 2019. Morph in PowerPoint is a way to transition between two slides with a nice smooth effect like this. The Morph transition normally applies to either all
Cloud Fonts are a different, faster and free way to get and use more fonts on your Microsoft 365 and Office 2021 programs and apps. The extra fonts take only moments to install for both Windows and Mac Office users. You may have seen cloud fonts already, they appear in
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,
Word 365 Mobile for iPhone and iPad have Read Aloud or Speak options to make a voice read the document to you. The Microsoft Office options are almost the same for both devices. Read Aloud in iOS is similar to the feature in Word for Windows with the same little
Like almost any web site, we use technologies like cookies to store and/or access device information. We aim to keep that to a minimum. Consenting to these technologies will allow us to process data such as browsing behavior or unique IDs on this site. Not consenting or withdrawing consent, may adversely affect certain features and functions. We apologize for this box but it's legally required in some regions.
Functional
Always active
The technical storage or access is strictly necessary for the legitimate purpose of enabling the use of a specific service explicitly requested by the subscriber or user, or for the sole purpose of carrying out the transmission of a communication over an electronic communications network.
Preferences
The technical storage or access is necessary for the legitimate purpose of storing preferences that are not requested by the subscriber or user.
Statistics
The technical storage or access that is used exclusively for statistical purposes.The technical storage or access that is used exclusively for anonymous statistical purposes. Without a subpoena, voluntary compliance on the part of your Internet Service Provider, or additional records from a third party, information stored or retrieved for this purpose alone cannot usually be used to identify you.
Marketing
The technical storage or access is required to create user profiles to send advertising, or to track the user on a website or across several websites for similar marketing purposes.
