Excel - MMA Forum - UFC Forums - UFC Results - MMA Videos
 
LinkBack Thread Tools Display Modes
post #1 of 5 (permalink) Old 02-10-2013, 01:20 PM Thread Starter
M_D
Homicidal Maniac
 
M_D's Avatar
 
Join Date: Apr 2007
Location: Houston, Texas
Posts: 6,187
Blog Entries: 1
                     
Excel

Ok at work they have dubbed me the computer guy which is weird cause i am only mediocre compared to most the people i know but oh well

ive basically become they guy that does all the reporting for our campaign as well as fix all our computers and software issues ect.. (yeah im a little over my head but most stuff i can mess with and fix pretty easily)

ok to get to the point since i am using excel on a daily basis i have grown to really enjoy it and would like to learn some more advanced stuff on it and was wondering if there is any books i should check out for it or videos i could watch ect.. I am already impressing my boss's with the reports im doing now but i want to wow them for there is gunna be a promotion opening here pretty soon



Over! 2,000,000 Views!

P4P Best Fighter
Angely Lane
M_D is offline  
Sponsored Links
Advertisement
 
post #2 of 5 (permalink) Old 02-11-2013, 04:56 AM
MMA Fanatic
 
Join Date: Feb 2013
Posts: 4
                     
Here are some tips from an Excel guru.

I started my career in accounting and eventually ended up in IT then in management consulting. A big part of my success is attributed to my Excel skills. Being able to handle a large amount of information and translating it to useable data for decision making and action is the skill that you should be aiming for.

Here are some tips:

1. Speed - You should memorize the shortcut keys for common tasks you do in your role. You should never be using the mouse to do simple things like activating pivot tables, auto sizing columns, adding/deleting (rows, columns, sheets), selecting ranges, flying to the end of the range etc.... To develop your skill with short cut keys, stop using a mouse for one week, or even one month. You will be forced to learn all short cut keys, without a mouse. It's actually possible to use ms excel without a mouse. After this excercise, you will look like a guru when people see you use ms excel. It should look like you are playing the piano when analyzing your next spreadsheet!

2. Pivot Tables - MS Excel's most powerful feature is pivot tables. Analyzing data that comes from a database in order to illustrate it in visuals or to group by using meaningful headings to provide insight is what makes it so powerful. Google "pivot tables" to learn more.

3. VLOOKUP formula - This is my most favorite formula and has saved me soo much work from manually doing comparisons. Again google this and learn it.

Good luck in your Excel career !


Quote:
Originally Posted by M_D View Post
Ok at work they have dubbed me the computer guy which is weird cause i am only mediocre compared to most the people i know but oh well

ive basically become they guy that does all the reporting for our campaign as well as fix all our computers and software issues ect.. (yeah im a little over my head but most stuff i can mess with and fix pretty easily)

ok to get to the point since i am using excel on a daily basis i have grown to really enjoy it and would like to learn some more advanced stuff on it and was wondering if there is any books i should check out for it or videos i could watch ect.. I am already impressing my boss's with the reports im doing now but i want to wow them for there is gunna be a promotion opening here pretty soon
AlphaDAD is offline  
post #3 of 5 (permalink) Old 02-11-2013, 09:15 AM
-DayDay Knucks-
 
HitOrGetHit's Avatar
 
Join Date: Jun 2009
Posts: 19,917
Blog Entries: 13
                     
There are Microsoft Office books. They are pretty large and contain information about all of the office software. I used one for a computer class I took in the past. It has some fancy things in it but may not dive as deep since it covers everything and not just excel.


-Always Supporting-
Urijah Faber - Dustin Poirier - Frankie Edgar - Demian Maia - Miesha Tate - Claudia Gadelha - Jessica Eye - Tecia Torres

Come watch me make a fool of myself on YouTube
HitOrGetHit is offline  
post #4 of 5 (permalink) Old 02-11-2013, 12:05 PM
BEWARE OF THE PENGUIN!
 
No_Mercy's Avatar
 
Join Date: Oct 2006
Posts: 11,921
                     
Quote:
Originally Posted by AlphaDAD View Post
I started my career in accounting and eventually ended up in IT then in management consulting. A big part of my success is attributed to my Excel skills. Being able to handle a large amount of information and translating it to useable data for decision making and action is the skill that you should be aiming for.

Here are some tips:

1. Speed - You should memorize the shortcut keys for common tasks you do in your role. You should never be using the mouse to do simple things like activating pivot tables, auto sizing columns, adding/deleting (rows, columns, sheets), selecting ranges, flying to the end of the range etc.... To develop your skill with short cut keys, stop using a mouse for one week, or even one month. You will be forced to learn all short cut keys, without a mouse. It's actually possible to use ms excel without a mouse. After this excercise, you will look like a guru when people see you use ms excel. It should look like you are playing the piano when analyzing your next spreadsheet!

2. Pivot Tables - MS Excel's most powerful feature is pivot tables. Analyzing data that comes from a database in order to illustrate it in visuals or to group by using meaningful headings to provide insight is what makes it so powerful. Google "pivot tables" to learn more.

3. VLOOKUP formula - This is my most favorite formula and has saved me soo much work from manually doing comparisons. Again google this and learn it.

Good luck in your Excel career !
Pivot tables!

I use Excel all the time for financial spreadsheets and data mining, but everything is customized for me since I'm computer illiterate.

Marcus Aurelius: Tell me again, Maximus, why are we here?
Maximus: For the glory of the Empire, sire.

Baked, not fried... the healthy choice.

No_Mercy is offline  
post #5 of 5 (permalink) Old 02-11-2013, 12:35 PM Thread Starter
M_D
Homicidal Maniac
 
M_D's Avatar
 
Join Date: Apr 2007
Location: Houston, Texas
Posts: 6,187
Blog Entries: 1
                     
Quote:
Originally Posted by AlphaDAD View Post
I started my career in accounting and eventually ended up in IT then in management consulting. A big part of my success is attributed to my Excel skills. Being able to handle a large amount of information and translating it to useable data for decision making and action is the skill that you should be aiming for.

Here are some tips:

1. Speed - You should memorize the shortcut keys for common tasks you do in your role. You should never be using the mouse to do simple things like activating pivot tables, auto sizing columns, adding/deleting (rows, columns, sheets), selecting ranges, flying to the end of the range etc.... To develop your skill with short cut keys, stop using a mouse for one week, or even one month. You will be forced to learn all short cut keys, without a mouse. It's actually possible to use ms excel without a mouse. After this excercise, you will look like a guru when people see you use ms excel. It should look like you are playing the piano when analyzing your next spreadsheet!

2. Pivot Tables - MS Excel's most powerful feature is pivot tables. Analyzing data that comes from a database in order to illustrate it in visuals or to group by using meaningful headings to provide insight is what makes it so powerful. Google "pivot tables" to learn more.

3. VLOOKUP formula - This is my most favorite formula and has saved me soo much work from manually doing comparisons. Again google this and learn it.

Good luck in your Excel career !
thank you and shall try these out



Over! 2,000,000 Views!

P4P Best Fighter
Angely Lane
M_D is offline  
Reply

Quick Reply
Message:
Options

Register Now



In order to be able to post messages on the MMA Forum - UFC Forums - UFC Results - MMA Videos forums, you must first register.
Please enter your desired user name, your email address and other required details in the form below.

User Name:
Password
Please enter a password for your user account. Note that passwords are case-sensitive.

Password:


Confirm Password:
Email Address
Please enter a valid email address for yourself.

Email Address:
OR

Log-in









Human Verification

In order to verify that you are a human and not a spam bot, please enter the answer into the following box below based on the instructions contained in the graphic.




Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
 
Thread Tools
Show Printable Version Show Printable Version
Email this Page Email this Page
Display Modes
Linear Mode Linear Mode



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

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are Off
Pingbacks are Off
Refbacks are On

 
For the best viewing experience please update your browser to Google Chrome