Excel tutorial tutorialspoint. It has plenty of screenshots that explain how to use a particular feature in a step by step manner. In this tutorial you will learn these pivottable features in detail along wit. At the time of writing this tutorial the microsoft excel version was 2010 for microsoft windows and 2011 for mac os x. This tutorial takes you step by step through the process.
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. Advanced excel is a comprehensive tutorial that provides a good insight into the latest and advanced features available in microsoft excel 2013. Excel pivot tables tutorial pivottable is an extremely powerful tool that you can use to slice and dice data. You can use excel functions to perform various mathematical statistical logical calculations.
This microsoft excel tutorial teaches you how to create and use excel functions. It will help all those readers who use ms excel regularly to analyze data. Microsoft excel is a commercial spreadsheet application written and distributed by microsoft for microsoft windows and mac os x. Microsoft excel is a commercial spreadsheet application written and distributed by microsoft for microsoft windows and mac os x.
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 spreadsheet tool capable of performing calculations analyzing data and integrating information from different programs.