When you know how to use pivot tables, VLookup, and date functions, among other things, you're deemed intermediate. Excel users with advanced skills must be able to manage and organise vast amounts of data. You must be able to create detailed graphs and tables, as well as record a macro to automate routine activities.
If it isn't already enabled, go to Excel File Options Add-in and pick the Excel Add-ins option on the Manage tab, then click GO to enable the Analysis ToolPak. This will open a little window where you can enable the Analysis ToolPak option. These are the tests that Excel Statistical Analysis can perform.
(1) Statistics aids in the better comprehension and accurate description of natural events. (2) In any field of study, statistics aids in the effective and efficient organisation of a statistical enquiry. (3) Statistics aids in the collection of useful quantitative data.
When a mathematical operation is necessary for a group of cells, such as summing the values in many cell locations, statistical functions are used. Functions are preferable to formulas for these calculations because adding many cell positions to a formula one at a time can take a long time.
I would suggest Absolute reference in 13:30 for the calculation of percentage
Hafiz Muhammad Talha
kindly share your slides for revision
Sohel Khalid Nadaf
How to get dataset
I am looking for this course in Telugu language, Is there any possibilities in Telugu.
Nitesh kumar gupta
nice course all the video explained very well from scratch to advance
Overall Lectures are good but also provide the practicing spreadsheets for students.