Brief Introduction
50 Lectures, 120 Assignments with video solutions, 762 Assignments with instant assessment using the TEST4U applicationDescription
----- UPDATED FEBRUARY 2020 -----
New automated system for claiming the free TEST4U subscription
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 assignments properly categorized
170 distinct files for each of the above assignments and for practicing
120 solution videos for every assignment
50 Lectures
760+ additional assignments, using the accompanying TEST4U subscription
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.
760+ additional assignments, using the accompanying TEST4U subscription
We offer 5 hours access to TEST4U training platform. Practice makes perfect. This is why we offer to all our students 5 hours free access to our TEST4U training platform. This Windows application gives you a way to instantly and automatically get feedback on whether you answer to the assignments is correct or incorrect. Check the last lecture for more information.
We encourage you to use this tool. We put a lot of effort in it, so that our students could have the best and most innovative tool to help them in their training.
Requirements
- Requirements
- The students should have some knowledge of the basic usage of Excel
- An installation of Microsoft Excel is required to solve the assignments, practice and use the TEST4U software
- In some assignments the PowerPivot, Power Maps or PowerView plugins of Excel may be required. These plugins are part of the Pro version of Excel.
5 Raiting
Variable Gage R&R ANOVA Method
- 2.5
-
![]()
![]()
![]()
![]()
![]()
Conduct, analyze & interpret Variable Gage R&R ANOVA method. Compliant to IATF16949 automotive industry requirements What you'll learn The concept of measurement system variation....
Master QuickBooks 2018 & QuickBooks 2019 the Easy Way
- 4.5
-
![]()
![]()
![]()
![]()
![]()
The Drop-Dead Simple Method to Mastering QuickBooks Pro. Includes 14 hours of training for QuickBooks 2018 & 2019 QuickBooks Made Easy...
Learn Excel Conditional Formatting with 7 Practical Problems
- 0.0
-
![]()
![]()
![]()
![]()
![]()
Learn Excel Conditional Formatting features (both common rules and formula based) to visualize the insight of your data. Teaching 11 Courses on Excel and Data Analysis!...
Accounting Analytics
- 4.5
-
![]()
![]()
![]()
![]()
![]()
Accounting Analytics explores how financial statement data and non-financial metrics can be linked to financial performance. Ratios and Forecasting Module 1 Overview 1....
