calculate profit in excel

How to Calculate Profit in Excel

Do you know how to calculate profit? Whatever small business you run, you should know some basic bookeeping things such as how to calculate profit and expenses. If you know to keep track of your business finances, you will have a more clear picture of what should be your next steps to take.

As most of you know, Microsoft Excel can be a very powerful bookkeeping tool for anyone running a small business of their own. It enables users to easily and effectively keep track of money coming in and leaving the company with easy-to-follow spreadsheets and formulas that are very simple to use when calculating profits and expenses. Here is a quick guide on how to calculate profit by putting together a spreadsheet in Excel. This guide can work in all versions of MS Excel.

Start Excel program and select four columns and a couple of rows, with the right click of the mouse. The next step is to click on the Insert tab and then on Table. Write the following values in the columns: Income, Expenses, Profit, and Percentage. Fill in the Income and Expenses columns.

[related id=”2829″]

Once you have done that, you can select the currency you are working with on the ribbon. You can find the currency settings when you click on Home tab. The dollar sign is in the Number section. When you click on it, you will see the drop-down menu, as shown on the image below.

bookkeeping tips

 

Your table should now look something like this:

 

how to calculate profitWhat is the formula to calculate the profit?

To get your profit, enter the formula “=a2-b2” into the c2 Profit cell.

Once you have calculated the profit amount, drag the corner of the cell to include the rest of your table.

how to calculate profit

In order to calculate your profit percentage, enter the following formula into the blank cell under Percentage: = c2 / a2.

Read moreHow to Calculate Profit in Excel

How to Print on a Computer and Save Environment

eco-friendlier printing tipsOnly the page that doesn’t get printed is eco-friendly or green. In reality, however, this level of eco-friendliness and sustainability has yet to be achieved. Many of us, especially businesspeople and college students, can’t always avoid printing – no matter how environmentally conscious we are. However, we can all print less if we put our minds to it. To help you do that, we have prepared five actionable and easily implementable tips on how to print on a computer and at the same time save environment.

Read moreHow to Print on a Computer and Save Environment

How to Track Financial Data from Web in Microsoft Excel 2013

import data from web in excelAnyone who works in the financial industries knows the importance of keeping good statistics. More likely than not, you are using a spreadsheet program on an everyday basis – most commonly, Microsoft Excel.

Microsoft Excel 2013 has a great feature for importing financial data that and stats that you find online into your own spreadsheet and tracking data from Excel itself. This comes in very handy for anyone who works with stocks, currencies or any other type of constantly fluctuating data. With this Excel feature, you are able to not only import data you find online, but also set it up to automatically refresh these statistics within your spreadsheet whenever they change.

Here’s a step-by-step how-to guide at how to do this if you have the latest version of the Microsoft Office suite and are using  Microsoft Excel 2013.

Once you open your Microsoft Excel 2013 spreadsheet, go to the Data tab and click on “From Web.”

import data from web in excel

Enter the URL from which you want your data to be taken in the line on top of the window that says “Address” and then click Go.

Read moreHow to Track Financial Data from Web in Microsoft Excel 2013

13 Free Online Tools to Create Text Pictures

Beautiful and appealing images and graphics can liven up any document, report, presentation, lesson or book. Graphics, photos, charts and other imagery are important not only because of their aesthetic aspect, but also because they help us convey our message more clearly, learn and grasp new concepts more easily quickly, and easily understand business and … Read more

How to View and Edit Microsoft Publisher Files without MS Office

microsoft publisherMicrosoft Publisher is a desktop publishing application that is included in some editions of Microsoft Office suite. It is not as popular and used as core Office applications like Word, Excel and PowerPoint. However, there are still quite a few users who consider it to be a simple way to create high-quality, professional looking and stylish publications.

So, it is safe to say that you’re likely to encounter .PUB and .PUBX files, especially if you are in the business of printing, publishing or simply reviewing and approving business publications like brochures, flyers, monthly company magazines and event resources. As Microsoft Publisher is included in more expensive Office suite editions, chances are you don’t have the right edition, even if you use MS Office suite. And, of course, it is quite possible that you are using on your Windows machine a completely different office productivity suite – LibreOffice, OpenOffice or Google Drive. So, there is really no out of the box way to open and view, let alone edit, that .PUB or .PUBX file with it being installed on your machine, because Microsoft doesn’t provide free viewer for Publisher formats even though it offers freely viewers for Word, Excel and  PowerPoint.

Then how can you view and edit that pesky .PUB file without appropriate Microsoft Office edition installed on your MS Windows machine?

[related id=”1589″]

Well, there is a workaround and a quick way to view the .PUB. And it’s free!

 

Read moreHow to View and Edit Microsoft Publisher Files without MS Office