The article looks at joining text in multiple cells and columns using concatenate function and other smart ways.
Microsoft Excel has numerous functions but the issue is about knowing which function to use in the shortest time We began with a few smart tips in the initial posts which looked at aspects like shortcuts and basic functions in Microsoft Excel 2007. We would continue with the same and gradually address some more text, […]
Vlookup is one function that is widely used across excel users. However, for those who are beginning to use Excel, this post would give a few tips on how to use Vlookup across multiple sheets. So, before we begin, a brief into about what vlookup does.
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 the 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.