Have you ever imported data that was in all caps, or all lower case? There is a quick trick for capitalizing the first letter of each word in Excel. =Proper(Cell) formula in Excel In this example, I copy and pasted

Applying Conditional Formatting to your data allows you to identify variances in a range of data with a quick glance, by highlighting the differences or trends that you specify. You can customize the process by creating your own rules to

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

Adding a Secondary Y-Axis in Excel Charts Using a secondary Y-Axis in an Excel chart can help different types of data display better together on the same chart.For example, a data set that includes the number of truckloads sold and