Microsoft Excel for Mac and Microsoft Excel VBA for Mac
Business, Engineers and Scientists
In the 2000's, EMAGENIT had the privilege of teaching Apple corporation on several occasions at their Cupertino, CA campus. EMAGENIT supplied both Microsoft Excel and Microsoft Excel VBA training on the Mac for Apple staff. EMAGENIT has also designed Microsoft Excel VBA software for Apple corporation that works on the Mac and in Windows. Our training with Apple as well as our software development for them has helped us develop useful Excel strategies and methods for the Mac that will help you accomplish your tasks.
To say that NASA is a heavy user of the Mac is a colossal understatement. Over the course of 20 years, EMAGENIT has had the privilege of both training NASA personnel on how to use Excel VBA on the Mac as well as develop Excel VBA software on the Mac for them. In particular, EMAGENIT along with its NASA counterparts, helped design conceptual software for the Mars Rovers that had to work both in Excel for Windows as well as Excel for Mac. You can read more about our NASA Mars Rover project here. Our design experiences on that project as well as our other NASA training ventures have helped us with the practical applications of using Excel for Mac in the science and engineering fields.
What Do We Consider Microsoft Excel Training in the Mac? We consider our Microsoft Excel training for the Mac to be everything that does not relate to Excel VBA macros. We cover from beginning to advanced Excel topics in the Mac. We cover the Mac in our public seminars, webinars and onsites.
In our Excel for Mac training, we discuss in detail the strategies and methods that you need to know to push the Mac to its fullest non-macro capabilities. We also discuss the Excel quirks along the way that stop you dead in your tracks and the work arounds.
You will also notice that in addition to just Excel topics, our training also has different themes depending upon the level. These themes are what we have found people most commonly seek when attending those training levels. And as always, all of our training is hands-on with the focus on your Mac problems. Below is a brief introduction to some of our favorite Mac topics and some of the levels we teach.
Beginning Excel Training for the Mac. In our beginning Excel training level, we explain the basics of what you need to operate Excel for Mac in an office setting. We focus on essential topics like:
For more information about our Beginning Excel Training for Business Professionals click here. Engineers and scientists are also welcome as the basics discussed apply to everybody.
Intermediate Excel Training for the Mac. In our intermediate Excel training level, we explain in depth how to use Excel for Mac for general modeling and data processing problems. Specifically, we focus on:
For more information about our Intermediate Excel Training for Business Professionals click here. Engineers and scientists are also welcome as the specifics discussed apply to everybody.
Advanced Excel Training for the Mac. In our advanced Excel training level, we focus on how to use Excel for Mac to access and integrate external data, build advanced visual interfaces, perform advanced data processing using array formulas, and build high powered VBA worksheet functions for modeling. Our training specifically focuses on key topics like:
Also in our Excel for Mac training, we cover transferring Excel workbooks between Windows and the Mac and what works and what does not.
What Do We Consider Excel VBA for Mac Training. Our Excel VBA training for the Mac covers how to automate Microsoft Excel using a computer language called VBA or Visual Basic for Applications. VBA is also commonly referred to as just macros.
In our Excel VBA for Mac training, we cover the specific VBA details that are often left out of training along with the programming strategies and methods that will allow you to create polished programs in the Excel for Mac environment. EMAGENIT has helped develop Excel VBA solutions on the Mac for Fortune 500 companies, NASA and Apple itself.
Beginning Excel VBA for Mac. In our beginning Excel VBA training level, we discuss the basics of programming and how to create useful models and data processing tools in Excel VBA for Mac. Specifically, we cover:
Intermediate Excel VBA for Mac. In our intermediate Excel VBA training level, our training covers using Excel VBA for tasks like data fusion, data analysis and creating worksheet based visual displays for data in Excel for Mac. In particular, we focus on:
Advanced Excel VBA for Mac. In our advanced Excel VBA training level, our training covers developing advanced data processing and modeling tools, advanced interfaces using userforms and ActiveX controls, external program control and advanced report generation in Excel VBA for Mac. Our training specifically focuses on:
How We Teach Excel VBA for Mac. No matter how complex the Excel VBA material covered, you will find a thorough easy to follow answer in our training no matter the topic. In our Excel VBA for Mac, we also cover transferring Excel VBA projects between Windows and the Mac and what works in the code and what has to be changed.
A Few Things About Excel VBA for Mac to Know. Please note that the most recent version of Excel for Mac, Excel for Mac 2016, has a very basic Excel VBA Editor in it. What this means is you do not have the fluff as you would in the Windows based VBA debugger. However, contrary to what is being said, all is not lost by any means.
EMAGENIT encounters minimal debugging capabilities and help all the time in mixed language programming and web design and we know a lot of tricks and simple work arounds to help make coding and debugging easier in this type environment .
One More Thing. If you can, it is highly recommended that you keep or get Excel for Mac 2011 on your computer for development and training purposes. Different Excel for Mac versions can exist on the same computer as EMAGENIT does just that. The concept is to develop in 2011 and then run the code in Excel for Mac 2016. Do not stress if you do not have access to 2011, however, we will show you how to get up and running in the 2016 version.
When we are running our public seminars and webinars, we toggle between two computers in class to cover both the Mac and Windows differences where necessary. A lot of times, simple version instruction is sufficient to deal with minor issues. When performing our Excel for Mac training as an onsite, we will exclude the Windows only VBA components from the instruction unless otherwise instructed.