ΠΛΗΡΟΦΟΡΙΕΣ ΣΕΜΙΝΑΡΙΟΥ
Εκπαιδευτής: Χάρης Ευαγγέλου
Διάρκεια: 15 ώρες
Χώρος διεξαγωγής: Εξ αποστάσεως (ONLINE)
Περίοδος Διεξαγωγής: 05/03 - 22/03/2024
Δίδακτρα: €375
Δίδακτρα για Δικαιούχους εταιρικής επιχορήγησης: €75
Δίδακτρα για ανέργους : ΔΩΡΕΑΝ
Θέσεις προκρατούνται μόνο με καταβολή ολόκληρου του ποσού και για τους άνεργους με την αποστολή των πιο κάτω πριν από την έναρξη του προγράμματος:
ΠΑΡΑΠΕΜΠΤΙΚΟ ΣΕ ΕΠΑΓΓΕΛΜΑΤΙΚΗ ΚΑΤΑΡΤΙΣΗ -R237 (πρωτότυπο ή με προωθημένο ηλεκτρονικό μήνυμα)
ΔΕΛΤΙΟ ΕΓΓΡΑΦΗΣ ΥΠΟΨΗΦΙΟΥ – ES19 (με ημερομηνία που εμπίπτει με την έναρξη του προγράμματος)
What you'll learn
Rapidly increase the speed and efficiency of your work with the shortcuts, tips, tools & techniques used.
Master the key functions in Excel, applying them together and in isolation in a range of commercial contexts.
Utilize Goal Seek, Data Tables and Scenario modelling techniques to answer Management's most important questions.
Harness the power of Pivot Tables to organize, summarize, slice, dice & dissect data...fast!
Format your work to look professional and presentable, gaining trust and usability.
Lookup data with INDEX & MATCH, and learn Excel's new XLOOKUP function.
Unlock the power of SUMIFS & SUMPRODUCT in your summaries, and master IF, AND & OR to reduce risk in your work.
Course objectives
Gain broad, advanced, commercially-orientated knowledge of Excel suited to Accounting & Finance, Analyst, Consultant and Strategy positions, as well as other roles with a commercial focus.
Be able to apply in multiple ways the most useful and relevant Excel functions to your analysis and spreadsheets.
Learn how to construct formula containing multiple functions.
Utilize a range of inbuilt Excel tools in your data analysis and work.
Be able to format your work to look professional and presentable.
Extend your knowledge of Excel functionality relevant to analysis.
Increase the speed with which you work in Excel and produce analysis.
WHAT’S IN THE COURSE?
This course is split into 4 main sections:
Excel Essentials – shortcuts, tips, tools and techniques that will rapidly speed up your work so that you’re operating as fast and efficiently as you can be.
Exploring the Ribbon - what’s in there, what’s important, what’s secondary
Customizing the Quick Access Toolbar to speed up your work
Top keyboard shortcuts for fast navigation and undertaking regular actions
A look at a very powerful add-in (NB: this add-in is available on Windows only, not Mac)
Other tips and techniques to work as efficiently as you can
Functions, Formulae & Calculations – a comprehensive look at the theory, advice and demos of the most important and relevant functions, top tips for formula construction & auditing, and the creation and use of Named Ranges.
Overview of the Function Library
Most useful functions and their application: INDEX, MATCH, INDEX & MATCH vs VLOOKUP, XLOOKUP, SUMIFS, SUMPRODUCT, COUNTIFS, MAX & MIN, RANK, IF, AND, OR, TRUE & FALSE
Formula construction – top tips for building formula involving multiple functions
Formula auditing tools – navigating your calculations and finding errors
Range names – how to create, use and edit to make your work more transparent
Data & Analysis Tools – Excel’s most useful tools – Pivot Tables, Goal Seek and Data Tables – as well as techniques for introducing scenarios into your spreadsheets and modelling.
Pivot Tables - how to create, use and customize
What-If tools – Goal Seek to find inputs
What-If tools – Data Tables to sensitize inputs
Techniques for creating scenarios and flexing inputs
Formatting & Views – ways to make your work presentable, presentational and professional, to increase trust in it and improve its usability.
Importance of formatting your spreadsheets
Cell styles - their use and customizing
Conditional formatting of outputs
Presenting the data you want through Sorting & Filtering
Improving the look of work through Freeze Panes, Grouping & Hiding
Data Validation to make your spreadsheet more robust & usable
Πρόγραμμα
ΠΡΟΓΡΑΜΜΑ EXCEL 05.03
Size:
49.99 KB Format:
DOCX
Preview
Οδηγίες Εγγραφής στο σύστημα ERMIS:
{{#with category}}
{{title}}
{{/with}}
{{#if categories}}
{{#each categories}}
{{title}}
{{/each}}
{{/if}}
{{#with category}}
{{#if parent_id}}
Back
{{/if}}
{{/with}}
{{#if category}}
{{#if category.type}}
{{/if}}
{{#if category.linkdownload_cat}}
{{/if}}
{{/if}}
{{#if files}}
{{#each files}}{{#if ext}}
{{#if custom_icon}}
{{else}}
{{ext}}
{{/if}}
{{title}}
{{#if description}}
{{{description}}}
{{/if}}
{{#if versionNumber}}
Version : {{versionNumber}}
{{/if}}
{{#if size}}
Size : {{bytesToSize size}}
{{/if}}
Hits : {{hits}}
Date added : {{created_time}}
Download
{{#if openpdflink}}
Open
{{else}}
{{#if viewerlink}}
Preview
{{/if}}
{{/if}}
{{/if}}{{/each}}
{{/if}}
ΕΡΜΗΣ
ΕΡΜΗΣ
pdf
ΔΙΑΔΙΚΑΣΙΑ ΠΑΡΟΥΣΙΟΛΟΓΙΟΥ
Size:
916.87 KB
Hits : 2026
Date added:
2023-01-18
Download
Preview
pdf
ΔΙΑΔΙΚΑΣΙΑ ΕΡΓΟΔΟΤΗ ΓΙΑ ΣΥΜΜΕΤΟΧΗ ΣΕ ΠΟΛΥΕΠΙΧΕΙΡΗΣΙΑΚΑ ΠΡΟΓΡΑΜΜΑΤΑ
Size:
1.19 MB
Hits : 1729
Date added:
2023-01-18
Download
Preview
docx
5) ΒΗΜΑΤΑ ΓΙΑ ΑΠΟΚΤΗΣΗ ΡΟΛΟΥ ΕΡΓΟΔΟΤΗ
Size:
16.90 KB
Hits : 1048
Date added:
2023-10-30
Download
Preview
docx
2) ΕΓΓΡΑΦΗ ΦΠ-ΕΡΓΟΔΟΤΟΥΜΕΝΟΙ
Size:
19.05 KB
Hits : 1107
Date added:
2023-10-30
Download
Preview
docx
4) ΕΓΓΡΑΦΗ ΝΠ-ΕΡΓΟΔΟΤΗΣ
Size:
1.21 MB
Hits : 1087
Date added:
2023-10-30
Download
Preview