Generate Text With Excel

Generate Text With Excel

Microsoft Excel, which is a spreadsheet meant for crunching numbers, may be the tool of accountants. But I rely on it heavily to help me with text. I generate text using Excel in order to feed data cleanly into systems. No, Excel is my powerhouse for assembling text. It occurred to me that people might get some benefit from learning how to do this, so here is my method:
How To Eliminate Self-Generated Crises

How To Eliminate Self-Generated Crises

How many "emergencies" do you have on a daily or weekly basis that are actually self-generated crises? I'm talking about panic because you can't find something you need right then. Here are tips on the causes of these crises, and how you can stop them in their tracks.
podcast

Podcast Episode 84: Tackling The Task List

My task lists have become a problem. They’ve been growing steadily, and it is now not unusual for me to have 20+ tasks on the list as I start the morning.

It’s not a sustainable approach. Even though I am knocking a good number of tasks off the list each day, it still keeps growing. There are some days I look at the list and I cannot even fathom where to begin.

Today I will talk about my experiment with open, closed and hybrid task lists and the things I am trying to keep myself working. I’m going to call this Episode 84: Tackling the Task List.
Creating Systems To Support Weaknesses

Creating Systems To Support Weaknesses

None of us are good at everything. Many people say to “focus on your strengths.” But weakness in some areas of our life have more consequences than others, and ignoring them might not be an option. If you are in a situation where avoidance won’t work, you need to create systems to support your weaknesses. This article will help you determine weaknesses that need support, and give some examples of how to create a system.
5 Ways To Beat Procrastination

5 Ways To Beat Procrastination

There are many different ways that you can use to beat procrastination. In fact, whole books have been written about ways to get going. Here are the 5 techniques I use most often to get me going:
podcast

Podcast Episode 83: Retention for Files and Email

Filing papers leads to overwhelmed file drawers unless you purge them regularly. It’s not just papers, though. It’s also all the electronic stuff that you save, both files and emails. It’s easy to tell ourselves it doesn’t matter because of essentially unlimited mailbox and disk drive sizes. However, the more we shove into a cabinet, be it real or virtual, without ever cleaning it out, the easier it becomes to lose things and spend hours trying to find the information. In Episode 83 we will talk about the need for retention policies - and some ideas on how to implement them.
Simplified Tickler Files

Simplified Tickler Files

A tickler file is one to manage date-sensitive information. It can be implemented for paper or electronic, and the classic version contains 43 folders. This can be overly burdensome, though, if you don't deal with a lot of date-sensitive material. Today's article is about simplifying the classic approach to ticklers.
podcast

Podcast Episode 82: Out of Sight, Out Of Mind

My mother had a saying: “Out of sight, out of mind.” In spite of her being a supremely organized person, her belief in out of sight out of mind led to piles of paper on her kitchen counter, desk and other places in her house. I also have a tendency to pile things in order to keep them on the front of my mind. This indicates a breakdown of my systems. And on the flip side, once things are in my trusted system, I have a tendency to ignore them if they are not right in front of my face. . In today’s podcast, Episode 82, I will address both sides of this concept.