Unit 1: Working with TEXT Function Category
• CONCATENATE
• LEFT, RIGHT
• UPPER, LOWER
• LEN
• FIND
• Nested Functions using the Functions listed above

Unit 2: Working with MATH & TRIG Function Category
• SUMIF and SUMIFS
• SUBTOTAL
• ROUND

Unit 3: Working with STATISTICAL Function Category
• COUNTIF and COUNTIFS
• AVERAGE – MEDIAN
• MAXIF, MINIF
• Variance, Standard Deviation
• T.Test, Z.Test
• Nested functions

Unit 4: Conditional Formatting
• Highlighting top and bottom ranks
• Highlighting based on values
• Converging cells into small charts
• Using Color Scales to view the trend

Unit 5: Conditional Formatting with Functions
• Highlight dates where you have a weekend
• Highlight those employees with below average KPIs using Conditional Formatting and Functions

Unit 6: Creating Nested Lists
• The Function INDIRECT
• Combining Data Validation with Functions

Unit 7: Comparing Lists
• Using VLOOKUP
• Nested functions with IF and VLOOKUP
• Automating Calculations with IF and formulae

Unit 8: Finding Duplicates
• Using Conditional Formatting
• Using the Remove Duplicates Tool
• Using function combinations

Unit 9: Importing Data
• Connecting to External Data Sources
• Importing from text files
• Importing csv files
• Using TRIM to spot redundant spaces

Το σεμινάριο απευθύνεται σε Επιστημονικό, Εποπτικό και Διευθυντικό προσωπικό  οργανισμών και εταιρειών οποιουδήποτε κλάδου που κάνουν στατιστική ανάλυση δεδομένων  που σχετίζονται με οποιοδήποτε κλάδο (π.χ.  πληροφοριών για τη διαχείριση ανθρώπινου δυναμικού, πληροφοριών που σχετίζονται με τον κατασκευαστικό τομέα, διαχείριση πληροφοριών λογιστηρίου/πωλήσεων/κατασκευαστικού τομέα, επιμετρήσεων κ.α.)

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.