Help With Learning MS Excel For Plotting Reloading Data

[Timon]

So, for a number of years now, I’ve wanted to learn Excel, to be able to plot my reloading data.

I have absolutely no expierence with the program, I’m old and really not a tech wizard. Was wondering, if anyone who was a beginner with Excel, found any particular book, or video series, or whatever that helped you learn Excel from scratch. A book, program, or video series, that you can say really helped you learn the software from nothing.

Thanks so much folks.

Scott

 

[rwj]

Check for courses at your local community college (“hands on learning” is best IMHO). If inconvenient, try the “Excel for Dummies” handbook.

 

[Timon]

Thanks, I agree with you about “hands on” learning, I’ll check the community college near me.

Thanks again

 

[docmusk19]

I am happy to help with this. There is no reason to pay for anything, especially a community college course. You can find basic and advanced excel info with a simple google search of what you’re trying to do.

“Find average of data set in excel”
“Average a column or row in excel”
“How to calculate standard deviation in excel”


It all takes practice! If you have questions, give me a call 419-310-2441. If I don’t answer, leave me a message and I will call you back!

 

[Timon]

I am happy to help with this. There is no reason to pay for anything, especially a community college course. You can find basic and advanced excel info with a simple google search of what you’re trying to do.

“Find average of data set in excel”
“Average a column or row in excel”
“How to calculate standard deviation in excel”


It all takes practice! If you have questions, give me a call 419-310-2441. If I don’t answer, leave me a message and I will call you back!

Thank you so much!

 

[docmusk19]

Thank you so much!

Absolutely! The greatest excel wizards I have come across have always been self taught.

Reloading data is pretty basic. You could be up in running in an afternoon!

 

[3Ackleys]

Had a 2 day class for work, about 10 years ago. Instructor told us the then current version of Excel had 16 software engineers develop it, and not one of the individuals new ALL of excel.
My wife is very proficient so she is me mentor now.

 

[BigBolt]

So, for a number of years now, I’ve wanted to learn Excel, to be able to plot my reloading data.

I have absolutely no expierence with the program, I’m old and really not a tech wizard. Was wondering, if anyone who was a beginner with Excel, found any particular book, or video series, or whatever that helped you learn Excel from scratch. A book, program, or video series, that you can say really helped you learn the software from nothing.

Thanks so much folks.

Scott

I did one for cost savings of reloading. Send me a PM of what you need as far as inventory and maybe I can make one for you. I am an old guy too but have dicking with computers since 1980 and use to write code when C+ first came out.

 

[Timon]

I did one for cost savings of reloading. Send me a PM of what you need as far as inventory and maybe I can make one for you. I am an old guy too but have dicking with computers since 1980 and use to write code when C+ first came out.

Thanks, at this very moment I don’t have any data, I have to do the testing. Since I’m down with pneumonia at the moment, I thought that I might use this time to learn it a bit.

Thanks so much for your offer though.

Scott

 

[Shooter13]

Check for courses at your local community college (“hands on learning” is best IMHO). If inconvenient, try the “Excel for Dummies” handbook.

Don't buy the book, go to the library and check it out!

 

[jepp2]

to be able to plot my reloading data.

If you are more specific about exactly what you intend to use Excel for, post what you want and probably someone has already created something close enough to start with.

I use Excel to record my loads, and the results. I also use it for calculating ES and SD from my chrono (since when shooting round robin I can't use the chrono to calculate it for me). Just examples.

 

[rebeltex]

I made this one, still adding things to it.
Everyone is welcome to Use it if you like or at least it might spark some ideas.

 

[CharlieNC]

YouTube. I don't have a particular series in mind but you can learn everything there.

 

[Timon]

If you are more specific about exactly what you intend to use Excel for, post what you want and probably someone has already created something close enough to start with.

I use Excel to record my loads, and the results. I also use it for calculating ES and SD from my chrono (since when shooting round robin I can't use the chrono to calculate it for me). Just examples.

View attachment 1441767View attachment 1441768

You are probably right. What I’m looking for are simple line graphs for my testing dealing with seating depth, or powder. Perhaps velocity on the y axis, then powder load, or seating depth, along the x axis. Very basic. I just want to be able to look graphs for possible nodes and just general examination of how a load, or seating depth affects my velocity. Is this something that you might have done in the past?

Thanks

Scott

 

[Timon]

If you are more specific about exactly what you intend to use Excel for, post what you want and probably someone has already created something close enough to start with.

I use Excel to record my loads, and the results. I also use it for calculating ES and SD from my chrono (since when shooting round robin I can't use the chrono to calculate it for me). Just examples.

View attachment 1441767View attachment 1441768

This charting of information is really great!

 

[Timon]

Find a format that suits your general purpose, trying to learn Exel and create a usable format at the same time could be overwhelming.

Thanks

 

[Timon]

I found a little app called “Chartistic” that may do what I need, as it’s really not a whole lot. I’m kind of playing around with it now, seems very easy to use.

 

[CharlieNC]

One of the Youtube vids

 

[Timon]

One of the Youtube vids

Thanks Charlie, I actually started to play this last night, to see how it was. It seemed pretty good.

Thanks for the info though!

 

[jepp2]

Is this something that you might have done in the past?

I have much more expertise with MS Word than I do Excel. But creating graphs is very straightforward. If you list a data set you would like graphed, someone should be able to create the graph and you could just update the input variables for your different needs.