MS Excel

Curriculum

Module 1: Introduction to MS Excel

Start Menu. Open/ Close the programme. Open/ Save a new book. Main settings.

Module 2: Basic rules

Text, numbers and formulas. Move across the sheets of a book. Work with multiple sheets. Add, remove, move, copy sheets. Insert rows/ columns.

Module 3: Formulas

Main operations. Build-in functions: SUM, AVERAGE, MAX, MIN, COUNT, ROUND. Addresses. IF/ VLOOKUP/ HLOOKUP.

Module 4: Charts

Create a chart. Templates: column, line, bar, pie, area, scatter charts. Formatting. Data analysis. Print comments for the cells. Create a macro. Macros application.

Module 5: Introduction to SAP system

Product Overview. Navigation. Basic terms in SAP applications. SAP services.

Duration

50 hours.

Want to learn more? Email us at help@test.bg or call us on +359 2 903 59 33