官术网_书友最值得收藏!

The Insert and Tools groups

The Insert group contains various visualization options such as Chart, Info Fieldand Filter:

  • Chart: This feature allows you to enable/insert dynamic charts
  • Info Field: Basic information such as name can be inserted through this tab
  • Filter: This tab is useful for simple data filtering.
Dynamic charts—these are charts that gets updated dynamically. The key is to define the chart's source data as a dynamic range. By doing so, the chart will automatically reflect changes and additions to the source data. 

The Tools group contains a collection of tools such as Smart CopySmart Paste, and Convert to Formula, which can act as shortcuts and come in handy for frequent tasks:

  • Convert to Formula: This is used for extracting Excel formulas after they have been converted from the crosstab to fetch data
  • Smart Copy: This field can be used to copy data from the clipboard
  • Smart Paste: This tab allows you to paste the data source from the clipboard as a table
  • Save View: A data source can be saved as a view using this option
主站蜘蛛池模板: 永康市| 蚌埠市| 隆回县| 鄂伦春自治旗| 安丘市| 亳州市| 承德市| 通海县| 浦江县| 邻水| 勐海县| 宣武区| 西林县| 阿拉善右旗| 塔河县| 青田县| 林芝县| 乌拉特中旗| 当阳市| 特克斯县| 渝北区| 靖宇县| 黄石市| 于田县| 微山县| 黔西| 舞钢市| 驻马店市| 镇沅| 庆安县| 武夷山市| 苍梧县| 惠东县| 普格县| 广汉市| 星子县| 宽甸| 双城市| 闸北区| 玛沁县| 永年县|