Timeline Options in Excel – Instructions

Timeline Options in Excel - Instructions: A picture of a user modifying the appearance of a timeline in Excel.
Timeline Options in Excel: Overview             This lesson shows you how to set timeline options in Excel. After inserting a timeline, an “Options” tab within a new “Timeline Tools” contextual tab then appears in the Ribbon. This tab appears in the Ribbon any time you select the timeline within the worksheet. You use the buttons
Read more
No Comments

Create a KPI in Power Pivot for Excel – Instructions

Create a KPI in Power Pivot for Excel - Instructions: A picture of the “Key Performance Indicator (KPI)” dialog box in Power Pivot for Excel.
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
Read more
No Comments

Custom Color Schemes in Publisher – Instructions

Custom Color Schemes in Publisher - Instructions: A picture of the “Create New Color Scheme” dialog box in Publisher.
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.
Read more
No Comments

Conditional Formatting in Excel – Instructions

Conditional Formatting in Excel - Instructions: A picture of a user selecting a custom conditional formatting choice from the “Conditional Formatting” button’s drop-down menu.
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
Read more
No Comments

Create Building Blocks in Publisher – Instructions

Create Building Blocks in Publisher - Instructions: A picture of the “Create New Building Block” dialog box in Microsoft Publisher.
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.
Read more
No Comments

Workbook Protection in Excel- Instructions

Workbook Protection in Excel- Instructions: A picture of the “Protect Structure and Windows” dialog box that is used to apply workbook protection in Excel.
Workbook Protection in Excel: Overview             When you apply workbook protection in Excel, users cannot add, delete, hide, rename, or move workbook worksheets. You can also provide an optional password that must be entered before the workbook can be unprotected. This option is also a bit risky, because if you forget the password, you cannot
Read more
No Comments

The Publisher User Interface – Instructions

The Publisher User Interface - Instructions: A picture of the major objects and tools within the Publisher user interface.
The Publisher User Interface: Overview             The picture below is of the Publisher user interface after opening a new, blank publication. A publication is the file type created in Publisher. Within a publication you create and modify text and graphic objects on the pages in the publication. When you close a publication, Publisher then prompts
Read more
No Comments