Insert Slicers and Delete Slicers in Excel: Overview You can easily insert slicers and delete slicers in Excel. In Excel, slicers visually filter data within Tables, PivotTables, PivotCharts, and Power Pivot tables and charts. To insert a slicer into a worksheet, select one of these types of objects within a worksheet. Then click “Insert”
Use Building Blocks in Publisher: Overview Use Building Blocks in Publisher: How to Open the “Building Block Library” in Publisher The “Building Block Library” lets you use building blocks in Publisher. This dialog box lets you insert, edit the properties of, or delete existing building block content you create. To use building blocks in
Insert a Picture Placeholder in Publisher: Overview You can insert a picture placeholder in Publisher into a publication page. When you insert a picture placeholder in Publisher, you allocate space in a page for a picture you can insert later. To insert a picture placeholder in Publisher, click the “Insert” tab in the Ribbon.
Make Columns in Publisher: Overview You can make columns in Publisher to aid in the layout of a publication page. You can then add text boxes over the column guides you create in the page to produce newsletter-style layouts. When you make columns in Publisher, you can also add rows to a publication page.
Create a PivotChart in Excel: Overview You can create a PivotChart in Excel to show the data from an associated PivotTable in a graphic format. You can create a PivotChart in Excel either independently from or along with an associated PivotTable in Excel. Alternatively, you can also add a PivotChart to an existing PivotTable
The Scratch Area in Publisher: Overview The scratch area in Publisher is the space surrounding your publication. You use the scratch area in Publisher to store pictures or shapes. If you insert multiple pictures at the same time when using either the “Insert Picture” dialog box or the “Insert Pictures” window, then Publisher adds
Insert a Text Box in Publisher: Overview You can insert a text box in Publisher to display text within a publication page. To insert a text box in Publisher, click the “Home” tab in the Ribbon. Then click the “Draw Text Box” button in the “Objects” button group. Alternatively, to insert a text box
Create a KPI in Power Pivot for Excel: Overview Creating measures within the data model in Power Pivot then lets you create a KPI in Power Pivot for Excel. KPI stands for Key Performance Indicator. A KPI is a value, and often associated symbol, that gauges the performance of a base field in attaining