Wanna be a better, faster Office user? Impress your friends? Be the envy of women and men for miles around? Try out Office KeyTips – the keyboard shortcuts you don’t have to memorize because they are on the screen. Simply press a few keys to accomplish tasks quickly, no matter
Microsoft PowerPoint’s Cameo lets you put a live camera feed into your slides. The camera feed can be moved, resized, cropped, and styled just like any other image. Designer in PowerPoint can also be used to add flair to slides that use cameo. Cameo is already in Windows and Mac
Safe Mode is a special way for Office apps to run when things aren’t working properly. Here’s how to use Safe Mode, if Office doesn’t offer it automatically, and what Safe Mode does differently. Safe Mode is useful in situations where you cannot open files in normal mode because the
In addition to Manual, Paragraph and Style page breaks there are two unusual ways that Microsoft Word can insert a page break where you might not expect one. Keep with next and Keep lines together. Learn about Word Page Breaks: Visible and Invisible Page Breaks in Word and Add a Manual
Excel’s IRR() function is a straightforward way to calculate the rate of return for investments which have regular return/payment dates with amounts which might vary. Such as a simple fixed-interest bond, where cash flows occur at regular intervals such as monthly or yearly. When expressed as a percentage return, it’s
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,
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
Word and Office have several left “pointing hand” symbols available in some fonts. Here’s the Unicode options explained and shown. We’ve also looked at the options for All the RIGHT pointing hand symbols in Word and Office Want more arrows or pointers? Check out all 200+ Arrow or Hand pointing
Any Office ribbon tab can be more useful for you. By trimming some of the buttons you don’t need, making room for the buttons you want. We’ll show you how to remove some of the less needed ribbon sections (likely from the Developer tab) to make more room for your
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.
Insert Thumbs Up or Like👍symbol into Microsoft Word, Excel, PowerPoint or Outlook. Both in Office for Windows and Office for Mac. Thumbs Up / Like👍emoji is typically used when you ‘like’ something or have approval/agreement. It’s commonly used as a quick response to a comment on Facebook, Twitter and it’s
VBA code or Macros can be copied between Microsoft Word documents and templates quite easily if you know where to look. We’ve seen people laboriously copying code between VBA editor windows, not realising there’s an easier way. It’s not entirely necessary but usually the two macro-enabled documents/templates are opened first.
With a few PowerPoint keystrokes you can move, rotate or resize an object in any direction in tiny amounts to get it where and how you want it. Positioning objects in PowerPoint applies to PowerPoint for Microsoft 365, PowerPoint 2021/2019 (Windows and Mac), PowerPoint 2016 and PowerPoint Online. Change size,
Placing graphics on a PowerPoint slide is simple but getting them positioned “just right” needs a ‘nudge’. Smart Guides and Gridlines Mostly positioning images and other objects is easily done with the Smart Guides (look for the faint red or gray lines as you move about an object) or use
Microsoft has added SketchUp 3D graphics (.skp files) to the models inserted into Word, Excel, PowerPoint, and Outlook. SketchUp is a 3D graphics program where you can create shareable designs such as architectural models and graphics used in industrial design, product design, and civil and mechanical engineering. SketchUp Free is
There are a few ways to quickly tell which OneNote app you have on Windows. The OneNote that will continue development or the OneNote for Windows app which is gradually being allowed to die. Previously we’ve explained about the upcoming changes for OneNote, including how Microsoft have decided to keep
Here’s a complete list of the Outlook Function Key features from fast access to Help, jumping around your inbox, doc panes, spelling, grammar and key shortcuts. Let’s look in detail the functionality of the F-keys labelled F1 through F12 on your keyboard. F1 – Help, hide ribbon F2 – Calendar
Here’s a complete list of the PowerPoint Function Key features from fast access to Help, jumping around the presentation, doc panes, spelling, grammar and guidelines. What you can do with the F-keys labelled F1 through F12 on your keyboard. Don’t like Function Keys? KeyTips are your way to faster Microsoft Office
Have all your favorite Office features and buttons in one place. Commonly used buttons or options that aren’t on the regular ribbon. The Office ribbon lets you make a personal tab filled with your choices. We will show you how easy it is to make in Word below, but this
Sooner or later, you’ll need the Developer tab in Word, Excel, PowerPoint or Outlook. Even if you know nothing about programming, there are buttons on the Developer tab that are necessary for some of the clever features in Office. If the Developer Tab below is missing in an Office app,
A Word Drop-down list lets you quickly choose one of several options. It’s a fast way to make new documents with a standardized pattern. Don’t be scared, it’s easy to create even though the word ‘Developer’ is involved. We’ll show you how to make drop-down lists, change the bland ‘Choose
After explaining Body Mass Index calcs in Excel, there are other options. Finding your ideal weight from height and desired BMI. Also a BMI alternative and how it can be used in Excel. Find your ideal weight based on BMI Most BMI calculators show your current ratio but what about
