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.
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
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.
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
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.