Question: I'm trying to figure out how to use conditional formatting to check if the date column is in sequential order and highlight a cell if it is not. Answer: Here is how you can create a conditional formatting rule which would highlight dates or numbers out of...
Microsoft
Increase and decrease font size quick and easy with a shortcuts in Word, Outlook and PowerPoint
Let's talk about text, baby. Let's talk about Outlook, Word and PowerPoint, namely, because today's keyboard shortcut works in all three. So let me give you the shortcut now and then I will tell you about something extremely odd in relation to this particular issue of...
Comment Excel formulas with the N() function
Three-in-one today. That's right, today you will discover one shortcut to add a comment to an Excel formula, discover how to use the N() function to add a comment and learn about N(). Using comments provides potential users -and yourself- with additional information...
Hop hop hop across slides with this PowerPoint trick
No mouse! Need to edit or review PowerPoint slides? Press CTRL+ENTER to move from placeholder to placeholder. When you reach the last placeholder, press CTRL+ENTER to create a new slide. This magic trick is particulary useful when worky with those busy slides with...
Insert the current date or time quickly without looking at your watch with today’s Excel tip
What’s today’s date? What time is it? Did you have to look at your calendar and clock? The keyboard shortcut and functions in this article will make your date and time entry in Excel fast, easy and accurate.
Delete Outlook Messages before they Arrive
Too popular at work? For some reason, your Outlook inbox is where everybody else's conversations converge. From now on, instead of deleting messages that you are not interested in, why not delete messages which you will not be interested in? Yes. Delete the future...
From data to chart – Monday’s essential Excel shortcut
From data to chart - Monday's essential Excel shortcut Select the data. Include column and row labels in your selection and they will be used to label the chart. Press F11. Done! The chart is created on a separate sheet in full page mode instead of embedded where the...
Troubleshoot Excel Formulas Like a Pro – Part 1
Have you ever had to reopen an old workbook – or worse, a workbook that was set up by someone else – and figure out what was going on in it, update it without being sure that you weren't going to break some of the calculations? Of course, you may already know about...
Quick PowerPoint Training Tip: Insert a New Slide with a Shortcut
To insert a new slide in a PowerPoint presentation with a shortcut and apply the current layout to that new slide, type this shortcut on your keyboard: CTRL+M How good is that? Like, Share or Comment to tell us how good. The next PowerPoint tip is going to be...
Troubleshoot Excel Formulas with a Shortcut
Review all the formulas in your workbook quickly. On Friday, a longer article will tell you about troubleshooting worksheets. Here's how to get started: Switch from values to formulas with CTRL+`(that's single quote, the key just above the tab key on your Irish /...
All about Microsoft