Excel advanced Training
- Total time
- Location
- At location, Online
- Starting date and place
Excel advanced Training
Provider rating:
Starting dates and places
placeKöln 9 Apr 2026 until 10 Apr 2026 |
computer Online: Zoom 9 Apr 2026 until 10 Apr 2026 |
placeKöln 16 Jul 2026 until 17 Jul 2026 |
computer Online: Zoom 16 Jul 2026 until 17 Jul 2026 |
placeKöln 22 Oct 2026 until 23 Oct 2026 |
computer Online: Zoom 22 Oct 2026 until 23 Oct 2026 |
Description
Schulungen der Extraklasse ✔ Durchführungsgarantie ✔ Trainer aus der Praxis ✔ Kostenfreies Storno ✔ 3=2 Kostenfreie Teilnahme für den Dritten ✔ Persönliche Lernumgebung ✔ Kleine Lerngruppen
Seminarziel
You will be able to use Excel's analysis functions confidently, and will be able to use complex and nested Excel functions.Inhalt
-
Complex formulas and functions
- Functions from the categories
- Logical functions
- Statistical functions
- Financial mathematics
- Date and time
- Nesting several functions
- Formula monitoring
- Functions from the categories
-
Handling large tables and folders
- Tables Layout
- Outlining
- Formatting outline levels
- Removing outlines
- Designs and page breaks for a clear layout
- Protecting content
- Conditional formatting
- Conditional formatting rules
- Rules with formulas
- Symbols
- Editing, checking and deleting conditional formatting
- Tables Layout
-
Data consolidation
- Consolidation rows and columns val…
Frequently asked questions
There are no frequently asked questions yet. If you have any more questions or need help, contact our customer service.
Schulungen der Extraklasse ✔ Durchführungsgarantie ✔ Trainer aus der Praxis ✔ Kostenfreies Storno ✔ 3=2 Kostenfreie Teilnahme für den Dritten ✔ Persönliche Lernumgebung ✔ Kleine Lerngruppen
Seminarziel
You will be able to use Excel's analysis functions confidently, and will be able to use complex and nested Excel functions.Inhalt
- Complex formulas and functions
- Functions from the categories
- Logical functions
- Statistical functions
- Financial mathematics
- Date and time
- Nesting several functions
- Formula monitoring
- Functions from the categories
- Handling large tables and folders
- Tables Layout
- Outlining
- Formatting outline levels
- Removing outlines
- Designs and page breaks for a clear layout
- Protecting content
- Conditional formatting
- Conditional formatting rules
- Rules with formulas
- Symbols
- Editing, checking and deleting conditional formatting
- Tables Layout
- Data consolidation
- Consolidation rows and columns values across tables
- Consolidation with and without data links
- Consolidation by heading
- 3D references
- Forecasting
- Data tables
- Scenarios
- Goalseek
- Checking data
- Data validation
- Creating dropdown lists
- Analysing data in dynamic tables
- Sorting data
- Sorting with the filter menu
- Filters
- Create and remove auto filters
- Complex filters criteria
- Results row
- COUNTIF and SUMIF
- Partial results
- Create, edit, remove
- Multiple partial results with different functions
- Partial results in filtered lists
- Manual use of the partial result function
- Data links
- Data links between spreadsheets
- File links
- Check, update, delete links
- Links to Word and PowerPoint
- Troubleshooting imported data
- Flash preview
- Split columns
- Cut and link texts
- Excel security
- Workbook security
- Worksheet security
- Locking workbooks
- Encrypt workbooks
- Write-protect workbooks
Share your review
Do you have experience with this course? Submit your review and help other people make the right choice. As a thank you for your effort we will donate $1.- to Stichting Edukans.There are no frequently asked questions yet. If you have any more questions or need help, contact our customer service.