With an Excel 3D reference, a cell in a worksheet may link to a cell in another spreadsheet or an entirely new workbook. To create them simply, select the cell you want to receive the data, enter an = sign,

Ever wonder how somebody created a dropdown list in Excel? There are two ways to do this.1. Create the list in Excel somewhere, or have your list handy, so you can type the choices in your list.2. Select the cell

Have you ever needed data from a website to go into an Excel spreadsheet? Microsoft has a tool for that. Under the data tab, choose From Web in the Get External Data group. In the small browser that pops up,

If you are a command key user, then you will probably like the Key Tip option. Simply press the Alt key and letters will appear in the ribbon. Press the key that corresponds to the tab you wish to enter,

If you are new to Excel, there is a great tool called “Flash Fill”, that allows you to fill in cells based on information in other columns, along with additional information typed in the column being flash filled. This video

A Timeline can be inserted into your PivotChart, if dates are listed in your table. After you insert your PivotChart, add a Timeline, located in the Filters group of the Insert tab. Watch this short video to see how Timeline

Unhide all hidden columns in an Excel spreadsheet by selecting the entire spreadsheet and selecting Unhide. . For more ways to make Excel work for you, take a training course from AdvantEdge Training & Consulting!

Trace Excel Precedents by selecting a cell with a formula, and hitting Control [ For more ways to make Excel work for you, take a training course from AdvantEdge Training & Consulting!