Beschreibung
Excel advanced Training
Deepen your Excel knowledge will be in this course for advanced users. Use statistical functions in dynamic tables to expand your Excel skills. You will learn how to work with complex formulas and functions, you will be able to look into the future with what-if analyses, and you will get the tools to structure, design and present large files.Each participant works in the seminar with the software version of their choice.
Kommende Starttermine
Inhalte / Module
- 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
Zielgruppe / Voraussetzungen
Please specify your desired version (2021, 2019/2016) when registering.
Hinweis: Dieser Kurs richtet sich an Mitarbeitende aus Unternehmen und Institutionen.
Für Privatpersonen ist dieser Kurs leider nicht geeignet.
Eine Informationsanfrage zu diesem Kurs ist nur für Beteiligte aus dem B2B-Bereich sinnvoll.
Abschlussqualifikation / Zertifikat
Infos anfordern
GFU Cyrus AG
Erweitern Sie Ihre IT-Skills mit einem offenen IT-Training oder ganz nach Ihren Bedürfnissen durch eine individuelle IT-Schulung. Programmiersprachen (C#, Python, Java, …), Microsoft Office 365, Anforderungsmanagement, Projektmanagement, Business Intelligence, Data Science, Künstliche Intelligenz, IT-Sicherheit , Administration & Datenbanken, Softwareentwicklung, Testmanagement...
Erfahren Sie mehr über GFU Cyrus AG und weitere Kurse des Anbieters.