Excel Formatting the worksheets like text, background color, font, size etc. Using various Formulas like vlookup, hlookup, avg, sum, min, max, sumif, counif etc. Insert Pivot Charts and tables, Pictures, Slicers. Data Visualization and setting page layouts. Protecting Workbook and worksheet. Working with simple macros.