Excel - CHOOSECLM - FILTER

Hi Everyone i want to share function in excel that i use lately, i found it pretty useful, and i decided to share with you. They are :
1. CHOOSE COLUMN
2. FILTER.

Some time we want to view spesific field excel, and do not want to change our table. there are few ways like copy the sheet to another sheet and delete field that we do not want to show but, this make both sheet if there are any changes, second way we can hide the excel but some time can be expose while we drag other sheet.

Note the excel schema we write:
we put data on excel sheet 1 and make table and push CTRL + T named it "table_sales"
and put header what ever you like, according to example below for column  A through N

WIth this formula we can choose and filter flexibly.

For formulation: CHOOSECOLUMN
=CHOSECOLUMN("source table", "selected table we want to show")
for example =CHOOSECOLUMN(table_sales,1,2,3,4,12,13,14)

For formulation: FILTER
=FILTER("source table","parameter of filter","thing we want to show if data not available")
for example = FILTER(table_sales, table[item_sales] = "Online", "Data not available")