In a cell, type an equal sign (=) and the function you want to use.
Throughout the editing process, a function help box will appear to give you with a definition of the function and its syntax, as well as an example for reference.
data functions assist you in locating specific data from your data lists. You can use a data function to discover an employee's location in a worksheet if you have a worksheet with a list of a thousand of your employees and their ages.
Despite the fact that every Excel feature has a use case, no one uses every Excel feature. After sifting through the 500+ functions, there are only about 100 or so actually useful features and functions for the majority of current knowledge workers.
Maintain a tight and efficient data structure. Then, to share your findings, use charts, graphs, and PivotTables. Make it a habit to write your formulas with fixed cell references. This makes it easier to copy, paste, and reuse formulas throughout the worksheet, as well as reducing errors.
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.