Menu
Cart 0

PCM Courseware Blog

Calculate a Loan in Excel using the PMT Function

Posted by Roger Hyttinen on

The PMT function is used to calculate payments due on a loan based on constant payments and assuming a constant interest rate. With the PMT function, you can easily figure out what your monthly payments will be on a mortgage or car loan. To calculate loan payments, the PMT function uses 3 arguments: rate – the interest rate. If you had a loan that you had to pay monthly with an interest rate of 8%, this argument would read: .08/12 (interest rate divided by 12 months). nper – the total number of payments of the loan. If the loan is...

Read more →

Create a Drop-Down List in Excel

Posted by Roger Hyttinen on

Create a Drop-Down List in Excel

If there are instances when you want to restrict the data that users can enter into certain cells, you might want to create a drop-down list. This allows people to choose from a predefined list of choices. Doing so makes it more efficient for the person entering data and can help eliminate errors or redundant data. To create a drop-down list in Excel, you will first need to create a list of the entries you want to appear in the list in a separate worksheet or in another area of the current worksheet and then use the Data Validation feature to...

Read more →

How to Crop Images in Microsoft Word

Posted by Roger Hyttinen on

How to Crop Images in Microsoft Word

You can crop your graphical images to remove unwanted portions. To crop an image, click the Crop button on the contextual format Ribbon, click on any crop handle bordering the image and drag inwards until the desired portion is removed. For a more precise measurement, you can use the Size dialog box by clicking on the Size dialog launcher and entering in your dimensions in the appropriate boxes under the Crop From category. You also have the ability to crop your images to a specific shape, if you so choose. Point to Crop to Shape from the Crop menu and...

Read more →

Print a Microsoft Word Table in Landscape

Posted by Roger Hyttinen on

Print a Microsoft Word Table in Landscape

Microsoft Word allows you to print a table in Landscape and keep the rest of the document in Portrait. This comes in especially handy if you want to widen your columns to make them easier to read. To so so, you'll need to select the table and then change the orientation to Landscape but only for the selected text. This will insert a section page break and will insert your table in its own page, in Landscape orientation. Any pages before or after the table will remain in Portrait. Quick Guide: Print a Word Table in Landscape Mode Move your mouse...

Read more →

How to Convert text to a Table in Microsoft Word

Posted by Roger Hyttinen on

How to Convert text to a Table in Microsoft Word

A handy feature in Microsoft Word is the ability to create a table from existing text. This saves the trouble of having to retype it should you wish it in table format. To convert text to a table, first select the text, click the Table button on the Insert Ribbon and click Convert Text to Table. Then, choose the number of columns you want your table to have and how the data is separated (comma, tab, paragraph or other). Quick Guide: To Convert Text to a Table Select the text that you want to convert to a table. Click the...

Read more →