Category Archives: Microsoft Office

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

Posted on August 21, 2016 by garysch

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 garysch

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 garysch

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 garysch

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 garysch

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

The Trick to Moving PowerPoint Presentations from a Mac to a Windows PC

Posted on November 1, 2015 by garysch

I hear this all to often “I’m not getting a Mac again as I can’t use my PowerPoint presentations on a Windows PC”. Well yes you can and the same applies from Windows to a Mac. I usually hear this … Continue reading →

Posted in mac os x, Microsoft Office, PowerPoint | Tagged , , | Leave a comment

Creating an Index in Word

Posted on May 18, 2015 by garysch

An index is an important way to reference key words or phrases in a Word document. It compliments a table of contents and allows your readers to look for something specific n Thankfully you do not need to type out … Continue reading →

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

Creating a Table of Contents in Word

Posted on May 17, 2015 by garysch

You know that feeling where you need to type up some instructions and you think it is not going to be too extensive but ends up being pages and pages, well that was one of the tasks when I recently … Continue reading →

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

Add Video to a PowerPoint Presentation

Posted on April 18, 2015 by garysch

Whenever you go to a presentation it seems that most of the time they are using PowerPoint to help get their message across and adding video can certainly help. Video has certainly become easier to create even using your phone … Continue reading →

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

Selecting Data in Non-Adjacent Cells to Create Excel Chart

Posted on January 10, 2015 by garysch

Creating charts in Excel is pretty straightforward and you can see how to that in this video, getting started with charts. What normally happens is you select a group of cells and then insert a chart but what do you … Continue reading →

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