Excel 2007 Training Videos

Microsoft Excel 2007 training videos from Dream Force — online training solutions. Free Excel 2007 tips for Microsoft Excel 2007 users.

Excel 2007

Microsoft 2007 Training Tour:
Web-based Training

RIGHT & SEARCH Functions

What are the RIGHT and SEARCH Functions and how do I used them in Excel 2007? The RIGHT function returns the number of characters at the end of the text or data with in the cell. The SEARCH function will return a calculated number, which if used with the RIGHT function to help return the number of characters from right to left in a cell. The training video here will show you how the functions work in tandem. In addition, the LEN function is used, which counts each character in the cell, minus the SEARCH function of any characters following after the first delimiter or "space." So very useful in capturing the last name in a cell containing both first and last!

Purchase the training video and you can see this in action for yourself!

  Excel 2007 Online Training Video See Excel 2007 In Action!
Purchase Microsoft's Excel 2007 training videos now!
#