An Advanced filter can be used in Excel to filter data with criteria. Shayne has some data that he would like to filter to obtain details of just the employees from UK. Here is how he can do it. To do this, he should set a criteria above the data to be filtered. He should …
Simron has an Excel workbook that has the details of various employees and their yearly income generation for the company. She has created a new worksheet in the workbook in which she wants to summarise the total income generation by all the employees. In such a situation, one can use the Data Consolidation option. What …
Saina has inserted a picture into her Excel sheet but she now wants to change its resolution. She can do this by using the Picture Tools, Formatting options available. How to Change the Resolution of a Picture? HD: This is a 330 ppi image that will be perfect for viewing in HD display screens (16:9) …
Picture Tools: Changing Picture Resolution in Excel Read More »
After inserting an image into his Excel sheet, Darsh realizes that he doesn’t want the entire image but only a part of it. He click on the ‘Crop’ option in ‘Picture Tools’ and a dropdown list appears. He is confused with the various options in it. Let us look at what each one of them …
Picture Tools: Cropping an Inserted Image in Excel Read More »
Sonia has made a chart in her Excel sheet for her school project but her teacher has asked her to insert some chart elements to make it more reader-friendly. In this module, we will look at how she can insert the various chart options. How to Add Chart Elements: To add chart elements, Sonia should …
Chart Tools: Inserting Chart Elements – Free Excel Tutorials Read More »