“Microsoft Excel” for Advanced Users

“Microsoft Excel” for Advanced Users
  • 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 the “MS Excel” program in their daily work and want to deepen their existing skills. Significant attention is given to working with large data lists and mastering the program’s capabilities that simplify the entry, processing, and searching of large amounts of data.

SEMINAR PROGRAM
  • Keyboard shortcuts and key combinations to speed up work.
  • Working with multiple workbooks.
  • Special paste options. Formats and copying formats.
  • Advanced sorting and filtering.
    • Advanced sorting by multiple criteria, including custom sorting orders that are not necessarily ascending or descending.
    • Advanced filtering.
  • Advanced formulas. Relative and absolute references.
  • Finding and correcting formula errors. Formula auditing.
  • Most popular functions:
    • Logical (IF, CountIF, SumIF, AverageIF, SumIFS, CountIFS, IFERROR, AND, OR);
    • Text (Concatenate, Left, Right, Mid, Find, Search, Trim, Text, Value, Lower, Upper, Substitute);
    • Date and time (Now, Today, Networkdays, Year, Month, Day, Weekday, Weeknum, Hour, Minute, Second);
    • Reference (Address, Index, Indirect, Column, Row, Match, Lookup, Vlookup);
    • Other (Round, Rounddown, Roundup, Isna, Product, Sumproduct).
  • Working with large amounts of data.
    • Data validation.
    • Subtotals (Subtotal).
    • Creating PivotTables (PivotTable).
    • Conditional formatting.
  • Creating more advanced charts.
  • Preparing and printing documents.