Advanced Excel for business executives

Duration

12 Hours

Conduct

Classroom & Online

Duration

12

  Hours

Conduct

Classroom & Online

Description

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.

Informations

12 HOURS
Classroom (Syggrou Av. 188, Kallithea, 17671, Attica) or live online upon prior communication with Arkias Academy (education@arkias.gr)
Certificate provided
·       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

 

Expression of Interest