Sunil has the following spreadsheet that contains information about the productivity of 25 employees of his company from various branches across India. What is a Pivot Table? A pivot table is a summarized and consolidated table that contains complex data from all over the sheet and workbook. It doesn’t change any of the values in …
Pivot Tables in Microsoft Excel – Free Excel Tutorials Read More »
Abhi has inserted a shape in his Excel Sheet. Now that he has done that, the ‘Drawing Tools’ will open on the ribbon to format the picture. In this module we will look at how he can change the shape outline to suit his need. This option can be found in the ‘Shape Styles’ group …
Daya has inserted a picture in her Excel Sheet. She wants to bring some corrections to it to make it look more synchronized with the sheet. These are the options available to her: Sharpen/Soften Brightness/Contrast Sharpen/Soften Sharpening an image increases the detailing and specifications of it to more clarity. Softening an image, on the contrary, …
Picture Tools: Corrections to an Inserted Picture in Excel Read More »
Functions are the most useful elements of Excel. These are predefined formulas that one may use for one’s easy calculations. Two important text formulas amongst these are ‘LEN’ and ‘TRIM’. ‘LEN’ and ‘TRIM’ – LEN Function This function can be used to detect the length of a string of characters. This maybe numbers, dates or …
Dron is using an Excel sheet to compute a mathematical table. He has to do some calculations using formulas of Excel. As he is doing this, he comes across the option ‘Watch Window’. He doesn’t know what it does and wonders if it maybe useful to him. His friend Sheetal explains to him what this …