Change Prices or Values on Spreadsheet without using Formulas
If you have an Excel spreadsheet with lots of values and you want to change them all very quickly then watch this video. You can add, subtract, multiply or divide all the values in one go.
I just had a really strange problem with the AxtiveX Control that I had in a Form. The controls suddenly stopped working and in addition I was not able to delete and insert a new control. If you have the same problem here is the quickest way to solve it.
Start Windows/File Explorer
Select the system drive (usually C:)
Use the Search box to search for *.exd
Delete all the found files
Check your Data Entries in Excel Spreadsheets
If you wish to check your data you can either asked someone to read the hard copy while you check the screen or you can check the data by keep looking up and down between the hard copy and the screen. Excel has a really neat way to help you. Watch the video below. If you want more tips then book InIT Learning to come to you. GetonCourse for Success with our SoftwareTraining @ Yours.