You know you are an Excel guru when ....

You know your an excel Guru when your shirt says

1.Enable Macros
2.Update Links
3.fullscreen
4. you stand up all week at kiosk in a mall creating a spreadsheet for friend your visiting andevenafter he turns in for the day you keep going til 2:00 in the morning.
 

Excel Facts

Easy bullets in Excel
If you have a numeric keypad, press Alt+7 on numeric keypad to type a bullet in Excel.
...Someone asks you how to sum only certain cells in a column and your first thought is how to write an elaborate combination of SUMPRODUCT, MOD, ROW, etc. to accomplish that.

Turns out s/he just meant =sum(select first range, hold CTRL and select second range, hold CTRL and select third range)

Or worse, =A1+A3+A5 :roll: :eek:
 
You know you're an excel Guru when-

-You find yourself going through excel tutorials with a higlighter and a red pen muttering to yourself "That's bad practice" "This would be better this way" "FOOLS!"
-You have to hold back violent urges when your collegues send you yet another piece of code riddled with select statments and ask you why it's running so slowly
-You have written your own addin that automatically applies all the techniques you've picked up to reduce file size bloat
-You opened an excel file in notepad just to see what it looks like
-You got so fed up with no one else using excel properly that you started your own internal company "Excel newsletter"
-You get more "how do I do this in Excel" calls than calls relating to your actual job
-You have ever named a sub any of: routine, marine, or way.
-You know about tools and features of Excel that no one else in the company seems to have heard of and often get asked "How on earth did you do that?"
-You have figured out a way to handle all navigational "buttons" on your workbook with the same single line of code.
-You remember the numbers 256 and 65536 at a seconds notice, but can't remember your lover's birthday.
-You wrote an addin that scheduled a msgbox to remind you of your lover's birthday
-You don't write .End(xlDown) anymore but use .End(-4121) just to confuse people
-You've hit known excel bugs a number of times and keep a note of the important ones on your desk

Hope you like :)
~Shiv
 
You spend more time answerring questions on MrExcel.com than you spend creating Excel Applications.
 
Your a summer intern at your company and you have people comming up to you asking if you can teach them about excel before you go back to school.
 

Forum statistics

Threads
1,222,703
Messages
6,167,743
Members
452,135
Latest member
Lugen

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top