New To Mac-Forums?

Welcome to our community! Join the discussion today by registering your FREE account. If you have any problems with the registration process, please contact us!

Get your questions answered by community gurus • Advice and insight from world-class Apple enthusiasts • Exclusive access to members-only contests, giveaways and deals

Join today!

 
Start a Discussion
 

Mac-Forums Brief

Subscribe to Mac-Forums Brief to receive special offers from Mac-Forums partners and sponsors

Join the conversation RSS
Switcher Hangout The place for switchers to discuss their new machines, and how to work with OS X. General support can be had here for newbie stuff, like "How do I restart my new iMac?" :)

Mac switch feasible? Using the Mac version of Excel for Financial Modeling…


Thread Closed

 
Thread Tools
wrcardon
Guest
 
Posts: n/a

Hi all,

I want to start off by saying that I love Apple’s approach to the computer. There OS and hardware are light years ahead of the Windows and PC solution… in most cases.

However, I use a PC and Excel for financial modeling and spent an afternoon at BestBuy with an Apple rep and came to the conclusion that I could not use the Mac for hardcore financial modeling.

Here was the issue; those of us that do a lot of financial modeling have all the drop down menus memorized. I am not talking about the short-cut key strokes (ctrl+key), but the following: Alt > E > D > R > Enter to get the Edit drop down menu, Delete option, Row Delete. Basically in the PC version you can access the entire drop down menu in this way. As was explain to me be the Apple rep, only the short-cut strokes are available (more can be programmed) and one could not access the drop down menus in the way the PC does.

This may sound like a minor sticking point but when it comes to Financial Modeling you don’t have time to use the mouse a much as the casual user. It seems that MS screwed Mac users when it comes to Excel.

So here is my question, was the Apple rep incorrect or is a Mac not a feasible option for my needs?
StarManta
Guest
 
Posts: n/a

Yes, Macs are still very much in the mindset of "one hand on the keyboard, one on the mouse". A few solutions:
1) If there are shortcuts for the menu functions you use most often, use those. That's a given, but you sounded like you had other functions besides those.
2) For other commands you can get a program called iKey, which you can assign your own hotkey - even application-specific hotkeys - to any menu function. (When I used Mozilla Thunderbird, I assigned Cmd-` to delete mail marked as junk in the folder, for example.)

I'm sure there are other methods and tricks for pulling similar things off... I'll play with it at some point and let you know if I figure anything out.
wrcardon
Guest
 
Posts: n/a

StarManta,

Thanks for the reply.

There are two major problems with trying to assign shortcuts for everything: 1. I need full access to all the drop down menus (yes, I use some commands more than others but with Excel you need your full range of commands), and 2. I would have to rememorize everything anew to my custom configuration. The second is a killer. Portability of my skills from one computer to the next is necessary as we are always loading up a model to fiddle with it on other people computers. If I relearn Excel in the Apple fashion, this would be very counter productive.

Is there anyway to get the alt or Apple key to let you access the drop down menus? This one function on PCs really makes Excel. In the case of the Mac I feel this one application has been a large sticking point for switchers as it is not exactly the same as the PC and needs to be.
StarManta
Guest
 
Posts: n/a

I'll look into it.... I know once you click on a menu you can navigate the menus via arrow keys... not sure. I'll try turning on Full Keyboard Access and see if that helps.
kjellquist
Guest
 
Posts: n/a

uControl is another program you may look at.

For me, I am only using the Mac for work 1 day a week so I went with Virtual PC to get me through those days.

Thread Closed


« transfering from office 2003(pc) - Entourage | Does anyone with iMAC sell items on EBAY? »
Thread Tools

Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
 
Posting Rules
You may not post new threads
You may not 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 On
Pingbacks are On
Refbacks are Off
Forum Jump

Similar Threads
Thread
Thread Starter
Forum
Replies
Last Post
Going to switch. Mac concerns. Temp Apple Desktops 12 12-29-2003 08:37 AM
KVM switch with windows and mac shfoo Apple Desktops 3 10-22-2003 12:51 AM
Mac Users Get More ISP Choices schweb Apple Rumors and Reports 1 03-06-2003 10:57 AM

All times are GMT -4. The time now is 11:40 AM.

Powered by vBulletin
Copyright ©2000 - 2014, Jelsoft Enterprises Ltd.
X

Welcome to Mac-Forums.com

Create your username to jump into the discussion!

New members like you have made this community the ultimate source for your Mac since 2003!


(4 digit year)

Already a member?