Dynamic Web Training BlogSlicers are special field filters that can be applied to Excel tables. They are most useful for further dissecting an existing PivotTable report in a worksheet. Slicers are actually graphics objects comprising of a rectangle and special filter buttons. Slicers are inserted into the worksheet from the Slicer command on the INSERT tab of the ribbon.
Excel’s reputation as an analysis tool grows with each successive upgrade. While data analysis was originally confined to data in a worksheet, Excel is now being used for analysing data from a variety of sources including databases and larger corporate data sources. Whilst this can be done using Excel itself, Power Pivot is an add-in that consolidates the steps towards achieving this.
PMT is an abbreviation for payment. The PMT function calculates the regular payment that needs to be made for an amount of money, based on a fixed interest rate and for a fixed duration. It is ideal for estimating the regular repayments to be made for a loan, but remember that in most situations fees, taxes and charges are added, so check with your lending institution first.
The general function to calculate regular repayments on a loan is =PMT(interest rate, duration, loan amount).
Before you start, ensure that the data you are working with in your Excel worksheet looks similar to the screen capture in Step 1.
The DATE function in Microsoft Excel is used to assemble a date from three separate pieces of data, being the year, month and day. This is useful if the information is provided in separate columns and you need to combine them. DATE will take the year, month and day and convert them to a single serial number representing the date. The result is automatically formatted as a date.
The general function to convert numbers into a date is =DATE(year, month, day).
Ensure that the data you are working with in your Excel worksheet looks similar to the screen capture in Step 1.
The NOW function returns the current date based on the computer’s system date, the NOW function returns the current date and the current time. While the NOW function can be used for dates, it is mostly used for working with time arithmetic. Read on to learn how to use this function!
The general function to work with time arithmetic is =NOW().
Before you start, ensure that the data you are working with in your Excel worksheet looks similar to the screen capture in Step 1.