• LOGIN
  • No products in the cart.

The goal of this course is to help the students to overcome data analysis challenges in the work, research or studies. By taking this course students will learn overcome data analysis challenges in work and research, it increases the productivity and makes better business decisions. Along with these the course enhances the data analysis skills using spreadsheets and learn to organize and test the spreadsheets.

Assessment

This course does not involve any written exams. Students need to answer 5 assignment questions to complete the course, the answers will be in the form of written work in pdf or word. Students can write the answers in their own time. Each answer needs to be 200 words (1 Page). Once the answers are submitted, the tutor will check and assess the work.

Certification

Edukite courses are free to study. To successfully complete a course you must submit all the assignment of the course as part of the assessment. Upon successful completion of a course, you can choose to make your achievement formal by obtaining your Certificate at a cost of £49.

Having an Official Edukite Certification is a great way to celebrate and share your success. You can:

  • Add the certificate to your CV or resume and brighten up your career
  • Show it to prove your success

 

Course Credit: TU Delft

Course Curriculum

Module: 01
Why Spreadsheets? 00:03:00
Organization 00:03:00
Strings 00:05:00
Conditionals 00:08:00
Lecture Cont’d 00:08:00
Module: 02
Lookup search 00:04:00
Cont’d 00:04:00
Simple lookup 00:05:00
Lecture cont’d (part 2) 00:05:00
Lecture Cont’d 00:05:00
Fourth Parameter 00:04:00
When to use TRUE 00:04:00
Problem with VLOOKUP 00:03:00
Index and match 00:05:00
Module: 03
No formulas 00:08:00
Lecture cont’d 00:07:00
The basics 00:04:00
More Rows & Value Field Settings 00:03:00
Adding Columns to the Mix 00:03:00
Lecture cont’d 00:05:00
Multiple Tables 00:05:00
Secretly PowerPivot 00:04:00
PowerMap 00:03:00
Module: 04
Introduction 00:04:00
Name Manager 00:03:00
Lecture cont’d 00:03:00
Data Tables 00:03:00
Intersection 00:04:00
Lecture cont’d 00:06:00
The basmati effect 00:02:00
Lecture cont’d 00:02:00
Module: 05
0 Theory 00:05:00
Lecture cont’d 00:05:00
Array Basics 00:12:00
Lecture cont’d 00:07:00
Lecture cont’d cont’d 00:12:00
Transpose 00:03:00
Lecture cont’d 00:03:00
lecture cont’d (2) 00:03:00
Filter 00:05:00
Module: 06
Problems with Spreadsheets 00:04:00
Can we fix it? 00:03:00
What to test 00:04:00
Lecture cont’d 00:04:00
Lecture cont’d (2) 00:04:00
What to test 2 00:03:00
How to test 00:05:00
Spreadsheet level test 00:05:00
Expector 00:06:00
Module: 07
Movie example 00:08:00
The Excel way 00:07:00
DataNitro intro 00:05:00
DataNitro Bacon 00:14:00
Module: 08
Bacon again 00:02:00
Graphs to the rescue 00:03:00
Graph solutions 00:14:00
Module: 09
Instruction 1 00:05:00
Answers to Instruction 1 00:05:00
Module: 10
Instruction 2 00:05:00
Answers to Instruction 2 00:05:00
Instruction 3 00:05:00
Answers to Instruction 3 00:05:00
Module: 11
Instruction 4 00:05:00
Answers to Instruction 4 00:05:00
Module: 12
Instruction 5 00:05:00
Answers to Instruction 5 00:05:00
Module: 13
Instruction 7 00:05:00
Answers to Instruction 3 00:05:00
Background knowledge for ADP 00:40:00
Assessment
Submit Your Assignment 00:00:00
Certification 00:00:00

Course Reviews

4.9

4.9
8 ratings
  • 5 stars0
  • 4 stars0
  • 3 stars0
  • 2 stars0
  • 1 stars0

No Reviews found for this course.

591 STUDENTS ENROLLED
©2021 Edukite. All Rights Resereved
EduKite is a part of Ebrahim College, Charity commission reg no. 1108141