Have you ever needed to reformat data so that the columns were the rows and the rows were the columns? Transposing in Excel is straightforward and easy. Select your data Copy your data with Control + C Click on the

Once you have created a macro, you can activate it in one click by adding it to the Quick Access Toolbar Click on the arrow at the end of the Quick Access toolbar and choose More Commands. This will open

You can quickly sum a block of data (both Rows and Columns) in Excel with just one click. Start by selecting the data including the cells that will contain the SUM Formulas. (in our example Column E and Row 11)

Filling down an Excel Formula in a column can be quickly achieved by positioning the cursor on the lower right corner of the cell and Double Clicking. The formula will repeat to the end of the data. For more ways

Hiding certain rows or columns in Excel can make viewing complex, detailed information easier to read. Grouping Rows in Excel allows you to quickly collapse and expand similar data to create more useful views. Select the rows with similar data

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