• Stop being a LURKER - join our dealer community and get involved. Sign up and start a conversation.

Numbers vs Excel

At the dealership, I'm on Excel because everyone else is (and because we had a license I could install on my VM).

At home, I have a copy of Numbers...but even there, I often reach for Excel. (I use a lot of spreadsheets while working with my FIRST Robotics Competition team, most of them created by engineers to help out people with business degrees like me. They, of course, use Excel.)
 
I've tried to use numbers a few time but keep coming back to Excel. I have the latest edition of Mac Office and the new Excel is a nice improvement over the last Mac Office Excel. With that being said, I wish I was half as good on Excel as you are Alex. I'm always saying I'm going to take an advanced Excel class.

Any recommendations?
 
I am a proud owner of the new mac book pro. I installed parallels and installed windows 7 to help me with the switch. I am still learning the mac stuff but really enjoying it so far. The mac app store rocks!

Oh, sorry i have no experience I just thought I would share :)
 
I've tried to use numbers a few time but keep coming back to Excel. I have the latest edition of Mac Office and the new Excel is a nice improvement over the last Mac Office Excel. With that being said, I wish I was half as good on Excel as you are Alex. I'm always saying I'm going to take an advanced Excel class.

Any recommendations?

Yeah, get really creative with payplans and accountability and have an insane obsession with tracking everything. Then you'll eventually get into running macros across tabs and formulas stacking on formulas. It is a deep dark hole kind of like heroine. Eventually you move into Microsoft Access and load things onto a server where it can pull XML/CSV files that automatically populate things into your spreadsheets.

Or you can work with a bunch of guys who can't stand any of the pencil tools on the market and you all figure out ways to turn Excel into a pencil tool that also pulls in vehicle data and bank rates.

Yeah, we got pretty disgusting with Excel at Checkered Flag.

I am a proud owner of the new mac book pro. I installed parallels and installed windows 7 to help me with the switch. I am still learning the mac stuff but really enjoying it so far. The mac app store rocks!

Oh, sorry i have no experience I just thought I would share :)

Awesome :thumbup:

I have three pieces of advice:

  1. Unlearn everything you know about how to use a computer.
  2. When you get stuck trying to figure out how to do something, just say "how would my grandma do it?"
  3. When in doubt, drag and drop.

Microsoft overly-complicated everything.
 
I'm sitting here holding the Hewlett Packard 10B business calculator I bought in 1997 to hand-quote lease and finance payments. Every month we'd have our little cheat-sheet with rates, residuals, money factors and interest rates. I can still give you 3 payment options in less than a minute... 6 if you are looking at lease vs. buy. Neat thought for a string if you haven't already done it: at what point and when did technology become more of a burden than a compliment?
 
@Alex

Wow, if we ever meet, we will get along great. Track everything. Use technology to your advantage.

I always hate sending over an Excel spreadsheet to a numbers/Mac user. As it jacks it all up, simple calcs/formulas are fine, but more complex it has problems with.

Side story - When I was first selling cars, I came up with an excel spreadsheet that would give a purchase payments and lease options to the customer (in a nicely formatted page) - this was the mid-late 90's before eDesking/Compliance. I still don't know if my manager was impressed or pissed - as I was just supposed to be a "car salesman". From that point forward I was the "excel" guy - for all reporting that the DMS could not do. LOL
 
I'm sitting here holding the Hewlett Packard 10B business calculator I bought in 1997 to hand-quote lease and finance payments. Every month we'd have our little cheat-sheet with rates, residuals, money factors and interest rates. I can still give you 3 payment options in less than a minute... 6 if you are looking at lease vs. buy. Neat thought for a string if you haven't already done it: at what point and when did technology become more of a burden than a compliment?

And then you hand write them with the green sharpie right?
 
And then you hand write them with the green sharpie right?

You Damn Skippy we did!

Do you get more from a hand-written note or a crm-generated letter? Think about it...

Another thought starter: has technology added another layer of distrust to the process? Everyone likes to talk about the "transparency" of the internet... Big Buzz Word, very popular right now (like jorts). But with all this information, how much can you really trust? Like True Car -- download 40% of automotive data and display the lowest prices they find. Trustworthy? Really doing the consumer a favor?

I'm advocating for the return of the abacus!