Master Pages in Publisher: Overview You can use master pages in Publisher to change the default appearance of pages in a publication. Master pages in Publisher contain the default page layout objects and content to apply to a publication page. When you add pages to a publication, they are
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
Custom Color Schemes in Publisher: Overview You create custom color schemes in Publisher to apply colors you select to publication elements in a consistent way. To create custom color schemes in Publisher, click the “Page Design” tab in the Ribbon. Then click the “More” button in the lower right corner of the “Schemes” list.
Conditional Formatting in Excel: Overview Conditional formatting in Excel lets you define criteria for cells which change the way the cells look in the worksheet, but only if the cells’ values match the criteria. For example, you could create a conditional formatting criterion that makes a worksheet cell appear with a red fill color
Create Building Blocks in Publisher: Overview You can create building blocks in Publisher to make reusable content you can insert into your publication pages. For example, you could save your company’s logo and name as a custom building block. Later, you could insert it into future publications without recreating all its content and formatting.
Create Calculated Columns in Power Pivot in Excel: Overview This lesson shows you how to create calculated columns in Power Pivot in Excel. You can create calculated columns and measures from the tables in the Power Pivot data model. Doing this lets you create table values that you can then add to PivotTables and
Enable Power Pivot in Excel: Overview This lesson shows you how to enable Power Pivot in Excel. Power Pivot expands the abilities of the Excel data model to allow for robust data management and reporting for PivotTables and PivotCharts. Before you can start using Power Pivot, however, you must enable it in Excel. Power
Forecast Sheets in Excel: Overview You can insert forecast sheets in Excel into a workbook to predict future trends from existing time-based data. To create forecast sheets in Excel, you must have a series of date or time entries for the timeline. You must also have corresponding values for those time or date entries.