What will you learn?Useful features in MS ExcelAdd filtersSortingManipulate spreadsheets (export, group, etc.)Work with several windows (split, freeze, hide cells)Navigate in a spreadsheetCreate and use an ExceltemplateQuickly format cells (format painter and smart tags)Conditional formatting of a group of cellsFix encoding rules for a group of cellsCreate a chart from a tableExtract data from a database to demonstrate them with filters, PivottablesConsolidationsDatabase functions (IF, DSUM, DMIN, DMAX, VLOOKUP etc. )Import data from other applications or from a website