Entry Level

What you are about to be challenged or learn about, has MANY uses. This business case will come VERY handy if you work with POS, Sales Data.

Many times, when your receive your sales report, UPC code not necessarily always match, when trying to referring to other tables.

Main reason sometimes, is due to the CHECK digit.

This very simple challenge, will make you extract the CHECK digit (or last Digit) of a UPC Code

Click the image below to download the macro free Excel file and start your Challenge

How many times you have faced with trying to copy a formula to another cell, and it doesn’t work?

Something is not working. The cells involved in the original formula doesn’t seems to “stick”.

What normally people do, is to re-create the formula again, in the destination cell, and that could be very time consuming

Click the image below to download the macro free Excel file and start your Challenge

If you get stuck or want to know how is done, here is a link to youtube video…