by fccadmin | Nov 13, 2012 | Excel, Microsoft, Microsoft Office
Thousands, Millions, etc. — Learn about number formats in Excel! If you use a number format like 0, Excel simply writes the number with no decimal point or decimal digits. To truncate the last three digits of a number in the thousands, append a comma to the...
by fccadmin | Nov 13, 2012 | Excel, Microsoft, Microsoft Office
Sharing the Wonder of Excel PivotTables! The PivotTable is a powerful tool for summarizing, analyzing, exploring and presenting data, extracted from larger amounts of data elsewhere in your workbook. It enables you to query the data in user-friendly ways, subtotal and...
by fccadmin | Nov 13, 2012 | Excel, Microsoft, Microsoft Office
Use AutoFill to fill in data…With the AutoFill feature, you can have Excel automatically continue a series of numbers, number and text combinations, dates, or formulas, based on a pattern that you establish. Select the first cell in the range that you want to...
by fccadmin | Nov 13, 2012 | Excel, Microsoft, Microsoft Office
Excel Conditional Formatting helps you explore and analyze data visually, detect critical issues and identify patterns and trends. A conditional format changes the appearance of a cell range based on a condition or criteria. You can use Highlight Cells Rules, Top or...
by fccadmin | Nov 13, 2012 | Excel, Microsoft
Learn some new tricks in Microsoft Excel! To summarize your Excel data without using formulas: Sort the data by what you would like to subtotal Go to the Data tab On the right of the ribbon, click Subtotal in the Outline group. Choose the field you’d like to...
Recent Comments