„Microsoft Excel“ for Professionals

„Microsoft Excel“ for Professionals

The course schedule has not been scheduled yet. Please visit again soon.

ABOUT THE SEMINAR

The course is intended for professionals who use the “Microsoft Excel” 2010/2013 program in their daily work and wish to deepen their knowledge. The course is designed to provide knowledge about data management and the use of functions that help automate calculations. The main focus is on working with large data lists and mastering the program’s capabilities that simplify the processing and searching of large amounts of data.

SEMINAR PROGRAM
  • Advanced sorting and filtering.
  • Working with large amounts of data.
  • Data validation.
  • Subtotals (“Subtotal”).
  • Combining tables (“Consolidate”).
  • Creating PivotTables (“PivotTable”).
  • Conditional formatting.
  • Advanced formulas.
  • Relative and absolute references.
  • Finding and correcting formula errors.
  • Formula auditing. Formula protection.
  • Examples of using advanced functions (lookup, financial, mathematical, date and time, text functions).
  • Special paste options. Formats and copying formats.
  • Working with multiple workbooks.
  • Optimization tasks.
    • What-if data tables (“Table”).
    • Creating scenarios.
    • Goal seeking and solving (“Goal Seek”, “Solver”).
  • Creating and using macros.
  • Preparing and printing documents.
  • Changing program settings.
  • Keyboard shortcuts and key combinations to speed up work.

About the Lecturer

  • Lecturer: Vilma Eidukynaite

Lector Vilma Eidukynaitė is a certified Microsoft trainer and holds a Master’s degree in Software Systems Engineering. She has more than 17 years of experience delivering both closed and open IT-related seminars and participates in EU-funded projects aimed at improving the qualifications of employees in business enterprises and public sector institutions.