Collaboration is a vital approach to sustain & boost the performance of a team. What else shall be put into practice rather than sharing information through spreadsheets? Though these sheets may be quite quaint, they have indeed lasted the tests of time & continue to stay for a reason – their flexibility. But this very …
Filters or hiding cells serve the purpose when the underlying information belongs to the same category. But for those which have subsets, as in small groups within each larger group, these features provided by MS Excel does not deem to be fit. What else does Excel’s bags of tricks have got to offer on this …
Spreadsheets are created bearing in mind that they would be accessed by a number of people, irrespective of whether it is going to be used in a school or college or any other organization for that matter. With too many people jumping on board it is of utmost importance to guard the credibility of the …
y = mx + c It all started with the above equation, isn’t it? Y – Y-axis value; X – X-axis value; m – slope; c – intercept. Math sought a helping hand from the alphabets & from thereon they became an integral part of the subject. The alphabets got inter-twined so much that their …
The fear of the unknown! We all have it embedded & deeply rooted within us. This fear transcends across every decision we make in our daily routine & thus this applies also to those which we do with the data in MS Excel too. What if I do some modifications & get to a point …
The title column plays an important role in tabulated data. Without those, we would be lost in interpreting what the data in each cell mean. The title column would be at the very left of a tabulation. Not all the contents of the tabulations can be contained in the visible part of the worksheet. There …
The header row plays an important role in tabulated data. Without those, we would be lost in interpreting what the data in each column mean. The header row would be at the very top, in fact, the very first row of a tabulation would mostly be the header row! Not all tabulations can be contained …
MS Excel is all about flexibility. One can add stuff, remove the added stuff, colour things, change the font size or style and the list goes on & on. It is this flexibility that has made MS Excel gain an irreplaceable position amongst the officer goers. In this article, we shall explore how to add …
Little things pester us the most! It’s true in life & likewise with MS Excel too. They stay put, just like a scratch in our spectacles not fully troubling our vision, but big enough to cause some blurry spots. Similar to this scratch in spectacles, there are dotted lines in MS Excel. The MOST DREADED …
Break up! When it is time, the inevitable always happens & we have to part ways. Who is ’we’ you ask? It’s the content within the cells in MS Excel! Not at all those within are meant to be there together. Exampli gratia, a column containing entries of City Name & its Pincode or a …