Schulungsübersicht
Knowledge of Windows and MS Excel basics
- Excel Data Types
- Look up values in a spreadsheet
- Naming the range, create a range of labels
- Modifying named ranges
- Create custom number formats
- Use AutoFormat options in a spreadsheet
- Create a named style
- Creating a user template
- Protection sheets
Organizing data in a worksheet
- Create a list of data
- Adding to the list of series
- Creating a custom sort lists
- Consolidate data
- Create conspect
Processing of data in a spreadsheet
- Apply conditional formatting
- Summarizing data with subtotals
- Filter the list of data
- Create a custom filter
- Create an advanced filter
- Create scenarios
- Data Validation
Creating formulas
- Aggregation of cell contents using the AutoSum
- Adding in the dialog window
- Insert Function
- Editing formulas
- Evaluate Formula
- Using Solver tool to obtain specific values of the arguments
- Create a conditional formula
- Using the data table to solve the formulas
- Tracking error performance formulas
- Look up values in a particular row or column
- Determine the value location
- Returning values from a cell in a specific location in the data list
- Positioning of the data list
- Create a table of credit
The processing of information from external data sources
- Combining data from other Windows programs
- Importing a delimited text file
- Dividing a column of data into multiple columns
- Create a Web Query
- Importing database table
- Using queries to selectively retrieve information from external databases
- Calculate the average of the values stored in the database
Produce data charts
- Changing the chart type
- Creating a custom chart types
- Adding a trendline to a chart
- Adding new values and change data for the chart
- Create a combination chart
Using Pivot Table reports
- Basic information about PivotTables
- Overview of PivotTable fields.
- Create a PivotTable report with a list of data
- Change the layout of a PivotTable
- Filtering fields
- Changing the type of calculation data fields
- Grouping PivotTable data elements
- Entering additional calculations to the data area
- Add a calculated field
- Adding a calculated
- Get values from a PivotTable report
Creating a PivotChart
- Performing the pivot of information from external database
- Change the layout of a PivotChart
- Changing a PivotChart
- Filtering fields PivotChart
- Grouping elements PivotChart field
- Add a table of data to the PivotChart
Voraussetzungen
-
Kenntnisse von Windows und MS Excel Grundlagen
Publikum
-
Business Analytiker
Daten-Analysten
Erfahrungsberichte (10)
Gute Vorbereitung des Ausbilders auf die Ausbildung. Interessante Beispiele.
Sandra - LKQ Polska Sp. z o. o.
Kurs - Excel Data Analysis
Maschinelle Übersetzung
Excel cases from wnd day
Błażej - LKQ Polska Sp. z o. o.
Kurs - Excel Data Analysis
The instructor and the way he teach
Mohammad Almalek - Dubai Government Human Resources Department - DGHR
Kurs - Excel Data Analysis
the subject
Laila - Dubai Government Human Resources Department - DGHR
Kurs - Excel Data Analysis
His engage with the trainees & answer their questions.
sharifa alshehi - Dubai Government Human Resources Department - DGHR
Kurs - Excel Data Analysis
TRINER IS VERY GOOD
KHALID ALMUJAININ - Dubai Government Human Resources Department - DGHR
Kurs - Excel Data Analysis
practical nature and patience of trainer
Angela de Jong - Dubai Government Human Resources Department - DGHR
Kurs - Excel Data Analysis
Viele praktische Übungen
Zbigniew Dąbkiewicz - Takenaka Europe GmbH Sp. z o.o. Oddział w Polsce
Kurs - Excel Data Analysis
Maschinelle Übersetzung
um unser aktuelles Problem bei der Arbeit zu lösen
Aleksandra Ostrowska - Takenaka Europe GmbH Sp. z o.o. Oddział w Polsce
Kurs - Excel Data Analysis
Maschinelle Übersetzung
Thema der Schulung Art der Durchführung Individueller Ansatz des Trainers
Adrian Przybylski - Takenaka Europe GmbH Sp. z o.o. Oddział w Polsce
Kurs - Excel Data Analysis
Maschinelle Übersetzung