Most of the QAT features have shortcut keys.

In order to send an email system should be configured as an outlook email.

Based on the requirement of the user, we can customize the QAT.

Things to Remember About Quick Access Toolbar in Excel

Once the outlook is configured, click on the Email icon on the QAT. In order to send the current workbook as an email attachment, you need to configure your system to Outlook.

Inserting the pivot table is super quick now we just need to select the data and click on the Insert Pivot Table icon on the Quick Access Toolbar. We all use a pivot table for our analysis purpose. Refer to our article on Spell check for more information. In order to do the spell check, press the spell check icon on the QAT it will do the spell check in the entire worksheet and recommend the changes. As human beings, we tend to make typing mistakes. Then, we need to recommend some of the insights and maybe more things to be written. Spell CheckĪ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. Using this Quick Access Toolbar, we can sort the data according to your requirement, either Ascending or Descending. 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. TEXT and String Functions in Excel (26+).Lookup and Reference Functions in Excel (36+).Excel Conditional Formatting in Pivot Table.

Quick analysis button excel 2010