The BBC has released some high-quality images from their famous TV shows to be used as online meeting backgrounds or in PowerPoint slides. Pick from Doctor Who (old or new), Fawlty Towers, Yes Minster, Match of the Day, Eastenders and more. Consider using these BBC TV backgrounds in PowerPoint for
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
Why you can’t insert national flag emoji (among many) in Microsoft Office and Windows but can in Office for Mac, macOS, iPhone and iPad. We’ll explain the workaround necessary to insert national flags in Windows and Office for Windows. Apple devices (macOS, iPhone and iPad) show flag emoji properly like
Use these handy Excel formulas for circle and sphere calculations! Whether they’re a distant memory from school days or a recent discovery, you can easily compute them using Pi π, or as Excel dubs it, Pi(). Many formulas rely on Pi 𝜋 so Excel has a simple function Pi() which
Immersive Reader in Microsoft Word 365, available on Windows, Mac, iPad, and Teams, offers a unique way to view documents. It provides tools to enhance reading skills, pronunciation, and fluency, while minimizing visual distractions to improve focus for users of all ages and abilities. Immersive Reader can declutter your text.
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
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
