Want To Build My First Spreadsheet (1 Viewer)

[scrum77]

So I want to start my first spreadsheet. Gonna start small but eventually I want to make it pretty elaborate. I'm tech savvy but not savvy with excel. What excel functions (or whatever) do I need to learn to do this? Are there any tutorials online?

I'd love to hear how you went about making your spreadsheet. What stats/factors do you incorporate? How does yours work?

Thanks.

 

[Scoresman]

Check out this thread for some help.

In terms of excel functions, VLOOKUP will be your best friend.

I also use lots of the string functions like MID, LEFT, RIGHT, etc. mainly because what you're going to find is that a lot of sites that you'll be pasting info from will have players' names listed differently. For example, one site will have Chistopher Ivory, another Chris Ivory, and yet another Ivory, Chris. You need those functions to rearrange them in a standard way.

 

[Maurile Tremblay]

I also use lots of the string functions like MID, LEFT, RIGHT, etc. mainly because what you're going to find is that a lot of sites that you'll be pasting info from will have players' names listed differently. For example, one site will have Chistopher Ivory, another Chris Ivory, and yet another Ivory, Chris. You need those functions to rearrange them in a standard way.

It would be painful to handle this with functions instead of VBA, in my opinion.

 

[Scoresman]

I also use lots of the string functions like MID, LEFT, RIGHT, etc. mainly because what you're going to find is that a lot of sites that you'll be pasting info from will have players' names listed differently. For example, one site will have Chistopher Ivory, another Chris Ivory, and yet another Ivory, Chris. You need those functions to rearrange them in a standard way.

It would be painful to handle this with functions instead of VBA, in my opinion.

Now you're talking beyond my skill set.

 

[SeniorVBDStudent]

Spreadsheet analysis helps focus your thoughts but doesnt tell you when brees and eli are going to combine for 13 tds. Too bad.

 

[QuizGuy66]

Spreadsheet analysis helps focus your thoughts but doesnt tell you when brees and eli are going to combine for 13 tds. Too bad.

Obviously you don't have the module for excel.

-QG