Using this Quick Access Toolbar, we can sort the data according to your requirement, either Ascending or Descending.Īfter spending a considerable amount of time building the report, we need to write the executive summary for our report we need to write some of the key findings. Sort is pretty much a regular job for all the excel users. You can select any one of the available charts.īased on the selection you make, it will insert the chart for you. Now it will ask you to select a suitable chart for you. Select the data and click on the Chart icon in the QAT. By using QAT, we can insert the chart instantly. Inserting a simple chart will take some of our time. Then, it will paste the picture as a linked picture if any changes happen, it will update the picture automatically. In order to capture a live picture, select the data you want to capture and click on Camera.Īs soon as you click on the camera, it will copy the range, but you need not paste rather, you need to draw the picture where you want to show it. We can capture live images of the excel data. The camera tool works exactly the same way how it works on our mobile phones. TEXT and String Functions in Excel (26+).Lookup Reference Functions in Excel (34+).Excel Conditional Formatting in Pivot Table.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |