Add Excel Tables to a Data Model in Excel 2019- Instructions
Tuesday, November 26 2019
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.
- Published in Excel 2019, Excel for Office 365, Latest, Microsoft, Office 2019, Office 365
No Comments
Set Margins in Excel – Instructions
Friday, November 22 2019
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
- Published in Excel 2013, Excel 2016, Excel 2019, Excel for Office 365, Latest, Microsoft, Office 2013, Office 2016, Office 2019, Office 365
AutoSave in Excel for Office 365 – Instructions
Wednesday, November 20 2019
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
- Published in Excel for Office 365, Latest, Microsoft, Office 365
Compare Workbooks in Excel – Instructions
Monday, November 18 2019
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
- Published in Excel 2013, Excel 2016, Excel 2019, Excel for Office 365, Latest, Microsoft, Office 2013, Office 2016, Office 2019, Office 365
Format Data Labels in Excel- Instructions
Thursday, November 14 2019
Format Data Labels in Excel: Overview You can format data labels in Excel if you choose to add data labels to a chart. To format data labels in Excel, choose the set of data labels to format. To do this, click the “Format” tab within the “Chart Tools” contextual tab in the Ribbon. Then
- Published in Excel 2013, Excel 2016, Excel 2019, Excel for Office 365, Latest, Microsoft, Office 2013, Office 2016, Office 2019, Office 365
Trace Error in Excel – Instructions and Video Lesson
Tuesday, November 12 2019
Trace Error in Excel: Overview Trace Error in Excel lets you trace arrows back to cells referenced by a formula if it displays an error. The Trace Error tool is available when auditing a worksheet within a workbook. Note that the formula cell that you select must contain an error to use the Trace Error
- Published in Excel 2013, Excel 2016, Excel 2019, Excel for Office 365, Latest, Microsoft, Office 2013, Office 2016, Office 2019, Office 365
Create a PivotChart in Excel- Instructions and Tutorial
Thursday, October 31 2019
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
- Published in Excel 2013, Excel 2016, Excel 2019, Excel for Office 365, Latest, Microsoft, Office 2013, Office 2016, Office 2019, Office 365