On Course for Success

Excel

Evening Classes

Milton Keynes

InIT Learning are pleased to announce the introduction of evening classes in Milton Keynes for nine weeks covering all three levels of Excel. Delegates receive nine comprehensive manuals and three certificates of attendance. All equipment is provided. A great friendly environment with no more than six delegates on each course. First course starts in October 2018 so get your place or places for your staff booked now.

Excel – Find out more>>

Scheduled Excel Courses

Excel Courses are scheduled in Milton Keynes

Excel Courses Milton Keynes

Best value Excel Courses in Milton Keynes
Harben House Hotel
Newport Pagnell

Excel Courses >>>

Prevent Extra Spaces

Data analysis requires accurate entry of each piece of data. For example, if you are required to analyse all the sales in Northamptonshire you would get the wrong results if Northamptonshire has been entered with leading or trailing spaces. The trim function is a great function to remove all leading, trailing and extra spaces between words; however, it would be much better if you prevented them in the first place. Here is a great method using Custom data Validation:

Leave a Reply

Your email address will not be published. Required fields are marked *

*

code