Dev uses the same steps on his Excel sheet repeatedly everyday. Radhika told him that he can record a Macros to make his work easier. We will look at what this means in this article. What is Macros? Macros is a recording of the mouse click s and other actions on an Excel sheet that …
Macros in Microsoft Excel – Free Excel Tutorials Read More »
Rishi has to share a workbook with Sanya. He doesn’t know how to do this and is confused. This module will look at sharing workbooks and how Sanya can work with the workbook he has just shared. Sharing Workbooks -How to Share a Workbook in Excel? To share a workbook, Rishi has to click on …
Sharing Workbooks in MS Excel – Free Excel Tutorials Read More »
Tables are crucial when it comes to dealing with numbers. It is necessary for managing tables once they have been inserted. In this article, we shall look at : Renaming a Table Resizing a Table Removing Duplicates Changing the Table Back to a Range Disha is working with some data for her college and she …
Slicers are advanced filtering features available in Excel which can be used for table and Pivot Table data entries. When you use Slicers, Excel shows you the current filtering in use and filters the values according to the criteria given. In this module, we will look at the following: Creating a Slicer Components of a …
Slicers in Microsoft Excel – Free Excel Tutorials Read More »
While working with Excel, there are a few important functions that everyone needs to know. LEFT, RIGHT and CONCATENATE text functions are amongst these. Let us look at each one of them in detail. Text Functions – LEFTÂ This function can be used to extract three characters from the left of a given string, this …
LEFT, RIGHT and CONCATENATE: Text Functions in MS Excel Read More »