Excel tutorial on tutorialspoint. Microsoft excel is a commercial spreadsheet application written and distributed by microsoft for microsoft windows and mac os x. It will help all those readers who use ms excel regularly to analyze data. This tutorial has been designed for all those readers who depend heavily on ms excel to prepare charts tables and professional reports that involve complex data. An excel macro is an action or a set of actions that you can record give a name save and run as many times as you want and whenever you want.
Macros help you to save time on repetitive tasks involved in data manipulation and data reports that are required to be. Microsoft excel is a commercial spreadsheet application written and distributed by microsoft for microsoft windows and mac os x. Step 2 click customize the ribbon tab and check developer. At the time of writing this tutorial the microsoft excel version was 2010 for microsoft windows and 2011 for mac os x.
In this chapter you will learn how to write a simple macro in a step by step manner. At the time of developing these training modules we have used microsoft excel version 2016. It has plenty of screenshots that explain how to use a particular feature in a step by step manner. Microsoft excel is a commercial spreadsheet application written and distributed by microsoft for microsoft windows and mac os x.
This tutorial has been designed for all those readers who depend heavily on ms excel to prepare charts tables and professional reports. Step 1 first enable developer menu in excel 20xx. Advanced excel is a comprehensive tutorial that provides a good insight into the latest and advanced features available in microsoft excel 2013. To do the same click file options.
At the time of writing this tutorial the microsoft excel version was 2010 for microsoft windows and 2011 for mac os x.