Microsoft Excel“ – Analysis of Problem Situations

Microsoft Excel“ – Analysis of Problem Situations
  • Event Category: Microsoft Office

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

ABOUT THE SEMINAR

The course is intended for those who use “Microsoft Excel” in their daily work and encounter problems. During the course, functions and formulas that enable faster results will be discussed, and the most common mistakes and their solutions will be analyzed.

SEMINAR PROGRAM
  • Using keyboard shortcuts to speed up work.
  • Data preparation (splitting, merging, and cleaning data).
    • The “Text to Columns” command for splitting data and selecting data formats.
    • The “Remove Duplicates” command for eliminating duplicates.
    • Managing merged cells.
    • Issues related to data types.
  • Using paste options.
  • Creating unique lists (three different methods).
  • Formulas and functions. Formula structure and creation.
    • Absolute, relative, and mixed references.
    • Finding errors in formulas, formula auditing.
  • “CountIFS” and “SumIFS” functions for simple but fast calculations.
  • Lookup functions – “VLOOKUP”, “MATCH”, “INDEX”, “IFERROR”.
  • Using text analysis functions.
  • Conditional formatting for “safeguards” and visual data comparison.
  • Using PivotTables (англ. PivotTable), settings, and commands for more efficient work.
  • Dashboards (англ. Dashboard).
  • Integration of “MS Word” and “MS Excel” and combining information for creating mail merge documents (contracts, certificates, orders).
  • More advanced and visually effective charts.
  • Analysis of practical situations.
  • Discussion of participants’ individual questions.

Participants will receive training materials and files with practical task solutions.