Writing Basic Formulas in Excel 2013
Wednesday, October 23 2013
Writing Basic Formulas in Excel 2013: Video This video shows writing basic formulas in Excel 2013. Writing Basic Formulas in Excel 2013: Overview You use formulas to perform mathematical functions on cells. There are two basic ways of writing formulas available: “ranged syntax” or “simple syntax.” A “syntax” is simply a way of expressing or
- Published in Excel 2013, Latest, Office 2013
No Comments
How to Write and Use Formulas in Microsoft Excel 2013
Monday, September 09 2013
How to Write and Use Formulas in Microsoft Excel 2013: Video This video shows how to write and use formulas in Microsoft Excel 2013. Formulas in Microsoft Excel 2013: Overview You use formulas to perform mathematical functions on cells. There are two basic ways of writing formulas available: “ranged syntax” or “simple syntax.” A “syntax”
- Published in Excel 2013, Latest
Pasting Links between Cells in Excel 2013
Thursday, August 22 2013
You can paste links between cells within Excel, so that the value of a cell within a workbook will simply be the value of another selected cell. For example, if you had a cell that added the cells above it within one worksheet and you wanted to paste a link to that cell into a
- Published in Excel 2013, Latest
How to Insert Bullets in Excel 2013- Microsoft Office Training
Tuesday, August 20 2013
Unlike Microsoft Word, Excel does not contain a button to insert bullets into a cell. However, there are a few ways you can add bullets in Excel. 1. Click into the cell where you want to add a bullet. 2. Press Alt+7 on your numeric keyboard to enter a generic bullet. 3. To quickly
- Published in Excel 2013, Latest
Creating Charts in Microsoft Excel 2013
Wednesday, August 14 2013
Excel 2013 allows you to create charts from the data stored in a worksheet more easily than in previous versions. Charts are useful for times when you wish to create visual representations of the worksheet data for meetings, presentations, or reports. To insert a chart, first select the cell range that contains the data that
- Published in Excel 2013, Latest
How to Use the AutoSum Feature in Microsoft Excel 2013
Thursday, August 08 2013
Much of the time, people use Excel to sum columns and rows of data. In fact it occurs so frequently that Excel has included a feature called AutoSum that automatically performs a selected function, like SUM, on a selected column or row of uninterrupted (no blank) cells. This saves you time in creating basic formulas.
- Published in Excel 2013, Latest
Inserting and Deleting Sparklines in Microsoft Excel 2013
Thursday, August 01 2013
You can insert sparklines into your worksheets to illustrate changes to data values within a column or row of contiguous worksheet cells. A sparkline is basically a mini-chart that appears within a single selected worksheet cell and displays selected cell values as a trendline, columns, or a win-loss series. To create a sparkline within
- Published in Excel 2013, Latest
Using Flash Fill in Microsoft Excel 2013
Thursday, July 18 2013
Click here for the complete Excel training Starting in Excel 2013, you can use the “Flash Fill” feature to automatically fill-in values within a column with information entered into an adjacent column. This feature is most useful when dealing with data that has a consistent data entry pattern in
- Published in Excel 2013, Latest