Sharmel has attended:
Excel Intermediate course
Formulaes
How do i gain the knowledge to understand and comprehend formulaes functionality to a more advanced level ?
RE: formulaes- Advanced
Dear Sharmel
Thank you for attending Excel Intermediate!! I hope you enjoyed the course and benefited from it.
The question you asked is generic. Excel has been created keeping various business scenarios or situations. Therefore there are several inbuilt functions that Excel comes with. It is impossible for me to tell you about all the functions.
The best thing to do is refer to the following link to see what functions we cover in Advanced level :
https://www.stl-training.co.uk/excel-training-in-london-2003-advanced.php
If you come across any other function that you may need explanation then you can post it our forum and we can try to answer them for you.
For your reference I am attaching a excel file that has all the functions used in Excel with a brief explanation for each.
I hope this has answered your query.
If this has answered your query then I would request you to please mark the question as resolved!! If not and you have a specific question related to this then please post it as a new question and we should be able to provide you the solution for it!!
Kindest Regards
Rajeev Rawat
MOS Master Instructor 2000 and 2003
MCAS Master Instructor 2007