Format Error Bars in Charts in Excel- Instructions

Format Error Bars in Charts in Excel - Instructions: A picture of the “Format Error Bars” task pane in Excel.
Format Error Bars in Charts in Excel: Overview             You can format error bars in charts in Excel if you add them to a chart. To format error bars in charts in Excel, first choose the set of error bars to format. To do this, click the “Format” tab within the “Chart Tools” contextual tab.
Read more
No Comments

Move a Chart in Excel- Instructions

Move a Chart in Excel- Instructions: A picture of the “Move Chart” dialog box in Excel.
Move a Chart in Excel: Overview             You can easily move a chart in Excel. When you insert a new chart into a worksheet, it appears as an embedded chart object in the worksheet. When you embed a chart in a worksheet, you can move it and also resize it in the worksheet. Before you
Read more
No Comments

Add Excel Tables to a Data Model in Excel 2019- Instructions

Add Excel Tables to a Data Model in Excel 2019- Instructions: A picture of the “Import Data” dialog box in Excel, which lets users add tables to a workbook’s data model.
Add Excel Tables to a Data Model in Excel 2019: Overview             You can manually add Excel tables to a data model in Excel 2019 or Excel for Office 365 workbooks. You can then use them as the data source for PivotTables and PivotCharts. However, note that this process changed from earlier versions of Excel.
Read more
No Comments

Use Building Blocks in Publisher – Instructions

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

Set Margins in Excel – Instructions

Set Margins in Excel - Instructions: A picture of the “Margins” tab within the “Page Setup” dialog box in Excel.
Set Margins in Excel: Overview             To set margins in Excel worksheets before printing, open the “Page Setup” dialog box. To open the “Page Setup” dialog box, click the “Page Layout” tab in the Ribbon. Then click the “Page Setup” dialog box button in the lower-right corner of the “Page Setup” button group. Then click
Read more
No Comments

AutoSave in Excel for Office 365 – Instructions

AutoSave in Excel for Office 365 - Instructions: A picture of the “Version History” panel you can use to revert changes made to a file with AutoSave enabled in Excel for Office 365.
AutoSave in Excel for Office 365: Overview AutoSave in Excel for Office 365: How to Enable AutoSave in Excel for Office 365             This tutorial shows you how to use AutoSave in Excel for Office 365. AutoSave in Excel for Office 365 is automatically enabled when you save a workbook using the newest file formats
Read more
No Comments

Compare Workbooks in Excel – Instructions

Compare Workbooks in Excel - Instructions: A picture of a user comparing two workbooks in Excel side by side.
Compare Workbooks in Excel: Overview             This lesson shows you how to compare workbooks in Excel. To compare workbooks in Excel, first open the workbooks to compare to each other. To then compare them side by side, with each workbook taking an equal portion of the screen, click the “View” tab in the Ribbon. Then
Read more
No Comments

Add Text to Shapes in Publisher – Instructions

Add Text to Shapes in Publisher - Instructions: A picture of a shape containing too much text in Publisher. Note the red resizing handles and the ellipsis mark on the shape. This indicates there is more text in the shape than it can display.
Add Text to Shapes in Publisher: Overview             You can add text to shapes in Publisher within a page. When you do this, Publisher converts the selected shape into a text box. However, because there are many shapes in Publisher, a text box does not have to be a literal box shape. Using this technique
Read more
No Comments