|
via Udemy |
Go to Course: https://www.udemy.com/course/data-analysis-using-microsoft-excel/
The TEST4U Data Analysis using Microsoft Excel CourseThe 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 glanceIn this course you will find:120 assignments properly categorized170 distinct files for each of the above assignments and for practicing120 solution videos for every assignment50 LecturesThe Course in detail120 assignments properly categorizedIn this course you will practice on the following categories, using Microsoft Excel:1. Basic Excel Training2. Auditing tools3. Text functions4. Mathematical Functions5. Logical functions6. Date and Time functions7. Lookup functions8. Financial Functions9. Statistical functions10. Multi-Sheet and Array Formulas11. What-if tools and Solver Add-in12. Data management13. Get and Transform with Excel - Power Query14. PivotTables and slicers15. Advanced and Pivot Charts16. Cube Functions17. PowerPivot18. Power Maps19. Statistical Analysis20. Business Modelling21. Share - Publish - Save as170 distinct files for each of the above assignments and for practicingEach and every assignment and lecture comes with its distinct file(s) for practicing.120 solution videos for every assignmentAll 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 instructorsWe 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 LecturesThere 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.