The spreadsheet is pined to the top of the New Mystery Shopper page, it is the 3rd post down. I downloaded that right when I started it's posted by Mert credited to Flash. It's an awesome spreadsheet that has some formulas built in so as you enter new shops it starts adding in the totals for you. So you can see to date how much you have in fees, reimbursements etc...
Lorrie, I'm fairly new to the whole MS online system too, and trust me it's super confusing when all these companies are shopping the same clients, I was confused and then different companies are moving to different systems. I was signed up with Goodwin under the Sassie system, then people were talking about it in prophet system, so I thought for sure it's a different company, it's the same company but they have different jobs under two different systems, I guess they are slowly moving over yes totally confused me, I signed up again under the prophet system before I figured that out and got another welcome email different login.
I'm not super proficient on Excel but can do the basic stuff, I do have to say it's very easy to put everything on the spreadsheet. I started to even put jobs that I requested in there too and if I don't get assigned that job, I move it to the bottom of the sheet and that way I can see if there is a pattern for certain jobs maybe? Also with a spreadsheet it is easy to change stuff vs on paper, you are crossing it out and re-writing etc.
Then you can sort all the jobs by due date so you can see everything that way, and when you need to figure out payment you can then sort by MSC.
I feel like now you can learn everything online, from baking a souffle, to changing oil on your car, to fancy reverse french braiding your kid's hair. I'm sure there is an easy Youtube video on how to learn basic excel. Since Flash has already created all the formulas you don't even need to do that. It does the summation for you. Also, in my area, sometimes the libraries offer basic computer classes too.
Good luck!