Designing a Book Cover

As you might have noticed – I have a book out!

Word Magic Front Cover
110 Tips, Tricks and Shortcuts to Master Microsoft Word

But how did I design the cover? Well, I think its’ kind of an interesting story.

My first cover looked like this:

Alternate Word Magic Cover
Original Word Magic Cover

Now, this cover is quite different from a “standard” computer manual cover. It has a serif font, a different style of image (a burst of “black magic” with sparkles) and a solid intense colour on the cover. I wanted the book to look different, because I’m trying to reach a different audience. I’m looking for readers who would normally not be attracted or interested in reading a hefty user manual. Word Magic is a short (150 pages), paperback sized, fast read. I wanted it to look different from the beginning.

In my reading I ran across Dave Chesson, the “Kindlepreneur” and he recommended a service called Pick.Fu which provides A/B testing.

So I started by asking what people thought of this cover. And the results, were not what I thought they would be.

Change whatever the object is behind the words. Its confusing and dark and I dont like it.”

“I like that the text is the focal point and easy to read. If possible I would change the image in the background because I’m not sure what it is.”

Interesting, because my family and friends liked the cover.

So I asked a family friend to design an alternate cover and she came up with this lovely clean design (and changed the title in a powerful way).

Word Magic Alternate Cover
Word Magic Alternate Cover

And then went back to Pick.Fu and ran a poll comparing them.

The new design won by two votes and the comments about the old design continued to criticize the graphic. Clearly, it wasn’t communicating “magic” to the audience. My family and friends liked it because I had explained it to them.

But, I was still committed to my concept of a non-standard looking computer book. I also wasn’t keen on a white cover, as that doesn’t stand out as much in a small thumbnail view that is used on Amazon/Kobo.

So I went back to the drawing board and came up with two new options.

Alternate Word Magic Cover - Block Design
Alternate Word Magic Cover – Block Design
Alternate Word Magic Cover - Magic Swirl
Alternate Word Magic Cover – Magic Swirl

I ran a third poll comparing the three covers, and this time the white cover and the magic swirl design were tied.

But again, the comments were the useful element here.

the worker bee is more interesting to me than the freaky finger”

“(Option) C looks the most magic and cool to me”

“It’s the design of choice C that’s drawing me into want to learn more about what this book or product is and then choice B is my second pick .”

Overall, the comments for the magic swirl were more positive even though the votes tied.

But, just to be sure. I ran a final poll comparing a serif font vs a sans serif font – just to make sure I wasn’t being too stubborn.

Word Magic Alternate Cover Sans Serif Font
Word Magic Alternate Cover Sans Serif Font

The serif font (and the decorative dot on the i) won the final poll.

Word Magic Front Cover
110 Tips, Tricks and Shortcuts to Master Microsoft Word

It was a very interesting journey to the final product.

January 2023 Teaching Schedule

 Foxit: PDF Editor Medicine Hat College Continuing Studies
January 18-19, 2023

When Adobe moved to a subscription model for all its products, other businesses moved in to offer their stand alone software. One of those products is Foxit’s PDF Editor. What is PDF Editor Software? With a PDF Editor you can edit the contents of a PDF; changing text and images, reordering and deleting pages, create forms, add and update headers and footers, add and update watermarks, assemble new PDF documents from multiple sources, and redact documents. There is a lot you can do with a PDF editor, so much that it required a TWO day course to cover it all.

Microsoft Excel: Formulas and Functions Medicine Hat College Continuing Studies
January 27, 2023

Need to feel more confident about building formulas and using common Excel functions? Try this one day course. Among other topics, you’ll learn about absolute and relative references.

This course will also run in June.

 

Upcoming Course Trailer

I’ll be teaching the Formulas and Functions course at Medicine Hat College for Continuing Studies on Friday, January 28, 2022.

Absolute and Relative References are just one of the topics we’ll cover that day.

Get More From PowerPoint with the Medicine Hat Chamber of Commerce

Join me in this webinar, hosted by the Medicine Hat Chamber of Commerce

There’s been a lot of talk lately about “Zoom Fatigue”. The trailer above is one way to combat fatigue. Creating trailers for your presentations allow you to shorten the presentation by introducing information ahead of time. Like a movie trailer; your talk trailer tells your audience what to expect and allows you to cut your talk time down.

And why limit yourself to a single trailer? For longer and more complex materials, you might want to create multiple trailers that can prepare your audience properly for your talk.

Creating your trailer in PowerPoint allows you to easily reuse elements in future trailers. This saves time and strengthens your brand presence.  You can bet I’ll be reusing the little animated stars on this slide that act as an attention getter for keywords.

Showing elements to be reused.
These little purple star animations pull the eye to key words

Like the idea of saving time? Drop me a line, and lets’ make something fantastic for your next presentation. A reusable something fantastic!

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