Excel. yo
Looking into a new jarb, it's in an office and I'd be using Excel 2007, doing pivot tables and Vlookups for a few examples.
However, I know nothing at all about Excel. Is it difficult to pick up and learn? I'm curious if I can teach myself or I should go to a class. Either way, how long typically does it take to learn? I'm a sharp dude when it comes to using computers, I just haven't used excel. Please, and thank you guys. 
Re: Excel. yo
Quote:
pretty stupid question for a sharp dude lol the answer is obviously: it depends ;) but seriously: the microsoft online support is phenomenal. If you're not under much time pressure you'll find everything you need online. 
Re: Excel. yo
Pivot tables and Vlookups are relatively easy.
You can look on the microsoft website for quick tutorials, or you can look on youtube, there are a bunch of videos there, that's how I learned. I'm on Excel 2013 now, it's really clean. 
Re: Excel. yo
For a basic vlookup for just one worksheet, click on a cell where you want your answer and plug in this equation:
=VLOOKUP(C26,C6:J21,8,FALSE) C26 is the cell where you will be "searching", like google. C6:J21 is the square of data that you will be searching. 8 is the column that your answer is going to come from, 8 means 8th column from the first column of your square of data, going left to right. FALSE means that it will show an exact match to your search, if you put TRUE or you don't put anything, it will give you an exact match or the next largest value. Obviously your numbers will be different but that's the basic layout. 
Re: Excel. yo
None of the basic functionality of Excel is particularly difficult, but how difficult working with Excel is depends mostly on the complexity and variety of the data you are going to be using.
If using Excel is an integral part of your job and you've never used it before people are definitely going to notice right away. 
Re: Excel. yo
Excel 2010 or whatever the newest version is so much better. It's best to learn this by looking at an example excel file and looking at the equation (like the VLOOKUP) and seeing how it applies and looking at the cells. If you're sharp, it should be easy to pick up.

Re: Excel. yo
when it comes to sex, i excel....
anyway, i laugh at companies who still use excel. store your data in sql server and the value of your data will increase 10 fold 
Re: Excel. yo
Quote:
Pretty much but Excel is nice for extracting small amounts of data for analysis, reports, etc. 
Re: Excel. yo
Quote:
The two aren't exclusive. You can pull data from another source (database/file/etc) into excel to manage and search it. 
Re: Excel. yo
Quote:
Exactly, how else would you distribute date throughout your organization? How would you organize your data to load up into your SQL database in the first place? Where I work this has to happen routinely. 
Re: Excel. yo
If you cant pickup and learn excel relatively fast.. you might be missing some important brain functioning. You should be able to learn vlookup and pivot tables in 1 day using the internet. Im not saying youll master them but youll understand what it does.

Re: Excel. yo
The basic functionality is easy to learn. Learning how to pick up on patterns and use the functions efficiently takes more time to get good at.

Re: Excel. yo

Re: Excel. yo
Quote:
sql server, mysql or even access is capable of the same thing, and more. the benefit of it is that everyone will be using the same datasource so quality of the data isnt using some silly honor code 
Re: Excel. yo
Quote:
You obviously don't understand the value of Excel (esp w/2013) as a BI tool. 
All times are GMT 4. The time now is 10:38 AM. 
Powered by vBulletin Version 3.5.4
Copyright ©2000  2015, Jelsoft Enterprises Ltd. Terms of Use/Service  Privacy Policy