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 websiteWho is it for?Newly appointed Assistants or SecretariesInterimsTrainees or Stagieres in the EuropeanInstitutionsSales and Marketingprofessionals who are dealing with direct mailing/e-mailing campaigns, sales proposals creating in house offers etcMore senior staff that did not have a chance to thoroughly look at these issues beforeAll persons who want to improve their skills in MS OfficeLet us know in advance if you prefer to bring your own laptop or you want us to provide one for you