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
HR Analytics: Essentials Human Resource Management,HR, Jan
- 4.1
-
![]()
![]()
![]()
![]()
![]()
Human Resources Certification, People Analytics, Human Resources, People Management, Talent Acquisition, HR Payroll, HRM Remember too that you have lifetime access to this course....
TensorFlow: Artificial Intelligence with TensorFlow: 3-in-1
- 3.6
-
![]()
![]()
![]()
![]()
![]()
Begin your journey to build next-generation AI models from scratch with TensorFlow and create your own machine learning Contents and Overview...
Financial Analysis and Financial Modeling using MS Excel
- 4.4
-
![]()
![]()
![]()
![]()
![]()
Perform financial analysis & financial modeling using Microsoft excel. For people who want to become a Financial Analyst After completing this course you will be able to:...
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....
