Ryan, Author at Ryan M. Williams - Page 2 of 6

All posts by Ryan

Kindle Ads

How to Get Started With Kindle Ads

It's possible to get started with Kindle ads on Amazon in only a few minutes without breaking the bank. In this post, I'll share a quick look at ads and recommend a book (I'm a librarian, I can't help it) if you want to go deeper.

Continue reading
Vacation

Vacation Reflections

Last week didn't go as I had planned. I took a vacation to head down to Lincoln City, Oregon, for a writing workshop on writing fantasy. I've done several of these workshops taught by Kristine Kathryn Rusch. I signed up for this one (and the Anthology Workshop I went to in February) back when I was finishing my MLIS degree as a sort of celebration of graduating. Despite looking forward to the workshop, I found my stress increasing as it drew closer and I ended up getting sick and leaving the workshop early. It's made me think about vacations and the importance of rest and balance.

Continue reading
Creating Graphs Dashboard

Creating Graphs for Word Count Tracking

Creating graphs is one way to visualize your writing progress. It can provide quick insights, particularly over time as you record more information about your word counts in your spreadsheet. If you're unfamiliar with using Excel, you may want to start with the previous posts in this series, starting with the benefits of writing streaks, demystifying spreadsheets, improving the tracker, pivoting for more information, adding project details, and writing a formula to track streaks.

Continue reading
Writing Streak Formula

How to Calculate a Writing Streak in Excel

I talked about writing streaks at the beginning of this series, then went on to describe how to set up a basic word count tracking spreadsheet, added improvements to the spreadsheet, created a pivot table summary, and expanded the spreadsheet with project details. In this post, I calculate a writing streak in the word count tracking spreadsheet. I'll walk you through each step of creating the formula necessary.

Continue reading
Project Details

How to Add Project Details to the Word Count Tracker

I started this series on creating a word count tracking spreadsheet by talking about the benefits of writing streaks, how to set up a basic spreadsheet, added enhancements, and created a pivot table summary. If you haven't read those posts you may want to go back and take a look unless you're already comfortable with Excel. As a next step, we'll add project details in this post, which gives us additional information about our writing.

Continue reading
Pivot Tables

Writers Pivot Tables Too, Further Word Tracking Enhancements

This series started by talking about streaks, went on to spreadsheet basics in creating a tracking spreadsheet, and then leveled up the spreadsheet with an Excel table. In this post, I'll show you how to use pivot tables for greater insights into your writing. Yes, writers pivot tables too—it's an easy way to discover different ways to look at your word counts.

Continue reading
Word Count Spreadsheet

Improving Our Word Count Spreadsheet

In the last post, I went over the basics of creating a simple word count spreadsheet. If you're not familiar with spreadsheets, it's a good place to start. As simple as the spreadsheet is, it provides a foundation for other improvements. Recording the data is only the first step. With the improvements to the word count spreadsheet in this post, we'll start to see how it can be used to provide more information about our writing.

Continue reading
Tracking Word Counts

Demystifying Spreadsheets for Tracking Word Counts

I love data and data tools. Some of my fellow librarians find this amusing—and useful! I find data very useful. This isn't usually considered odd in athletic pursuits. People routinely track and discuss data about their favorite sports teams. If you're a runner you probably know how far, how long, and at what pace you ran. There's a good chance you track that information. Wearable tech has made it easier than ever to track our athletic efforts, visualize the data, and inform our attempts to improve. In my last post, I talked about the power of streaks. Today, I want to share some tips on using simple spreadsheets for tracking your word counts.

Continue reading
Writing Streak

How to Start a Writing Streak (Even If You Have No Time)

I'm a full-time librarian with a family and a writing career. The best way I've found to get words on the page is incredibly powerful. It's also a bit like trying to build a fire with your bare hands. Many writers try starting a writing streak after hearing about the benefits—and it works about as well as most New Year resolutions. I'm going to share the simple techniques that I use to start a streak and build it into a powerful force in your writing career.

Continue reading
Science Fiction Markets

4 Science Fiction Markets for Your Fiction

I love reading short stories. I don't ever have enough time to read all of the short stories that I'd like to read (or novels). Although I'm always happy to read an anthology or collection, I love reading science fiction magazines. I continue to submit my stories to these markets as well, and look forward to appearing in the pages of these magazines.

Continue reading
1 2 3 4 6