Let Excel help you cut your credit card debt by calculating the monthly payments needed to pay off the card. The PMT function in Excel calculates of loan payments needed to clear the debt in a certain time. Suppose there is a remaining balance of $5,400 on a credit card
Excel can calculate the future value of your investments, such as finding out a return you’ll get on a Certificate of Deposit (CD) or Term Deposit. There’s an inbuilt Excel function to make the task very simple. It’s just one way Excel can make your financial decisions a whole lot
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,
Word has a way of finding Unicode symbols by their reference number, except it doesn’t work for many symbols and not at all for emoji! And the Find ^u option is inconsistent with the rest of Word and common practice. These bugs have been in Word for a few years
Make your own Wordle grids in Microsoft Office, Word, PowerPoint or Excel. Choose the right font, colors (the exact green, yellow or grey) plus grid details including blank or unfilled boxes. Wordle was originally a standalone app, created by Josh Wardle . It’s now owned and run by The New
How to insert the Grinning Face 😀 emoji into Microsoft Word, Excel, PowerPoint or Outlook. Both in Office for Windows and Office for Mac. Grinning Face 😀 emoji is usually depicted as a yellow face, with open eyes and a wide smile. Conveys good cheer or humor, often to make
Microsoft is warning about a security bug in Windows and Office that has no patch (yet) but is being publicly exploited. We’ll explain what to look out for and how to protect yourself. It appears to be (yet another) security hole in Windows which allows unauthorized code to run on
Barbie (the doll, not the Aussie BBQ) is everywhere at the moment so we’ll explain how to select Barbie Pink in your Word documents, Excel sheets and PowerPoint slides. There’s no one Barbie Pink but a selection to choose from. We looked around various official sources for the toys and
Finding emoji or any high value Unicode symbol is difficult in Microsoft Word because of bugs in the software. We’ll explain the only reliable way to find emoji and the problems with the features that should work, but don’t. We’ll start with the best answer we can find. It’s not
Some more Microsoft Word Find tricks. Select and Find, finding blank lines, search for special characters/emoji, find a certain font or formatting plus wildcard options. This article follows on from our introduction Find pane search secrets in Word Select and Find If you select some text in a document then
How to put text around an object; image, chart, shape or other Microsoft Word object. Continuing from our look at putting Word text vertically, at an angle or curved Text around a Box Putting text around a box requires four separate text boxes, positioned and grouped around the object. Here’s
Word isn’t limited to horizontal text, with a little digging on the ribbon you can put text vertically, at an angle, on a curve or even around a shape or picture. And in Put text around a shape, square or circle in Microsoft Word we’ll look at: From the Office-Watch.com archives there’s
Microsoft has a better, smarter option for the telephone activation of Office 2021, Office 2019 or earlier versions of Office with a method nowhere near as painful or clumsy. All you need is a smartphone, iPhone or Android. What is Microsoft software activation? Software Activation happens after installing perpetual license
Add the Easter Island stone statue (Moai/Moyai) 🗿 symbol, 3D model or photo into Microsoft Word, Excel, PowerPoint or Outlook. Both in Office for Windows and Office for Mac. Moai 🗿 symbol represents the famous stone statues of Easter Island. It can be used to show a deadpan, ‘straight face’
There are many ways to visually explain a list of values with different types of Excel Charts and other trickery. We’ve already looked at the numerical or statistical ways to summarize a list of values. Now let’s visualize the data in various ways available easily in Excel. There are various
Everyone knows the SUM function in Excel but that’s just the start, there are eight SUM() functions (and more) for adding up numbers in different ways. SUM() SUM is one of the first functions taught to newcomers. It’s as old as Excel itself (older because SUM was in the first
With the sale of fonts via the Microsoft Store and cloud fonts there’s now a complication in the familiar way fonts are managed in Windows 11/Windows 10 and how Office for Windows handles new fonts. There are now three different locations that fonts can be saved. For as long as
A Windows 11 update might stop Outlook or other Office apps from working because of a conflict with anti-virus software. The trouble started with KB5027231 a Windows 11 update released 13 June 2023 which, among other things, fixed a file copying bug. 15 days later Microsoft admitted there was a bug
How large can a document in Microsoft Word actually get? While most users never hit the upper limits, Word does have technical size restrictions that can affect performance, file stability, images, and long reports. Here’s what you need to know about maximum Word document size, file limits, and how to
Insert the Telephone receiver symbol 📞 into Microsoft Word, Excel, PowerPoint or Outlook. Both in Office for Windows and Office for Mac. Telephone receiver or handset 📞 symbol can be used on a letterhead or sign where a phone number is shown. There’s an emoji in the Unicode standard plus
A clever interactive from The New York Times explains the basics of fonts and how to choose the right font for your documents, slides and sheets. What’s your type? Try these tests to pick the perfect font for you starts with an option to read the whole article in different
Microsoft Designer now has an image editing tool that’s been missing from Microsoft Office. Erase in Designer lets you edit images in an important way that’s not possible in Word, Excel, PowerPoint or Outlook for Windows or Mac. Picture editing in Office has a lot of features but they mostly
Type the ‘pushing hands’ emoji, left 🫷 or right 🫸in Microsoft Word, PowerPoint and other Office apps. Officially the emoji are called Rightwards Pushing Hand 🫸 and Leftwards Pushing Hand 🫷 but can also be used as a ‘High Five’. These emoji can be used separately or together to great effect,
Tiny Windows are stripped down versions of Windows 11 and Windows 10, ideal for older computers or virtual machines. We tested Microsoft Office on both ‘tiny11’ and ‘tiny10’ to see if the Office apps can run in memory far below the official limits. Tiny Windows are stripped down versions of
