Day 2 | Learning Excel

Explored paste options. Don’t reinvent the wheel. Use available templates.Formula =My_OperationFunction =FunName(Fields:Fields) Absolute cell referencing: field expression $cell_name$cell_noshortcut: F4There are 4 types of cell reference. Relative Reference: Type = > target sheet > click on target cell > Enter Navigate through sheetsCTRL+PgUp/PgDn

Basic Commands

Concat all txt files and merge them in unique. [Works in PowerShell ]gc *.txt | sort > pagla.txt gc pagla.txt | get-unique > unique.txt Screenshot taking by aquatonecat final.txt | aquatone -out ~/mcafee/shots – ports large -chrome-path /usr/bin/chromium-browser