Animated GIFs and Video for Social Media Using PowerPoint

Exported PowerPoint Image

The latest version of PowerPoint allows you to export your presentation as an animated GIF. Animated GIFs are great for catching the eye on social media.

Redcliff Library Board Member Promotion - as an animated GIF
Redcliff Library Board Member Promotion – as an animated GIF

There are of course, lots of animated GIF sofware packages available, many are free. But none are as useful as PowerPoint when it comes to incorporating imagery that you already have on hand. Remember to keep the size of the file down, as Twitter limits animated GIF size to 5MB.

If you want a little more room or sound, remember that you can export your PowerPoint presentation as a video in mp4 format.

You notice some differences between the video and GIF versions of this little social media piece. This is to optimize file size for the animated GIF.

The beauty of creating this in PowerPoint is that it is easily accessible for updating by the client.


Like what you see? Drop me a line, and lets’ make something fantastic for your next social media promotion. A reusable something fantastic!


Music:

Path Of The Fireflies by AERØHEAD | https://soundcloud.com/aerohead

Music promoted by https://www.free-stock-music.com

Creative Commons Attribution-ShareAlike 3.0 Unported

https://creativecommons.org/licenses/by-sa/3.0/deed.en_US

Excel: Find the Weekend

In a previous post I showed how I entered a column of repeating dates when building my Social Media spreadsheet. The next thing I like to do, is colour code those dates so that I can see at a glance when the weekend dates are. For this I use the WEEKDAY function in Excel.

Weekday Function Example

Point the WEEKDAY function at a date and it will return a number from 1 thru 7 indicating what day of the week the date is. In this case the formula reads =weekday(A2,2)

The 2 in the above formula is the return type, and here indicates that the week starts on Monday. This means that Saturday and Sunday will return values of 6 & 7.

This is perfect for using with conditional formatting.

If I plug the following formula into the conditional formatting dialog box
=(WEEKDAY(A2,2))>5

I am testing for values above 5, namely the weekend. So I can use this to put a colour fill in those dates so that they stand out.

Weekday function with Conditional Formatting

Obviously, the Results column isn’t needed because the formula is actually residing in the Edit Formatting Rule dialog box.

This is the second post discussing using Conditional formatting with a Social Media spreadsheet. Check out this previous post for another example of using conditional formatting.


This post is originally from 2016. If you want help with the newest and classic features in Excel drop me a line at catharine@mytechgenie.ca

Excel: Sequential Dates in Multiples

The Fill Series Dialog

When I’m setting up my Social Media spreadsheet in Excel, I like to limit the number of scheduled Facebook entries per day. Over time, I’ve come to think that 4 Facebook entries per day is a reasonable maximum. This lets the librarian post “live” when things are happening in the library without clogging up our follower’s feeds.

So I want to create a column of dates that looks like this:

Each date is repeated 4 times
Each date is repeated 4 times

The quickest way to do this with minimal typing is to use the Fill Series dialog box. Since Excel 2007, you can find it under the Fill menu on the  Home tab.

Finding the Fill Series Dialog
Finding the Fill Series Dialog

To use the Fill Series dialog, select the range of cells you want your dates to be entered in. Make sure the first cell in the range has the starting date. Then select the  Fill button and choose Series .

The Fill Series Dialog
The Fill Series Dialog

Enter a  Step value. In this case, because I want 4 repeats of each date I’m using .25 as the Step value. If I wanted 5 repeats, I’d use .20 (and so on).

If you don’t feel like calculating how many cells to select when doing this for a date range that spans a couple of months; try using a  Stop value . With a  Stop Value, the series will stop at the first instance of the date entered into the field. Otherwise, the series will fill the entire selected range. ( In the picture above the full date is not displayed in the field, it was actually 06/01/2016.) Using a <em><strong>Stop Value</strong> </em>allows you to make a rough selection (say 500 cells) and Excel will stop when the series runs its’ course.


This post is originally from 2016, however Filling a series is still as useful in 2020 as it was then.

If you want help with the newest and classic features in Excel drop me a line at catharine@mytechgenie.ca