Microsoft Excel Expert Level for Technical, Scientific & Supervisory Staff

- Πληροφορική - Χρήστες

02 Μαρτίου 2023 08:15 03 Μαρτίου 2023 16:00
Ελληνικά
14 ώρες ( 2 μέρες )
Microsoft Excel Expert Level for Technical, Scientific & Supervisory Staff

ΠΕΡΙΓΡΑΦΗ

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.

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

Prerequisites
Basic knowledge of Microsoft Excel. Additionally participants should have basic knowledge on the creation of formulae and functions.

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.

  • Unit1: Databases 
  • Apply data filters (AutoFilter)
  • Perform single and multi-level sorts
  • Extract data (Advanced Filter)
  • Use data validation
  • Use subtotalling
  • Use grouping and outlines

Unit2: Naming Ranges

  • Creating a named range
  • Changing a named range
  • Selecting fields by using names
  • Using names in Functions

Unit3: Using Functions And Nested Functions

  • Using IF (& nested IF)
  • Using VLOOKUP
  • Using AND, OR Functions
  • Using Financial Functions
  • Using Text Functions

Unit 4: Collaborating

  • Creating a comment
  • Changing workbook Properties
  • Protecting and Unprotect workbooks and spreadsheets
  • Protecting a file using passwords

 Unit 5: Templates

  • Creating new Templates
  • Using the existing Templates

Unit6: Advanced Number Formatting

  • Apply number formats (accounting, currency, number)
  • Create custom number formats
  • Using conditional formatting

Unit7: Analysis Tools

  • Creating and Using PivotTables
  • Using Goal Seek
  • Working with Scenarios
  • Using Solver (Goal Seek)

Unit8: Use data analysis and PivotTables

  • Creating PivotTables
  • Summarizing data using various functions
  • Working with Pivot Tables
  • Creating PivotCharts

Unit9: Auditing

  • Using the Auditing tools
  • Finding and correcting Formulae errors

Unit10: Printing

  • Preparing Sheets for Printing
  • Previewing and Printing Multiple workbooks
Αναλυτικό Κόστος Σεμιναρίου

Για Δικαιούχους ΑνΑΔ

  • € 350.00
  • € 168.00
  • € 0.00
  • € 182.00

Για μη-Δικαιούχους ΑνΑΔ

  • € 350.00
  • € 0.00
  • € 0.00
  • € 350.00
ΠΡΟΓΡΑΜΜΑ ΣΕΜΙΝΑΡΙΟΥ

Πέμπτη - 02 Μαρτίου 2023

Ώρα

08:15 - 16:00

ΕΚΠΑΙΔΕΥΤΗΣ:

Μαρία Κναή

Τοποθεσία:

OnLine Virtual Classroom

Παρασκευή - 03 Μαρτίου 2023

Ώρα

08:15 - 16:00

ΕΚΠΑΙΔΕΥΤΗΣ:

Μαρία Κναή

Τοποθεσία:

OnLine Virtual Classroom

Εκδήλωση Ενδιαφέροντος : Microsoft Excel Expert Level for Technical, Scientific & Supervisory Staff

Σεμινάρια στην ίδια κατηγορία από τον ίδιο διοργανωτή
Beyond Excel Expert (Comparing, Manipulating Lists and Analysing Data ...

Ένα νέο σεμινάριο από τους ειδικούς στο Microsoft Excel! To σεμινάριο αυτό απευθύνεται σε χρήστες που έχουν ήδη παρακολουθήσει το σεμινάριο Excel Expert και επι...

10/02/2023 08:15

14 ώρες (2 μέρες)

Ελληνικά

Επιχορηγημένο-ΑνΑΔ

Live Online

Microsoft Excel Expert Level for Technical, Scientific & Supervisory S...

Mastering Excel can be life changing in the workplace regardless of your current position. Working with tables and lists, making decisions based on data analysi...

02/03/2023 08:15

14 ώρες (2 μέρες)

Ελληνικά

Επιχορηγημένο-ΑνΑΔ

Live Online

Χειρισμός Ηλεκτρονικών Υπολογιστών (Windows, Internet, Email, Word & ...

Με την ραγδαία εξέλιξη της τεχνολογίας στην πληροφορικής,  όλοι οι εργαζόμενοι πρέπει να έχουν τουλάχιστον τις βασικές ψηφιακές  γνώσεις και δεξιότητες που απαι...

08/03/2023 08:15

60 ώρες (10 μέρες)

Ελληνικά

Επιχορηγημένο-ΑνΑΔ

Editc (Λευκωσία)

Microsoft Excel Basic Level For Technical, Scientific and Supervisory ...

Microsoft Excel is an essential application in today’s work environment. Microsoft Excel is a tool for the creation of spreadsheets and graphs, for performing c...

09/03/2023 08:15

12 ώρες (2 μέρες)

Ελληνικά

Επιχορηγημένο-ΑνΑΔ

Live Online

Analyzing data using PowerPivot and Data Analysis Expression in Excel...

The analysis of large data volume demands the use of modern tools in order that the analysis is done in a very effective way. People from the Statistics, IT, Ri...

17/03/2023 08:15

21 ώρες (3 μέρες)

Ελληνικά

Επιχορηγημένο-ΑνΑΔ

Live Online

Microsoft Excel Expert Level for Technical, Scientific & Supervisory S...

Mastering Excel can be life changing in the workplace regardless of your current position. Working with tables and lists, making decisions based on data analysi...

04/05/2023 08:15

14 ώρες (2 μέρες)

Ελληνικά

Επιχορηγημένο-ΑνΑΔ

Live Online