Proficient in Excel - Next step?
I've gotten pretty Excel competent over the last few months and am now considering allocating some of my daily "Excel time" to another piece of software. Learning R sounds pretty compelling, but I'm thinking that, after only 50 hours of experience, I won't be confident enough in my R-derived conclusions to share them. Am I wrong to think that beginner R knowledge would be squandered as an analyst?
If not, what other piece of software would be useful to learn (besides my becoming quicker in Excel and PPT)?
Alternatively, can experienced monkeys recommend books on Excel-based analysis along the lines of "Data Smart"? Thanks as always.
what are you focused/interested in? when you say "competent" in excel, does that include VBA? I personally love R, but unless you are doing very math/stat heavy work it probably is not the most valuable.
if you don't use VBA, start there. Object oriented and will give you a good foundation and since you're using excel it will be instantly applicable. In my opinion, if you are new focus more on understanding concepts. This will pay dividends long-term and will make you far more efficient when learning something new, even R. Using excel is far different from coding.
All that said, learning R can be a game changer. For instance, multivariate reg loops in excel can be annoying without add-ins or heavy coding. What would take me 30 minutes in excel I can do in 2 minutes in R. Plus, R is becoming more widely used in finance so good on a resume. RStudio is awesome.
There are tons of great books for excel/vba and R. most of which you can easily find online (for free if you must). You can check out, Financial Analysis and Modeling Using Excel and VBA, Benninga's books, etc.
Illo inventore tenetur eveniet qui illum ut. Et tenetur praesentium dolor facilis animi corporis. Et quidem non aut dignissimos aut. Fuga quo aliquam dignissimos possimus doloremque autem ipsam suscipit. Porro voluptatum minus sint reiciendis.
Aliquid provident laudantium molestiae et sed. Quae illum voluptas ea voluptas eos molestiae ut. Beatae fugit autem quia. Nihil laboriosam nulla quos accusamus expedita. Suscipit ducimus dignissimos et quia ipsum rerum qui. Aliquid id rerum pariatur corrupti omnis.
See All Comments - 100% Free
WSO depends on everyone being able to pitch in when they know something. Unlock with your email and get bonus: 6 financial modeling lessons free ($199 value)
or Unlock with your social account...