Excel 2013 Kompakt (E2013K)

 

Conteúdo do curso

The training is divided into introduction & progress, each module can of course also be booked individually. Day 1 introduction • The user interface • Workbook management • Table Structure • Working with formulas and functions o First basic functions o Function Wizard o General. Overview • Create diagrams • Formatting cells • Use styles & designs • Filter and sort data Book this module individually 2nd & 3rd day progress • Layout & print area, side view • Additional functions (IF, VLOOKUP, HLOOKUP, COUNTIF, SUMIF, INDEX, RANK, date functions, text functions ...) • Work with different diagrams • Create graphics • Monitor content • Conditional formatting • Data Validity • Create and edit pivot tables • Create target value searches and analyzes • Combine and consolidate data • Working with the ExcelSolver • The scenario manager • Collaboration - work in a team and with other applications • Best Practices

Preços & Delivery methods

Classroom training

Duração
3 dias

Preço
  • Solicitar orçamento

Agenda

Currently there are no training dates scheduled for this course.