Category Archives: Microsoft Office

Excel’s Newest Function XLOOKUP

Posted on February 23, 2020 by

VLOOKUP and HLOOKUP are two popular functions in Excel and a new one has come along to replace them, don’t worry they haven’t gone away. The new function is XLOOKUP it is easier to use and has some additional features … Continue reading →

Posted in Excel, excel function, Microsoft Office | Tagged , , , , , , | Leave a comment

How to Crop Photographs and Images in Word

Posted on May 23, 2018 by

If you are adding a photograph, image or picture to Microsoft Word and you need to crop it you don’t need to do that before you insert it into your document you can crop it directly in Word. The advantages … Continue reading →

Posted in Microsoft Office, microsoft word, productivity, Uncategorized, word | Tagged , , , , , , , , , , , , , , | Leave a comment

Creating a Chart in Excel When Data is Not Next to Each Other

Posted on July 1, 2017 by

Excel has some great features for creating charts, I remember when I first started using it and saw how easy it was to create one. You would not believe what I had to do to create a chart before then … Continue reading →

Posted in Excel, Microsoft Office | Leave a comment

9 Really Useful PowerPoint Tips for Presentations

Posted on August 28, 2016 by

If you haven’t got enough to think about when doing a PowerPoint presentation here are some tips that will make it a little less stressful and at the same time might help keep your audience’s attention. Start Your Presentation Quickly … Continue reading →

Posted in Microsoft Office, PowerPoint | Tagged , , , , | Leave a comment

Zooming in on a PowerPoint Slide

Posted on August 23, 2016 by

Ever been doing a presentation and you have a chart, image or data you want to zoom in on. Perhaps you just want to make it stand out or get your audience to focus on it or perhaps it is … Continue reading →

Posted in Microsoft Office, PowerPoint | Tagged , , , , | Leave a comment

How to Enter a Series of Dates in Excel That Are Only Weekdays

Posted on August 21, 2016 by

Do you have to enter data for a bunch of dates but only need weekdays? Excel has the answer for you using the Autofill feature. It allows you to create a series of dates that only include the weekdays.  All … Continue reading →

Posted in Excel, Microsoft Office | Tagged , , , , , | 1 Comment

Excel: How to Enter the Same Day but Different Month and Year

Posted on July 3, 2016 by

We all want faster ways to enter data and you’re probably already aware of the autofill feature in Excel. To enter a series of consecutive dates you just need to enter the one date and then click and drag on … Continue reading →

Posted in Excel, Microsoft Office | Tagged , , , , | Leave a comment

How to do a Screen Recording in PowerPoint

Posted on April 12, 2016 by

If you are doing a PowerPoint presentation you may want to show how something works like a website or some software. You could open the website or software and switch to it during the presentation. However, that can be time … Continue reading →

Posted in Microsoft Office, PowerPoint, Screencast | Tagged , , , , | 1 Comment

Embed a YouTube Video into a PowerPoint Presentation

Posted on April 8, 2016 by

Switching from PowerPoint to a browser in the middle of you presentation to show a YouTube can be messy and time consuming. So wouldn’t it be better if you could just embed the YouTube video into your PowerPoint presentation? It … Continue reading →

Posted in Microsoft Office, PowerPoint, YouTube | Tagged , , | Leave a comment

Adding an Author’s Name to a Word Document

Posted on January 14, 2016 by

If you need to create Word documents and people reading it need to know it has come from you then you may want to automatically add your name to it. This is useful in organisations and this feature can be … Continue reading →

Posted in Microsoft Office, microsoft word, word | Tagged , , , , | Leave a comment