One of the most common questions we get about Excel is how to print spreadsheets. Spreadsheet content tends to be irregularly shaped and doesn’t fit on an 8.5 x 11 sheet well. Excel has a few tools for controlling how

Microsoft opened their Office suite to 3rd party development in 2013. In the same way that the functionality of a smart phone can be extended with an app, Microsoft Office apps can be downloaded to add new features. Microsoft itself

Excel Charts are critical to business reports because they are far more engaging than matrices of numbers. Charts must be accurate and aesthetically pleasing to the eye. The wrong chart type can mislead or inaccurately represent data. For example: A

Excel PowerPivot is a tool for managing and visualizing complex data within Excel. It has elements of a database system like Access but also offers Excel features like Pivot Table.PowerPivot is free with Office 2013, but you may need to

Use the name box to enter information into your spreadsheet instead of clicking on each cell. This will prevent you from entering information into the wrong cell by mistake. Usually when you click on a cell and start typing, Excel

Sometimes when pasting data into Excel, a column will widen to the point that it can’t really be used. A long URL, for example, might stretch off the page.Normally, you would grab the border between the column labels to resize

Microsoft has built 3 tools for creating maps in Microsoft Excel, including Power Map, Power View, and the Bing Maps App. To use these tools, you’ll need to download certain add-ins from the Microsoft site. Of course, consult with your

Sparklines are tiny graphs that fit in a single cell. Excel offers a few varieties and options. First, select that data Under the Insert tab, in the Sparklines group, choose either Line, Column, or Win/Loss In the pop up window,

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