Data Analysis using Microsoft Excel

The TEST4U Data Analysis using Microsoft Excel Course

The TEST4U team realized that there is a need for a complete hands-on Training system for Data Analysis using Microsoft Excel, so we created the Data Analysis using Microsoft Excel course. It is targeted to people, who want to learn how to perform various Data Analysis tasks using Microsoft Excel.

The Course at a glance

In this course you will find:

• 120 assignmentsproperly categorized

• 170 distinct filesfor each of the above assignments and for practicing

• 120 solution videosfor every assignment

• 50 Lectures

The Course in detail

120 assignments properly categorized

In this course you will practice on the following categories, using Microsoft Excel:

1. Basic Excel Training

2. Auditing tools

3. Text functions

4. Mathematical Functions

5. Logical functions

6. Date and Time functions

7. Lookup functions

8. Financial Functions

9. Statistical functions

10. Multi-Sheet and Array Formulas

11. What-if tools and Solver Add-in

12. Data management

13. Get and Transform with Excel – Power Query

14. PivotTables and slicers

15. Advanced and Pivot Charts

16. Cube Functions

17. PowerPivot

18. Power Maps

19. Statistical Analysis

20. Business Modelling

21. Share – Publish – Save as

170 distinct files for each of the above assignments and for practicing

Each and every assignment and lecture comes with its distinct file(s) for practicing.

120 solution videos for every assignment

All assignments are accompanied by detailed video solutions. We recommend you try to solve the assignments without viewing the solution. This way you will better understand your limitations and be able to focus on them. You can then see the video after you have solved it, to know if you answered the question correctly.

Fast feedback from our instructors

We give feedback to all assignments, usually within one or two working days. Although in many cases we have been known to answer within a few hours.

50 Lectures

There are approximately 50 lectures in this course explaining various function and features of Excel. Even though there is a plethora of lectures this course’s main focus remain the practical skills you can gain by solving the assignments.

Rating Distribution

• 1 stars: 1 votes
• 2 stars: 1 votes
• 3 stars: 1 votes
• 4 stars: 3 votes
• 5 stars: 14 votes

Frequently Asked Questions

How long do I have access to the course materials?

You can view and review the lecture materials indefinitely, like an on-demand channel.

Can I take my courses with me wherever I go?

Definitely! If you have an internet connection, courses on Udemy are available on any device at any time. If you don’t have an internet connection, some instructors also let their students download course lectures. That’s up to the instructor though, so make sure you get on their good side!