Select the leftmost and rightmost letters in a text string with these text commands. For more ways to make Excel work for you, take a training course from AdvantEdge Training & Consulting!

Not just the design has changed in Excel 2013. The newest version of Excel offers some new features for processing and understanding data that are worth a second look. For those familiar with the fill handle in previous versions of

Excel, by default, automatically updates formulas that refer to cells in other workbooks. Prevent Excel from updating these cells by following the instructions in this video. For more ways to make Excel work for you, take a training course from

With a few clicks you can copy a worksheet from one workbook and paste it into another. This video tip will show you how. For more ways to make Excel work for you, take a training course from AdvantEdge Training

Create a drop-down list in Excel, so that others can select from a list of options to populate a cell, using a feature called a Data Validation. Select cells in which you want the drop-down list to appear. Excel Data

Use report filter tabs in Microsoft Excel PivotTables to quickly parse and analyze your data. You can use the report filter aka page filter feature in Excel to give you one additional way to filter and refine your Excel PivotTable

Have you ever wished you could adjust the margins in Print Preview mode in Microsoft Excel? Look below to find the hidden button that will allow you to just that. Click the File Tab Click Print At the bottom of

In Excel, remove extra spaces before and after your data with the trim function. For more ways to make Excel work for you, take a training course from AdvantEdge Training & Consulting!