Excel

I see Chris. Thanks.

Lisa, what formula did you use to import your calendar?

"I told myself to quit you; but I don't listen to drunks." -Chris Stapleton

Create an Account or Log In

Membership is free. Simply choose your username, type in your email address, and choose a password. You immediately get full access to the forum.

More About Excel & Spreadsheets

Yikes...you all are blowing my mind with your complex Excel Sheets.....

Since I only shop on a very part time basis, I have one simple Excel sheet....MS Company, Assignment, address, amount reimbursed, fee, Paid, Parking tolls, and date paid. Figured since I started doing the airport circuits that I needed to get a bit more organized with my income.

Since I don't do routes, I can figure out my mileage from the addresses I have and go from there.

Each page of the file is a new month and I try and total everything per month then per quarter.

FWIW, for those that don't want to spend the $$ for MS Office, I downloaded a free Office clone called Libre Office. Its very easy to save in MS Excel format if you need to.

Silver certified (since 2009) and willing to do shops all around the greater Chicago, NW Indiana, and Southern Wisconsin areas (including airports!.

@HonnyBrown wrote:

Tarantado, how do you track narratives?

This depends on the project. These usually have their own workbook / sheets with the spreadsheet customized for it. In some cases, I've save some time plagiarizing old work, then word smithing it enough to be acceptable and not noticeable to the editor. This is typical beneficial for projects you do on a regular basis.

Very infrequently shopping the Greater Denver Area, Colorado Springs and in-between in Colorado these days.

I utilize an Access database I created. Being fully versed with both Excel and Access (I was a programmer in my former career), I find Access much more robust for my purposes. I store receipts, pictures, and reports in the database. I can query the data for just about any question I may have with little to no effort. I've set up different reports where I can view open jobs, unpaid jobs, amount of work generated,etc. I just enter a start and end date and push a button.

Val, I get Microsoft Office Suite through my day job for $10. It includes Access, but I never use it. It's a powerful database software. I'm going to create one for use next year. Thanks!

Thanks for your reply, Tarantado!

"I told myself to quit you; but I don't listen to drunks." -Chris Stapleton

Here's a little shortcut I use when I enter shops on my Excel spreadsheet. Rather than enter today's date, you can just hit the control key and the semi colon key at the same time. Today's date will magically appear!

kenasch, thanks! I am well versed in Excel, and I did not know that. Do you have any more tips?

"I told myself to quit you; but I don't listen to drunks." -Chris Stapleton

@HonnyBrown wrote:

kenasch, thanks! I am well versed in Excel, and I did not know that. Do you have any more tips?

I wish I had more. Maybe someone else on thus forum has a tip or two.

@kenasch wrote:

@HonnyBrown wrote:

kenasch, thanks! I am well versed in Excel, and I did not know that. Do you have any more tips?

I wish I had more. Maybe someone else on thus forum has a tip or two.

Two time savers:

* Ctrl-D to copy Down the contents of the cell above.

* Alt = = enters the @sum() function
[that's hold down the Alt key and hit the = key twice. Or just hit = once to highlight cells manually]

@HonnyBrown wrote:

Val, I get Microsoft Office Suite through my day job for $10. It includes Access, but I never use it. It's a powerful database software. I'm going to create one for use next year. Thanks!

I too am able to purchase through my day job for $10.00. I'm always careful to upgrade whenever the opportunity arises. I had to price the software for a shop the other day and I was happy to know I don't have to pay that price.

Val, I know. Whenever I see the subscription service charge, I'm thinking "no thanks!"

"I told myself to quit you; but I don't listen to drunks." -Chris Stapleton

Bumping for someone

"I told myself to quit you; but I don't listen to drunks." -Chris Stapleton

Sorry, only registered users may post in this forum.

Click here to login

Excel

Create an Account or Log In

Official List of Mystery Shopping Companies

Mystery Shopper Magazine