We need an excel add in, which will add new buttons (ribbon) in MS Excel (2010 and later versions) on pressing the button it will process the given sheet and perform variety of simple tasks. i.e
1- rename column headers (change A1MP to Apple 1 Macbook Pro)
2- move columns to different sheets (Move all columns starting from A1 to sheet called apple)
3- change some column values (change cost in cents to dollars e.g 200 cents to 2$)
4- create Title sheet with basic info (name of sheet, date range of data etc)
Given -> fixed list of tasks and column names, you won't need to get user input just use the information provided and hardcode the values in package
deliverable -> Excel Add in which can be installed on MS excel 2010 and later versions, permanently
program must have sanity checks for missing or incorrect data and/or columns. this is a simple task and will award instantly, future work to follow.
NOTE: Will accept only those bids who will attach a screenshot of their created Excel Add in.