Displaying All Posts tagged with Excel

How Do You Track Deadlines?

Some people keep a giant calendar listing all of their deadlines. Others use online tools like Google Calendar or ReminderFox to keep track of important dates. Whatever your strategy, I think we can all agree that deadlines are pretty darn important.

I use an Excel spreadsheet that lists all my past, current, and future writing assignments. Upcoming deadlines are in green and projects I’ve completed are in black. I reserve red for when checks are overdue, which (knock on wood) doesn’t happen very often. Admittedly, it’s rather low-tech compared to the other options out there, but it works. After all, Excel is pretty versatile.

What about you? How do you ensure that you never miss a deadline? Click Here to Read Article …

Popular search terms for this article:

How to keep track of deadlines, tracking deadlines, keeping track of deadlines, deadline tracking, track deadlines, keep track of deadlines

How to Concatenate Multiple CSV Files in Excel

Do you have a bunch of similarly formatted Excel spreadsheets piling up in your Documents folder? I don’t know about you, but I’d rather see one large worksheet than see the same collection of data spread out over dozens of worksheets. Let’s roll them all up into one. Click Here to Read Article …

Popular search terms for this article:

concatenate excel, concatenate in excel, concatenate csv files, concatenate excel files, concatenate csv, how to concatenate, yhs-geneiotransfer, concat csv files, concatenate files excel, how to concatenate excel files

Excel How-to: Concatenating Cells

Excel is one of the programs that made me want to throw things at Bill Gates but I found ways to make it more usable lest I end up in anger management therapy. Especially if you’re one of us assemblers of lists (guest lists, media lists, potential client lists) you should know for your own good how to combine and separate cell contents.

In this Excel how-to I’m going to teach you how to combine cell contents, which will save you loads of time or at least keep you from traumatizing your interns who enter data manually. I’m using a Mac but the process is the same for PC’s. I hope this article is clear, useful and not too boring. If you have any questions just send me a note!

Click Here to Read Article …

Popular search terms for this article:

excel concatenate cells, excel concatenate, how to concatenate in excel, concatenate cells in excel, how to concatenate cells in excel, excel concatenate cells with comma, concatenate excel cells, concatenation in excel, concatenate excel mac, concatenate cells excel