Because of importing or dubious data entry, many users have to deal with worksheets that have improperly parsed data. Most commonly, this means that a single cell might contain data that should be divided over several columns. Excel has a

To add a query in a Excel spreadsheet, click the Data tab, then click the drop down for New Query command. This will open a display box that allows you to choose the workbook you want to run the query

In some large Excel workbooks a dependent cell may refer to a precedent cell on another worksheet or many rows or columns away. The Excel Watch Window lets you see the dependent cell adjust as you make changes to the

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

A secondary Y-Axis in an Excel chart helps different types of data fit well together on the same chart.For example, a data set that includes the number of truckloads sold and the dollar value sold will not show up well

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 deletes

Recording a macro with a complex sort is actually very simple.Start with your data unsorted and unselected. Then under the View tab, click on the down arrow just below the Macros Icon and choose Record Macro.Type a Macro name that