Quick Analysis and Transposing data

Quickly we can analyze the selected data in a spreadsheet by using Quick Analysis tool in Excel. Transposing data means converting the column into a row and vice versa.

Here in below video I have demonstrated how to do Quick Analysis and Transposing data. Please spare some time to watch the video and give your valuable feedback.

Sort and Filter

Sort is a cool feature in excel where we can sort the data in many ways and by using a filter we can filter the spreadsheet according to our need by avoiding unnecessary information. Please watch the below video to understand more about Sort and Filter

Freeze and Hide

In a given excel spreadsheet might contain a large amount of data with headings in the top row and first column. In such case, if we scroll down or right then we may not see headings. Here Freeze option comes to our rescue. Similarly, we can hide one or many columns and rows while working with data in a given spreadsheet. To know how to use Freeze and Hide features in excel please watch this video.

Cell referencing

If you working in different spreadsheets in a workbook or different workbook for the same project then this option plays a very handy tool and minimizes copy-paste errors in excel. Please watch below video to know how to do cell referencing in Excel.

Students Grade Formula

Here in the below linked video, I have explained how to insert students grade formula in Microsoft Excel so that we need not put grades manually. If you insert this formula excel will calculate students grade automatically. Please spare some time to watch this video and give your valuable feedback.