In the 2000's, EMAGENIT has taught Excel VBA for Mac for Apple corporation and designed Excel VBA software for them.
In the 2000's, EMAGENIT has taught the 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.
In the 2000's, EMAGENIT taught Excel VBA for Mac for NASA and designed software for NASA that works in Excel for Mac. One of our Excel for Mac software projects for NASA was designing conceptual software for the Mars Rover.
To say that NASA is a 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.
Since 1998, EMAGENIT has been providing Excel for Mac training. We cover from Excel basic topics to the most advanced data processing, dashboard, modeling and Excel VBA topics.
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, online courses and Onsite.
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.
Since 1998, EMAGENIT has been providing Excel VBA for Mac training. We cover from the VBA programming basics to the most advanced data processing, dashboard and modeling Excel VBA topics including how to use the 2016 Excel VBA Editor effectively.
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 finally upgraded its Excel VBA Editor. This means you now have the debugging tools used in Excel for Windows.
One More Thing. If you can, it is highly recommended that you keep or get Excel for Mac 2011 on your computer if developing userforms . Different Excel for Mac versions can exist on the same computer as EMAGENIT does just that. The concept is to develop userforms in 2011 and then run the code in Excel for Mac 2016.
When we are running our public training workshops and live online courses, 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.