Hi everyone!
I know the the basics when it comes to Excel, but what areas of expertise would I need to learn if I want to create a personalized stock screener or stock tracker that can display all the up to date data automatically or with a simple click of a button?
An excel sheet that...
so i just finished the lesson from excel school's for sumproduct. in it it says that sumproduct is used instead of sumif in their example because sumif only allows 1 criteria... hence its limitation... but isn't there why there's sumifs? which allows multiple criterias?
so instead of using...
have you taken the courses offered at excel hero academy? they seem remarkable.
but such a difference in price between the enrollment for the regular program and the program that allows you for downloads :
I'm thinking of switching my career from technology to Finance and am purusing for a job as a financialy analyst. was wondering if any of you are in this particular industry, and if so, could you shed some light as to what areas of excel is most important for the job? and what resoruces would...
Excel is so vast and is something that takes a lifetime to master. I know that the courses here at chandoo seem to cover a lot of the major areas that are commonly used for the regular users..things like pivot tables and such. But does the course here go in-depth on these topics? Or just teach...
Which version do you guys use? and which version does the VBA school here teaches?
From what i found online through googling, it seems that most people agreed that while VB 6 has mroe resources online for learning since it's been around from 1998, but most believe that Visual basics 2010 is...