Yogendra Pratap Mishra

The pie chart is one of the best excel features. It is used to visualize the contribution of each value to a complete pie diagram. It always uses one data series. Follow the below steps to create a pie chart: Select the range A1: D2. Now On the Insert tab, in the Charts group, click the Pie symbol and then click Pie. After clicking, the following image will show the result. The above figure shows us the pie chart for the year 2012. It is showing us the Python slice, Whales slice, and Dolphins slice. In short, the contribution of each slice.

Unsend Sent Messages_ This is one of the most useful Gmail tricks. Go to   Settings  >  General tab  and check off “ Enable Undo Send .” You can also set the cancellation period as 5, 10, 20 or 30 seconds. Click on  Save Changes  at the bottom of the page. Next time when you send a message, you will see an  Undo  option in yellow below the search bar. You can click on it to unsend the message, and then you can edit it or discard it.

Use Excel templates Templates are available for any version of Excel. If you want to create an amortization table using a template, right-click on a blank worksheet and gain access through the “Insert” command. Under the “Spreadsheet Solutions” tab, you will find various templates, including an amortization schedule, which can then be inserted into the spreadsheet. You can also create your own templates by saving a worksheet as an Excel template.

Create tables quickly You can turn data cells into a table quickly! All you have to do is click within the parameters of your data and press Ctrl+T. Now you have an instant table displaying your data. Now that you have some helpful features to  reboot your Excel skills  and those of the accounting professionals you manage, you will get more done, and before you know it, you’ll be expanding your team!

 Splice data easily Slicing allows you to filter data easily. To do so, select any range in a table or PivotTable,  (refer to tip #5 for more information about PivotTables),  and then go to Insert > “Slicer,” in the top right corner. Then, select the column you want to filter by.

Use Sparklines to display data_24th January,2019. Sparklines are a built-in feature of Excel that allow you to display small charts inside individual cells. These can be line charts, bar charts or simple win/loss charts. To create a Sparkline chart, select the range of numbers you’d like to include, click the “Insert” menu, then choose one of the chart options. Select a location range, which must be located along a single row or column in the same worksheet as your data range. Sparklines can help you easily display trends in your data in a compact format.