Create a New Workbook in Excel- Instructions
Monday, September 23 2019
Create a New Workbook in Excel: Overview You can easily create a new workbook in Excel. A workbook is the default file type in Excel, much like a document is the default file type in Word. A workbook can contain multiple worksheets where the data is stored and manipulated in the columns and rows.
- Published in Excel 2013, Excel 2016, Excel 2019, Excel for Office 365, Latest, Microsoft, Office 2013, Office 2016, Office 2019, Office 365
No Comments
Freeze Panes in Excel – Instructions and Video Lesson
Wednesday, September 18 2019
Freeze Panes in Excel: Overview You can freeze panes in Excel to view data in two separate sections of a long worksheet simultaneously. You can freeze panes in Excel to freeze one or two sections of a worksheet to prevent scrolling. Then you can then scroll the unfrozen section of the worksheet to view
- Published in Excel 2016, Excel 2019, Excel for Office 365, Latest, Microsoft, Office 2016, Office 2019, Office 365
Create a Data Model from External Relational Data in Excel – Instructions
Thursday, November 09 2017
Create a Data Model from External Relational Data in Excel: Overview You can create a data model from external relational data in Excel. Data models in Excel let you store multiple tables of information. They can then be used a data source for PivotTables, PivotCharts, and Power View reports. The choice to add
- Published in Access 2013, Access 2016, Excel 2013, Excel 2016, Latest, Microsoft, Office 2013, Office 2016, Office 365
Add Excel Tables to a Data Model in Excel 2016- Instructions
Thursday, May 04 2017
Add Excel Tables to a Data Model in Excel 2016: Overview You can manually add Excel tables to a data model in Excel 2016 or earlier workbooks. You can then use them as the data source for PivotTables and PivotCharts. Note that this process has changed in Excel 2019 and Excel for Office 365.
- Published in Excel 2013, Excel 2016, Latest, Microsoft, Office 2013, Office 2016