Datum
09/12/2025 - 10/12/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

– Break­even 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

– Print

– Performing Settings in Excel

– Options

– Customizing the Quick Access Toolbar

690,00

Kategorien