Message Board Basketball Forum - InsideHoops

Message Board Basketball Forum - InsideHoops (http://www.insidehoops.com/forum/index.php)
-   Off the Court Lounge (http://www.insidehoops.com/forum/forumdisplay.php?f=7)
-   -   Excel. yo (http://www.insidehoops.com/forum/showthread.php?t=295740)

Kaspah 04-10-2013 03:15 AM

Excel. yo
 
Looking into a new jarb, it's in an office and I'd be using Excel 2007, doing pivot tables and V-lookups 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.

DonD13 04-10-2013 03:29 AM

Re: Excel. yo
 
Quote:

Originally Posted by Kaspah
Looking into a new jarb, it's in an office and I'd be using Excel 2007, doing pivot tables and V-lookups 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.


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.

lefthook00 04-10-2013 03:36 AM

Re: Excel. yo
 
Pivot tables and V-lookups 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.

lefthook00 04-10-2013 03:46 AM

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.

LJJ 04-10-2013 06:37 AM

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.

Balla_Status 04-10-2013 07:29 AM

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.

sixerfan82 04-10-2013 09:02 AM

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

lefthook00 04-10-2013 12:19 PM

Re: Excel. yo
 
Quote:

Originally Posted by sixerfan82
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


Pretty much but Excel is nice for extracting small amounts of data for analysis, reports, etc.

The Real JW 04-10-2013 12:37 PM

Re: Excel. yo
 
Quote:

Originally Posted by sixerfan82
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


The two aren't exclusive. You can pull data from another source (database/file/etc) into excel to manage and search it.

KevinNYC 04-10-2013 01:46 PM

Re: Excel. yo
 
Quote:

Originally Posted by The Real JW
The two aren't exclusive. You can pull data from another source (database/file/etc) into excel to manage and search it.


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.

OhNoTimNoSho 04-10-2013 04:05 PM

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.

Jailblazers7 04-10-2013 04:09 PM

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.

fiddy 04-10-2013 04:52 PM

Re: Excel. yo
 
http://www.lynda.com/Excel-2010-tuto...h/77968-2.html

sixerfan82 04-10-2013 06:51 PM

Re: Excel. yo
 
Quote:

Originally Posted by lefthook00
Pretty much but Excel is nice for extracting small amounts of data for analysis, reports, etc.


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

Doctor Rivers 04-10-2013 11:22 PM

Re: Excel. yo
 
Quote:

Originally Posted by sixerfan82
anyway, i laugh at companies who still use excel.


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 08:13 PM.

Powered by vBulletin Version 3.5.4
Copyright ©2000 - 2014, Jelsoft Enterprises Ltd. Terms of Use/Service | Privacy Policy