Ready to Checkout?

shopping-cart

Record a Macro in Excel: Overview              You can easily record a macro in Excel. Macros are small programs that record your actions as you perform a task in Excel. The actions are then saved as a Visual Basic Module, which is a type of program. When you run the macro later, it repeats your

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

Split Panes in Excel: Overview             To split panes in Excel when viewing a large worksheet, use the “Split” command in Excel. This command lets you split the Excel worksheet into different panes. Each pane contains its own horizontal and vertical scroll bars. Therefore, you can scroll each pane separately to view information from different

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

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.

Add Excel Tables to a Data Model: Overview             You can manually add Excel tables to a data model within a workbook. You can then use them as the data source for PivotTables, PivotCharts and Power View reports. Before doing this, however, first create the necessary tables within Excel. Also, to add Excel tables to

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

Change Worksheet Tab Color in Excel: Overview             You can change worksheet tab color in Excel, if desired. To do this, first select the worksheet tab whose tab color you wish to change. Next, click the “Home” tab in the Ribbon. Then click the “Format” button in the “Cells” button group. Then roll your mouse

TOP