-
Title
-
Introduction to Data Analysis with Excel
-
Package
-
Digitale SAP-Bibliothek
-
Platform
-
Your learning platform for SAP software
-
URL
-
https://et.training/dashboard/product/video/1260
-
Status
-
Deleted
-
Publication Type
-
Other
-
Medium
-
Empty
-
Language
-
-
First Author
-
Simon Sez IT
-
First Editor
-
Empty
-
Publisher Name
-
Empty
-
Date First in Print
-
Empty
-
Date First Online
-
2023-01-01
-
Access Start Date
-
Empty
-
Access End Date
-
Empty
-
Volume Number
-
Empty
-
Edition Statement
-
Empty
-
Access Type
-
Empty
-
Note
-
Introduction to Data Analysis with ExcelSubheading: Explore the key features of Microsoft Excel that make it such an essential tool for Data AnalyticsOne of the most rapidly developing areas in today's market is data analytics—it is also an area in which businesses are struggling to find qualified staff. In this course, we will explore the key features of Microsoft Excel that make it such an essential tool for data analytics.Using the data analysis and visualization features that are native to Excel, this course will show you how to extract maximum value most efficiently from the information your organization collects. This course starts off with the fundamentals, walking you through all you need to understand about spreadsheets, from layout to applications. We will cover a variety of topics, including exploring formulas, cleaning data, and identifying data attributes.This course demonstrates how to analyze data using Excel and tackle complicated criteria. We will use Excel charts to depict data, relationships, and potential outcomes. In addition, we will also be discussing how to use the what-if functionality of the Analysis ToolPak add-in that comes with Excel. Each section includes practical examples that show how to apply these techniques to real-world business problems.After finishing this course, students will be able to:Describe the fundamentals of Excel spreadsheets, from their layout to the applicationsView, enter, and format data types in ExcelUnderstand and apply Excel formulas and functionsImport file data and remove duplicatesIdentify data attributesSort data and apply filters, including advanced filtering techniquesApply Concatenation and Sum-if formulas to analyze data setsCreate problem statements to tackle complicated “or” criteriaCreate Pivot tables and chartsWork with Excel charts, including clustered columns, line graphs, and waterfallsUtilize database functions created specifically to work with large datasetsApply techniques to recognize and avoid formula errorsUnderstand and use the What-If Analysis toolkit which includes the Scenario Manager, Goal Seek, and Data Table functionsUse the Analysis ToolPak to calculate basic statistical concepts such as correlation and covarianceCompute descriptive statistics and moving averages and apply exponential smoothing techniquesUtilize rank and percentile options and generate histograms.
-
Last Changed External
-
Empty
- Date Created
-
2023-08-18 11:30:21
- Last Updated
-
2024-03-14 14:09:55
- UUID
-
d6740e92-f351-441d-9168-b4557cd92cf9
Identifier Namespace Name |
Identifier Namespace Value |
Identifier |
Title_ID
|
title_id
|
1260
|
Dewey Decimal Classification |
-
Series
-
Empty
-
Parent publication title ID
-
Empty
-
Superseding publication title ID
-
Empty
-
Preceding publication title ID
-
Empty
Price Type |
Value |
Currency |