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

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
主站蜘蛛池模板: 江华| 盐池县| 呼伦贝尔市| 聂拉木县| 页游| 民丰县| 姚安县| 彭州市| 海盐县| 安乡县| 安新县| 石门县| 噶尔县| 丰镇市| 邵阳市| 喀什市| 哈巴河县| 怀化市| 涪陵区| 墨玉县| 旬邑县| 山西省| 新野县| 湛江市| 抚顺市| 舒兰市| 石景山区| 遵化市| 安宁市| 布尔津县| 河西区| 会宁县| 鄂伦春自治旗| 昭苏县| 同心县| 浦北县| 尉氏县| 临邑县| 启东市| 拜泉县| 彭山县|