أنشئ حسابًا أو سجّل الدخول للانضمام إلى مجتمعك المهني.
Mr. Amit we already have done a lot of input in this regards, please visit the Excel Speciality section to learn more about Excel, also please share your experience as well so that, we would be able to learn many new things from you as well. Thanks
1. in excel we want to grid our contents in a table we choose bootom boarder- all boarders
2.returns the no of days between two dates in an year we use days360 function(start,end
- method) but we remember that only logically select the dates of two)
3.alt+d+p for creating a pivot table
Buy a book called Microsoft for Dumbies, it will give you all the tips you need to know. Amazon will be the best place to buy it :-)
Alt+d+f+f for putting the filter
Alt+d+p for creating a pivot table
Alt+d+f+f for putting the filter
What is Pivot Table in Excel? What does it Do? Why is it Required?