Message Board Basketball Forum - InsideHoops

Go Back   Message Board Basketball Forum - InsideHoops > InsideHoops Main Basketball Forums > Off the Court Lounge

Off the Court Lounge Basketball fans talk about everything EXCEPT basketball here

Reply
 
Thread Tools
Old 04-10-2013, 02:15 AM   #1
Kaspah
We hoopin?
 
Kaspah's Avatar
 
Join Date: Feb 2011
Location: Sanctuary
Posts: 3,484
Default 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.
Kaspah is offline   Reply With Quote
Old 04-10-2013, 02:29 AM   #2
DonD13
GYMNAST
 
DonD13's Avatar
 
Join Date: Jul 2010
Location: laboratory
Posts: 9,104
Default 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.
DonD13 is offline   Reply With Quote
Old 04-10-2013, 02:36 AM   #3
lefthook00
College star
 
lefthook00's Avatar
 
Join Date: Aug 2007
Posts: 3,963
Default 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 is offline   Reply With Quote
Old 04-10-2013, 02:46 AM   #4
lefthook00
College star
 
lefthook00's Avatar
 
Join Date: Aug 2007
Posts: 3,963
Default 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.
lefthook00 is offline   Reply With Quote
Old 04-10-2013, 05:37 AM   #5
LJJ
Extra Cheese
 
LJJ's Avatar
 
Join Date: Apr 2007
Posts: 14,443
Default 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.
LJJ is offline   Reply With Quote
Old 04-10-2013, 06:29 AM   #6
Balla_Status
______________________
 
Balla_Status's Avatar
 
Join Date: Dec 2006
Posts: 4,608
Default 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.
Balla_Status is offline   Reply With Quote
Old 04-10-2013, 08:02 AM   #7
sixerfan82
College star
 
Join Date: Dec 2006
Location: south jersey
Posts: 3,882
Default 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
sixerfan82 is offline   Reply With Quote
Old 04-10-2013, 11:19 AM   #8
lefthook00
College star
 
lefthook00's Avatar
 
Join Date: Aug 2007
Posts: 3,963
Default 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.
lefthook00 is offline   Reply With Quote
Old 04-10-2013, 11:37 AM   #9
The Real JW
High School Varsity 6th Man
 
The Real JW's Avatar
 
Join Date: Oct 2011
Location: Canada
Posts: 799
Default 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.
The Real JW is offline   Reply With Quote
Old 04-10-2013, 12:46 PM   #10
KevinNYC
Toronto Mayor Rob Ford
 
Join Date: Dec 2010
Posts: 7,618
Default 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.
KevinNYC is offline   Reply With Quote
Old 04-10-2013, 03:05 PM   #11
OhNoTimNoSho
Your King
 
OhNoTimNoSho's Avatar
 
Join Date: May 2009
Posts: 3,391
Default 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.
OhNoTimNoSho is offline   Reply With Quote
Old 04-10-2013, 03:09 PM   #12
Jailblazers7
will-to-bigness
 
Jailblazers7's Avatar
 
Join Date: Jul 2006
Location: Pittsburgh, PA
Posts: 21,356
Default 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.
Jailblazers7 is offline   Reply With Quote
Old 04-10-2013, 03:52 PM   #13
fiddy
Ariana Army
 
fiddy's Avatar
 
Join Date: Jul 2007
Location: Bulgaria
Posts: 4,913
Default Re: Excel. yo

http://www.lynda.com/Excel-2010-tuto...h/77968-2.html
fiddy is offline   Reply With Quote
Old 04-10-2013, 05:51 PM   #14
sixerfan82
College star
 
Join Date: Dec 2006
Location: south jersey
Posts: 3,882
Default 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
sixerfan82 is offline   Reply With Quote
Old 04-10-2013, 10:22 PM   #15
Doctor Rivers
Decent college freshman
 
Doctor Rivers's Avatar
 
Join Date: Dec 2009
Posts: 2,909
Default 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.
Doctor Rivers is offline   Reply With Quote
This NBA Basketball News Website Sponsored by:
Reply


Thread Tools

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Forum Jump


All times are GMT -4. The time now is 12:54 PM.




NBA Basketball Forum Key Links:
InsideHoops Home
NBA Rumors
Basketball Blog
NBA Daily Recaps
NBA Videos
Fantasy Basketball
NBA Mock Draft
NBA Free Agents
All-Star Weekend
---
High School Basketball
Streetball
---
InsideHoops Twitter
Search Our Site













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