You must be logged in to take this course → LOGIN | REGISTER NOW
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
No Reviews found for this course.