relopec.blogg.se - Excel 13

The worksheet below shows a list of employees. Using the same logic, Flash Fill can also be used to extract automatically the numbers from column A, as shown below.įlash Fill can be used to concatenate cells. On pressing enter, Excel will fill the whole column. In cell B2, as you start typing the next line item heading (COGS), you will see Excel automatically filling the remaining rows underneath, as shown below. In cell B1, you would input the line item heading corresponding to the cell to the left (in this example type Sales). Separating the heading from the value can now be done very quickly using Flash Fill. The worksheet below shows data downloaded from an external source. It is useful when you need to concatenate cells or separate information in cells without wanting to write a cumbersome formula.

ISOWEEKNUM Returns the ISO week number of the year for a given dateįlash Fill is a time-saving feature that reads patterns in adjacent columns and automatically fills the remaining cells in a column based on those patterns.

DAYS Return the numbers of days between two dates.RRI Solves for r in the following financial math formula FV = PV * (1+r)n.PDURATION – Solves for n in the following financial math formula FV = PV * (1+r)n.FORMULATEXT – Returns a formula as a string.Not all of these functions are applicable to financial modeling purposes. New FunctionsĮxcel 2013 has forty-eight new functions that were not available in previous versions of Excel. Below we review the new features in Excel 2013, listed in order of relevance for financial analysis and modeling. You can even upload your favorite financial model to Facebook! However, we do not expect organizations to adopt SkyDrive, primarily for security reasons. After setting up a Microsoft account, you can use SkyDrive to store and share Office 2013 documents. There are also a few time-saving new functions, and you will notice some tweaks to the look and feel of the working environment.Įxcel 2013 integrates nicely with the Microsoft version of cloud storage called SkyDrive. However, analyzing data, charting and pivot tables are now more user friendly. None of the new features are mind blowing from a financial modeling perspective.

Microsoft released its new version of Excel at the end of January 2013.