Datum
09/10/2025 - 10/10/2025
Ganztägig
Kalender-Import: iCal
Veranstaltungsort
ETC Trainingscenter
Modecenterstraße 22, 1030 - Wien
You must have sound Excel skills and understand key concepts of spreadsheets, or equivalent to our Intermediate course level.
Information Worker
After the course, you will be able to: Use Lookup & Informational Functions Create Pivot Tables Use What-If Tools Sharing and Tracking Workbooks Record Basic Macros
This course is aimed at experienced Excel users who need to perform more complex functions, lists analysis, use What-If tools and who would like to start recording basic macros
– Further Formulas and Functions
– Nested functions
– Working with a lookup function
– Protecting cells
– Unprotecting documents
– Custom number formats
– Conditional formatting
– Working with Data Lists
– General information for creating a list
– Complex sorting using a dialog box
– Working with Data Validation
– Setting data validation criteria
– Checking data validation
– Applying data validation to other cells
– Goal Seek
– Consolidate
– Scenario Manager
– Working with estimates
– Opening the Scenario Manager
– Creating a scenario report
– Deleting a scenario
– Solver
– PivotTable
– What is a PivotTable?
– Creating a data list
– PivotTable Tools
– Creating the PivotTable report
– Advanced PivotTable features
– Changing the PivotTable
– Rearranging rows and columns
– Hiding contents
– Displaying extreme values
– Outlining Excel Data
– Sample spreadsheet
– Showing and hiding cell ranges
– Removing the outline
– Customizing levels and ranges
– Subtotals
– Charts
– Breakeven analysis
– Sparklines
– Macros Task Automation
– Recording a macro
– Running a macro
– Creating a Custom Function
– Procedures
– Custom function features
– Using the custom function
– Data Import and Export
– Using the clipboard to exchange data
– Importing graphics
– Editing imported graphics
– Picture Tools
– Preparing a document for sharing
– Templates
– The benefits of a template
– Creating a template
– Saving the template
– Using the template for a new workbook
– Forms
– Validation and cell protection
– Controls
– Other controls (calendar)
– Format
– Performing Settings in Excel
– Options
– Customizing the Quick Access Toolbar
690,00
Kategorien