Vielen Dank für die Zusendung Ihrer Anfrage! Eines unserer Teammitglieder wird Sie in Kürze kontaktieren.
Vielen Dank, dass Sie Ihre Buchung abgeschickt haben! Eines unserer Teammitglieder wird Sie in Kürze kontaktieren.
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
14 Stunden
Erfahrungsberichte (7)
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