The article looks at joining text in multiple cells and columns using concatenate function and other smart ways.
Excel 2007 has come up with several customized features and one of them is Tables. Working with tables has been much more appealing and customized for its users in the newer version. To give you a glimpse, let’s work with a set of values. Enter a few values in an excel sheet as follows
Filling or finding values in a sheet pertaining in a range can be accomplished easily using conditional formatting. The previous post spoke about finding duplicate values in a sheet. This post talks about this topic further.
For those of you who wish to find repeated values in a sheet full of numbers, Using CTRL+f would yield the desired value one at a time and if the sheet is full of data then you are up against some task! To find values simultaneously there is another simple way in Excel 2007- Conditional […]
For those of you who have used MS Excel 2003, the easiest way to creating a series comprising of continuous values would be to enter first two or three values of the series and use the drag handle to fill the remaining values of the series, right?
For all those of you who are used to working with shortcuts in MS-Excel , Office 2007 would appear to be with a little makeover in terms of the shortcuts and layout! Among the more often used shortcuts, some of them have been provided in this post.
Australia beat Sri Lanka and lifted the coveted World Cup, in a rain curtailed match. It rained boundaries and sixes in a match that saw the sheer agression of one man- Adam Gilchrist. His innings, the highest total by an invidual in a world cup final encounter made mince meat of the Lankan bowlers.
Australia lived up to their expectation and defeated a rather innocuous English side with relative ease to maintain their unbeaten record in the tournament. Batting first the English posted a total of 251 at the loss of eight wickets.