Pattern from a list of numbers & Change look of a simple dashboard

[kanchan_mita]

Dear Experts
Good Day!!

Well dear i m novice and will be grateful for your help. As i got stuck with two problems, which described below and attached sample data,

Q1: i have a list of 10,13 and 17 digit numbers like 12345000009,234567778,1098756,123456780,6781234512 i need to find if there is a matched pattern in list ,like rows 2,3,5 have 345 or row 1,2 have 12345.Need to identify which rows contains which patterns from right and left and how many.

Q2: i have a sample dash board in excel where data is driven from a pivot table and shown to users, i only want user to see the dashboard without any hint of excel look. need to change the icon of the workbook and on clicking it they will view a full screen fitted view in desktop or laptop without any bar or anything.

Thanks & Regards
Babu.