New Releases and Random Writing Thoughts

First, I had a few new releases recently. Between moving and unpacking (how many books can one person own??), I didn’t post about them here because they were compilations of the Excel, Word, PowerPoint, and Access titles I released earlier this year.

But here you go: Excel Essentials 2019, Word Essentials 2019, PowerPoint Essentials 2019, and Access Essentials 2019. These are perfect choices for anyone who knows they want to go as far as I can take them with learning one of the above programs. Otherwise I recommend starting with the beginner title in each series because often that’s all someone needs to learn when they’re just getting started.


Now on to the writerly thoughts…

First, I had to work on these books a little earlier than I wanted to because of the lovely changes that IngramSpark (“IS”) has made recently. If you’re not aware of them, then settle in for a quick rant.

IS charges about $50 for every new title that’s uploaded to them and then they charge $25 to change a cover or change the interior. But there have always been promo codes floating around. Participate in NaNoWriMo, get a code for the next six months. Go to a conference, get a code for the next six months. Join a member organization like ALLI or IBPA get a code for however long it last until they decide to change it.

I joined IBPA and had a code from them that I happily used for all of my uploads and updates. But then suddenly this year IS decided that you could only use that code 50 times in a year. Which seems like a lot. 50 times. Who would need more than 50 uses?

Well, let’s look at my year-to-date. I published 22 titles so far. The four main Excel 2019 titles, three Word 2019 titles, three Access 2019 titles, three PowerPoint 2019 titles, and the Microsoft Office for Beginners 2019 title were all in paperback and hardcover. So that’s 28 uses of a code right there. Plus the other 8 titles that in this case were just paperback. So 36 uses for new titles.

Normally I might do something like update other titles I already had out to change the Also By page to reflect my new releases. If I did that for my cozies at this point I have 9 titles in paperback, paperback large print, and hard cover large print. That right there is 27 code uses and we’re not even touching on the new title which would be another three uses. So for one new release of my cozy mystery series I’d need 30 code uses.

Well, imagine how unhappy I was when IS decided that limiting codes to 50 uses per year wasn’t enough and instead decided that you could only use a code five times in a month. More uses per year (60), but it would take me six months to get all of my cozy titles updated for a new release under that scenario and wouldn’t be able to publish or update any other titles in the interim.

What makes it even worse is that they seem to have an automated process for interior updates once a book is published. So they’re literally charging $25 for a process that doesn’t involve a person. And they’re changing their rules to try and get that money out of authors who’ve been publishing with them for years who didn’t sign up for that kind of b.s.

(Their stated reason is because they want to support legitimate publishers only and not scammers, which…well. Way to throw the baby out with the bath water.)

So anyway. This latest release of four titles involved eight books, one paperback and one hard cover of each title. So to avoid paying $50 for books that might not make that money back (I do the hard covers for libraries but there’s no guarantee they’ll want the collections), I had to start the process in July and use my five codes in July and then finish it in August to do the last three titles.

Good times. Love me some self-publishing fuckery. (And there is always self-publishing fuckery.)

What else? If you haven’t yet heard about A+ Content on Amazon, it’s worth taking a look now that they’ve opened it up to all self-published authors. I’ve submitted some content for some of my titles, but it takes about a week to get approved from what I’ve heard so I don’t have examples of my own yet, but here is a link to what an author I know has done and I think it looks really good.

https://www.amazon.com/gp/product/B08NJLC6R1

Scroll down to the From the Publisher section to see what she did.

One of the advantages with adding this content is that it can push an entire carousel of Sponsored Product ads down below that section, allowing authors to own more of their product page. (Not always, but sometimes.) Also, it’s pretty if done well. I think each of the images she’s added to her page there make a reader more likely to buy the book. For example, it takes what was already a strong image from the cover and makes it much larger and more engaging.

To add A+ Content, click on Promote and Advertise for one of your books and then scroll down to the A+ Content section. Next, choose a marketplace and click on Manage A+ Content. That takes you to a separate dashboard where you can create your content.

You can add the same content across books by listing multiple ASINs. (If you have a lot of books you should really have a list of these as I discussed ages ago in Excel for Self-Publishers which is no longer widely available but still available on my Payhip store.)

Content has to be added for each country, but there’s a note that they’ll let you know which other countries would accept content in that language and let you carry it across. I won’t know how well that works until my content is approved and I can test it out, but basically if you’re adding new content, just do it for one country and wait for it to get approved before you try to do all of the countries.

Also, if you use the comparison chart option it’s not well-sized for cover images, but you can do a white background and have your cover only take up part of the allowed space and that seems to work.

What else? I’m sure there were some other writerly thoughts I’ve been having lately but I’m still in post-move malaise so don’t ask me what they were. If I remember, I’ll post again.

And 2 More New Releases

Yet again I am a little behind on announcing new releases. (I impulsively decided to sell my house this month and it required this thing called cleaning that it turns out takes time to do.)

Anyway. The 2019 versions of the Access books are now out, Access 2019 Beginner and Access 2019 Intermediate.

I prioritized these over the PowerPoint updates because it turns out they made one “major” change in Access 2019 compared to Access 2013 that throws me every time I have to use the program and that’s in the import section for External Data.

Now when I want to import an Excel file I actually have to go to the New Data Source dropdown menu, then choose From File, and then I can finally choose Excel from the seconday dropdown. For a new user to Access I thought that was a big enough change that I wanted to get the updated guides out sooner rather than later.

Other than that, though, as with the other guides you’re pretty much fine using either Access for Beginners and Intermediate Access or Access 2019 Beginner and Access 2019 Intermediate. The base knowledge on all of these programs doesn’t change so drastically between versions that you need to relearn it.

(At least not since that lovely 2007 release.)

Back To School Sale

Since the world is still on fire and many people are dealing with back to school craziness, I thought I’d do what I could and put a bunch of school-friendly titles on sale for a couple weeks. Each of the below titles is on sale for $2.99 USD.

Click on any of the images below to be taken to a Books2Read page for that title that has all the stores listed. (If you’re already set up with them you’ll go straight to your chosen store.) Or you can use any of the store pages on the right-hand side here and get to the books that way.

Excel Essentials

Excel for Beginners open sans boldv2 Intermediate Excel Open Sans50 Excel Functions open sans

50 More Excel Functions open sans

 

 

 

 

Word Essentials

Word for Beginners open sansIntermediate Word open sans

 

 

 

 

PowerPoint Essentials

PowerPoint-for-Beginners-Generic    Intermediate-PowerPoint-Generic

 

 

 

Access Essentials

Access for Beginners 20200202Intermediate Access 20200202

 

 

 

 

Data Principles & Budgeting

Data Principles for BeginnersBudgeting for Beginners open sansExcel for Budgeting open sans

 

 

 

 

Keep in mind this is only for the ebook versions, but all of these titles also have paperback versions and most have hardcover versions as well that are, I think, reasonably priced.

And some of these are very good deals indeed, because I was being lazy so I priced everything at $2.99 which means that Access for Beginners, for example, which is usually $7.99 is on sale for the same price as Excel for Beginners, which is normally $4.99. (USD. But equivalent discounts in your local currency.)

Enjoy.

 

 

New Releases: Microsoft Access

Access for Beginners and Intermediate Access are now live in ebook on Amazon and making their way to all the usual places. (Paperbacks should be live soon, too, but will take a day or two to link up to the ebook.)

I’m pretty sure these are books I said at one point that I’d never write because even though I use Access on a regular basis and find it essential to tracking all of my publishing results I never quite felt I knew it well enough to write a book on it.

So I finally went out a bought a book that someone else had written on Access to see how much beginner/intermediate knowledge I actually had. And it turns out that I knew about 95% of what I needed to write the books.

And, more importantly, that the way I think about how to use Access is completely different from the way the author of that other book thought about Access. It literally made my brain hurt to try to follow the way that person presented Access. Which made me realize there might be a need out there for the way I think about it.

So I wrote it.

These ones are longer than the ones on Excel, Word, and PowerPoint. And I’d recommend being familiar with Excel before you start them. But hopefully they help at least one person out there to master Access, because I really do think it’s an incredibly useful tool (for those circumstances where it makes sense, which in my opinion are somewhat limited these days).

Enjoy.