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)
Ich mochte die große Anzahl von Aufgaben und die freundliche Atmosphäre.
Paulina - LKQ Polska Sp. z o. o.
Kurs - Excel Data Analysis
Maschinelle Übersetzung
Sehr guter Kontakt zu den Teilnehmern
Michał - LKQ Polska Sp. z o. o.
Kurs - Excel Data Analysis
Maschinelle Übersetzung
Zeit zum Üben und kontinuierliche Unterstützung.
Łukasz - LKQ Polska Sp. z o. o.
Kurs - Excel Data Analysis
Maschinelle Übersetzung
Das Wissen und die Vorgehensweise des Trainers. Bei Problemen war er in der Lage, die Ursache effektiv zu ermitteln und zu einer Lösung zu führen
Bartosz - LKQ Polska Sp. z o. o.
Kurs - Excel Data Analysis
Maschinelle Übersetzung
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