ΠΕΡΙΓΡΑΦΗ

Mastering Excel can be life changing in the workplace regardless of your current position. Working with tables and lists, making decisions based on data analysis, automating calculations with IF functions, comparing lists with VLOOKUP, formatting sheets with Conditional Formatting are some of the few things that you will learn.

The course Excel Expert Level introduces the most interesting features of Microsoft Excel.  The course focuses on the Excel features for data analysis such as sorting, filtering, advanced filtering, pivot tables, consolidation and subtotals as well as formulae and nested functions in order to create “smart” spreadsheets.  It also presents features such as data validation in order to minimize errors and automate data entry. The course also introduces various financial analysis tools such as goal seek, scenario manager and data tables. Finally the course presents ways to protect the spreadsheets and formulae and to create templates.

ΣΚΟΠΟΣ ΣΕΜΙΝΑΡΙΟΥ

The participants will be able to use advanced features of Excel in order to:

• Filter and analyze data
• Analyze data with Pivot Tables
• Group and create subtotals
• Use popular Functions such as IF function, VLOOKUP,  PMT etc
• Create nested functions for automation and analysis of calculations
• Track formulae and function errors
• Protect Workbooks, files, sheets and cells
• Use Analysis tools for financial analysis

ΣΕ ΠΟΙΟΥΣ ΑΠΕΥΘΥΝΕΤΑΙ

Participants may come from various departments and are dealing or wish to create complex spreadsheets. Participants who seek for ways to utilize all the excel features in order to create “smart sheets” or analyze data will find this course very useful.

ΠΕΡΙΣΣΟΤΕΡΕΣ ΠΛΗΡΟΦΟΡΙΕΣ

Methodology

The course is 100% practical. The topics are delivered with short presentations by the instructor followed by a  step-by-step demonstration by the instructor and repetition by the students, examples and discussions on how a feature may be used with real life examples and practice through written exercises.

Content Table

• Unit1: Databases
• Unit2: Naming Ranges
• Unit3: Using Functions And Nested Functions
• Unit 4: Collaborating
• Unit 5: Templates
• Unit6: Advanced Number Formatting
• Unit7: Analysis Tools
• Unit8: Use data analysis and PivotTables
• Unit9: Auditing
• Unit10: Printing