MS Excel Training

Target Audience

Users who wish to learn how to use MS Excel, those who perform reporting or calculations in their work and wish to improve their skills.

Scope

This training designed by Yakın Kampüs includes topics such as Excel formulas and their use, functions and areas, application editing and presentation development techniques.

Goal(s)

Using Excel in business life successfully and efficiently with examples taken from real life and practical exercises.

Content

  • Pivot Table
  • Formulas
  • Data Functions
  • Advanced Filter and Database Formulas
  • Data Limiting / Data Verification
  • Conditional Formatting
  • Identifying Cells with Specific Features
  • Importing Data
  • Working with Names
  • Linear Modeling – Cost Analysis
  • List Merging / Consolidation
  • Graphics

Duration

2 hours