Hours
The seminar is designed for business executives of all departments, who use Excel as a basic tool.
It is aimed at executives who have already mastered the basic Excel skills, who wish to acquire more advanced skills and at the same time learn about the latest developments in the application through practical exercises.
The aim of the seminar is to train participants in the use of advanced functions and formulas in Excel. With the help of these functions, users can create more complex and specialized functions in Excel.
· Find and replace text with formatting | · IF |
· Hide sheets, columns, rows | · MULTIPLE IF |
· Freeze lines & columns | · AND, OR και NOT |
· Move or copy to another sheet or file | · SUMIFS |
· Inserting a code into a sheet or file | · FUNCTION |
· Protect cells or sheet | · ADVANCED FUCTION |
· Insert & name a table | · AVERAGEIFS |
· Open a file that forgot the code | · COUNTIFS |
· Filtering by criteria | · COUNTA |
· Table styles & tools | · COUNTBLANK |
· Insert analyzer | · FILTER |
· Partial sum | · VLOOKUP (TRUE, FALSE) |
· Partial sum & formatting | · XLOOKUP |
· Share shared excel files | · HLOOKUP |
· Working on shared excel files | · INDEX |
· File author | · MATCH |
· Sort by criteria | · INDEX & MATCH |
· Customize print area | · ISBLANK |
· Print titles, page configuration | · IFERROR |
· Quick data analysis | · SUMTOTAL |
· Differences between lists | · CONCATENATE |
· Create data validation rules | · LEN |
· Conditional formatting | · REPLACE |
· Conditional formatting with functions | · LEFT, RIGHT |
· Conditional formatting by value | · UPPER, LOWER, PROPER |
· What if analysis | · TODAY, YEAR, MONTH, DAY |
· Creating an aggregated table | · WEEKDAY |
· Adding fields to an aggregated table | · WORKDAY |
· Formatting aggregate table fields | · NETWORKDAYS |
· Calculations (operations) in the aggregated table | · DATEDIF |
· Analyst in aggregated table | |
· Task automation, macro recording |