(Founder, ExcelUser) Sep 11, 2013 Although I haven't used Excel on a Mac for years, I think you should be fine with Mac Excel. First, I sell some fairly advanced Excel dashboard templates, and also an ebook about how to create Excel dashboards. I've sold a lot of them, in nearly every country in the world. But I've.never. had a request for a refund from a Mac user because my products didn't work on a Mac. Because of this experience, I feel safe in saying that virtually anything I can do in Excel worksheets on a PC others can do in Excel worksheets on a Mac.
![Best Book To Learn Excel For Mac Best Book To Learn Excel For Mac](/uploads/1/2/5/5/125558760/906818579.png)
If you’re a Mac owner, this might be the best book writing software for you. While you do have to pay $39.99 per year to use it, the cost to use Ulysses is completely justified. One of the best features has to be the distraction-free capabilities.
(However, there.might. be some minor inconsistencies with VBA between PCs and the Mac because of differences in the two operating systems. Dunno.) Second, I have a friend who's a very opinionated Excel MVP. He purchased a Mac about six months ago so he could better support a client. If he had found inconsistencies between PC and Mac Excel, he would have whined about them in our private Excel MVP forum. But he's not written a word along those lines. Hope that helps.
(CFO, Solstice Mobile) Sep 11, 2013 I made the switch from PC to Mac about a year ago and although there are some nuances to running Excel on the Mac verse a PC, you will get used to it once you learn the shortcuts as you probably use on the PC. Keep in mind if you are using any current features in the latest version of Excel for Windows that they might not be available on the Mac since they seem to be a version or two behind but I haven't hit a snag yet. The overall reason why I like the Mac now is that it's just a more intuitive system and things seem to just work! (Consultant, Independent Advisory Services) Sep 11, 2013 I've been using Excel on Mac for years. The main lack I find is the absence of the statistical analysis tools (analysis toolpack, as I recall).
These can be had through third-party add-ins or separate tools. They were good, usable, and quick but not great in regular Excel. Otherwise, I have not found anything lacking that made me feel like I had a lesser version of Excel.
I made the switch to Mac purely for productivity reasons. I needed to spend less time working on computer problems and more time using the tools for actual work. The productivity gain was SO much more than I expected. (Treasurer and Board Member, Partners in Performance Excellence (PiPEX)) Nov 1, 2013 I've been using Excel on a Mac for several years (actually since 1984 when it was called MS Chart) and find it very capable as a replacement for Excel on a Windows computer. That said, another way to go would be to run Windows via Boot Camp (or Fusion or Parallels) and use MS Office there if you have other apps that require Windows.
I have been using Boot Camp with Windows 7 Pro on a MacBookPro 2008 variety and, up onto the Intel Sandy Bridge/Haswell processors, it has been my fastest PC using Office. (Director, Strategize Financial Modelling Inc) Nov 1, 2013 I was faced with this challenge over the summer.
I am a MS Excel user, whilst my client's executives & personnel were all on Excel for Mac. Given the nature of the financial model mandate for the client, I was forced to customize the spreadsheet via VBA macros, in order to patch up certain MS Excel features that currently don't exist on Excel for Mac.
I documented my experiences via a blog 'Financial modelling techniques between Microsoft Excel and Excel for Mac' on my website. The features to watch out for were namely: ● ActiveX macros won’t work on a Mac ● Data Analysis Toolpak is not officially supported currently ● Inserting Adobe Objects in Excel for Mac does not exist currently, and ● Referencing the User Name property in VBA script won't work either. (President, Infiniti Films, Inc.) Jun 30, 2014 I was originally a Mac user (Mac IIfx with a blazingly fast 33 mhz processor). Switched to Windows in the early 1990's because the Mac and Windows command structures weren't the same which meant that, for instance, print macros created in Mac Excel wouldn't work when I sent the tile to a Windows based client. However, I was spending far too much time in compeer hell working on Windows IT issues, so when the Intel based Mac's came out, I switched to a Macbook Pro and ran Windows through Parallels. It works perfectly.
When I need to use Excel or Quicken, I switch to Windows. Everything I do that is internet related I do on the Mac side (reducing if not eliminating the virus issues that were such a time suck-even with the best anti-virus software installed).
The will get you started with Excel fundamentals. Even though it is a basic skills course you’ll still master many skills that professional Excel users are unable to use. It is available entirely free as an e-book. The Basic Skills course contains the first 43 lessons from the and will take most users 5 hours or less to complete. Smart Method books are the only books that have a for every lesson that can be viewed online. If you have difficulty completing a lesson in the book (or e-book) you can watch the corresponding video walk-through to identify where you are going wrong. If you need Excel skills to get a job you should begin with this course ( it also includes all of the Basic Skills material). Even if you’ve never used Excel before you’ll have no difficulty completing this course, most learners can complete it in two days or less.
The will give you all the skills an employer would expect. By the end of the Essential Skills course your Excel skills will be better than most office workers. Smart Method books are the only books that have a for every lesson that can be viewed online. You can learn just as much as you need The may be all you need but if you decide to further expand your Excel education you’ll be able to use the other books in this series to master even the most advanced Excel features. If you need Excel skills to get a job you should begin with the course (it includes all of the Basic Skills material) to reach a high level of Excel proficiency. If you’re already an accomplished Excel user check out the to discover advanced skills that are rarely mastered (even by Excel power users). Learning by doing, An alternative approach to learning and applying Excel skills For over 900 years craftsmen have traditionally taught their skills to an apprentice.
In this model the apprentice learned his trade by observing how the master craftsman used his skills. This construction kit will teach you advanced Excel skills in the same way. Even if you only have basic Excel skills, the construction kit is designed in such a way that you’ll be able to construct a complex, polished professional Excel application that would be well beyond the powers of most advanced Excel users. Free Excel Challenges.
Test your Excel skill level with a selection of real-world business assignments Our Basic, Essential and Expert tutorials all include an exercise at the end of each session. Excel Challenges go beyond simple exercises. Each challenge presents a common business problem that can be solved using Excel skills. Challenges are graded as Basic, Essential and Expert. If you have completed the relevant Excel tutorial you should have no difficulty completing each assignment. Challenges are presented completely FREE in both video and written (printable) format.
This makes them ideal for both self-learners and for teachers to use in a classroom setting. Each challenge also has a solution video that walks you through a guided step-by-step solution. If you are unsure of your current skill level our challenges can help you to establish your existing Excel skill level ( Basic, Essential or Expert).