Categories
Adobe Photoshop

How to use Masking in Photoshop

Masking can be used to hide portions of one layer and reveal the layers below. This is one of the many reasons why masking is considered a valuable composition technique for combining numerous photos into a single image.

Categories
Adobe Photoshop

How to use HDR Toning to create a dramatic effect

HDR (High Dynamic Range) image is originally generated from numerous exposures, however Photoshop’s HDR Toning effect lets you simulate this effect in a single image. HDR Images are usually created using numerous photographs, each captured with a different exposure. However, it is understandable to not have the time to take multiple images, this is where HDR adjustments come in handy.

Categories
Microsoft Excel

The PMT Function in Excel

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.

Categories
Microsoft Excel

The DATE Function in Excel

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.

Categories
Microsoft Excel

The NOW Function in Excel

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.