First, go to Review > Track Changes, and then to Highlight Changes.
Select the Track changes while editing check box in the Highlight Changes dialogue box.
Make a table with the columns listed below. Simply type the titles, select them, and click CTRL+T.
Set up data validation rules. This is the important bit.
Use conditional formatting to emphasise what matters.
Select "New Query," "From File," and then "From Workbook" from the "Data" tab in your performance tracker. Choose the data-containing workbook. Select "Get Data," "From File," and then "From Workbook" from the "Data" menu. Select the workbook, then the worksheet that contains the data you require.
open Excel and add column headers.
Complete the task details.
Sort your results using a filter.
use the filter to sort your tasks.
Very good teaching technique. And it is totally free so who has only want to learn free so it is so much useful for them. Thank you
Teaching technique is easy to understand. Thanks.
Very nice teaching.
REALLY HELPFUL COURSE
This is helpful how are zero to intermediate level.
very good course
zero to hero course excel
outstanding class, mind-blowing practical class and concept. I just love it and thank you very so much.
again Thank you sir and Thank you Madam.