I could not get productive graphs and figures using excel software. Is there any alternate software by using it, I may draw useful and attractive figures and Tables.
Matlab (for the production of figures) - together with the article-producing system LaTeX (which can also import figures as well as enable the production of nice-looking tables - is a splendid combination. That's what I use, and it's splendid.
This depends on what you're trying to do. Most basic figures could be drawn with any common software. For example, for a scatterplot with a regression line through it, I could make the same figure (even looking the same, with the same style and everything) in R, MATLAB, Python, or Excel, as long as I spend enough time tweaking the parameters. Some figures may be easier in one than another (for example, R has built-in code for violin plots; in Excel they would be doable but you would have to do a lot of extra work).
There probably are some special kinds of plots that not everything can handle (for instance, I don't know if Excel can make 3D plots). But since your question does not say anything about what kind of figure you're trying to make, I can't give any more specific information.
For a professional layout tables you can use LaTeX, and to generate the graphics you can use gnuplot. The advantage is that both tools are free software. They hope the following links will be helpful
I can't answer whether R "will work out", for the reasons I explained above. It depends on what kind of plot you are making, not on what field you are in.
As for whether R and MATLAB are free, this information is easily found online.
Pretty much all the software mentioned above (including MATLAB and R, which you expressed an interest in) require some knowledge of programming. And in fact in general, pretty much any quantitative science in which you are going to be working with data will probably require some programming. Learning basic programming can probably be considered one of the important parts of your education in biology. Long story short, if you want to to science, you eventually need to learn the tools that are suited for whatever task you're trying to do.
Every software is different, and each one has many resources online, far too many to list here. Once you decide which one to use, you can find all kinds of tutorials, examples, books, etc. My only advice is:
1) Don't be intimidated by it. A lot of people are afraid to start learning any programming language because it sounds like something really hard. It isn't. It's just another tool that can make your life easier, same as any tool.
2) Learn what you need at the time. Some people get afraid to start because it seems like there's so much to learn. But you don't need to learn a whole programming language, you just need to learn how to do the one thing you're trying to do. Need to sort a list of numbers in R, google "R sort numbers". etc.