Excel Data Analysis and Problem Solving
- 0.0
-
![]()
![]()
![]()
![]()
![]()
Brief Introduction
Be an Excel expert in less than 5 hoursDescription
This course includes a set of basic and advanced information and skills, through which you will be able to write formulas and functions, advanced filtering operations and conditional formatting and create pivot tables from tables in the data sheet and from external databases using Power Query and use Power Pivot tables to create Measures and KPI (Key Performance Indicator) And using What-if Tools and Solver to solving problems and using Analysis ToolPak to in Anova test, Discriptive Statistics, and Histogram and how to make a dashboard, through simplified examples and more ..
- All examples are attached with the course and you can download them
- All Lectures are translated to English
Requirements
- Requirements
- MS Excel
Knowledge
- - Dealing with formulas and functions in Excel
- - Advanced search, sorting and filtering mechanism
- - Dealing with tables and charts and plot math functions
- - Using consolidate to merge data
- - Create pivot table and use it in data analysis
- - Using Power Query and Power pivot table
- - Using what-if tools and Solver to solve problems
- - Record a macro and make a button to use it
- - Use the analysis ToolPak such as ANOVA test, descriptive statistics and histogram chart
- - Create Key Performance Indicators (KPI)
- - Create Dashboard from scratch
Lean Six Sigma Green Belt for Service Industry Professionals
- 4.4
-
![]()
![]()
![]()
![]()
![]()
Green Belt course exclusively designed for professionals who work in service industries (any non-manufacturing industry) Lean Six Sigma Certification is undoubtedly in demand....
Data Structures and Algorithmic Trading: Machine Learning
- 2.5
-
![]()
![]()
![]()
![]()
![]()
Data Structures and Algorithmic Trading: Machine Learning, Stock Trading, Invest In Cryptocurrency, Build A Forex Robot Algorithmic trading is not an attempt to make a trading profit....
Learn to Teach Java: Writing Classes and Arrays
- 0.0
-
![]()
![]()
![]()
![]()
![]()
Learn to program using Class design and 1-D Arrays in Java, and prepare to teach others using the free, online interactive CS Awesome textbook....
Capstone: Applying Project Management in the Real World
- 4.8
-
![]()
![]()
![]()
![]()
![]()
In this final, capstone course of the Google Project Management Certificate, you will practice applying the project management knowledge and skills you have learned so far....
