How to Calculate Profit in Excel

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 for putting together a spreadsheet for calculating profit.

Create a table to include the following values: Income, Expenses, Profit, and Percentage. Fill in the Income and Expenses columns.

Once you have done that, you can select the currency you are working with on the ribbon.

bookkeeping tips Your table should now look something like this:

bookkeeping tips

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

bookkeeping tipsOnce you have received your profit amount, drag the corner of the cell to include the rest of your table.

bookkeeping tips

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

Continue reading >>

How to Create Thematic PDF Photo Albums from Instagram Photos

convert instagram to pdf albumInstagram, thanks to its widespread popularity among smartphone and tablet users, has become a treasure trove of amazing images showcasing special moments in our lives. As the vacation season is drawing to an end, chances are many of you have your Instagram accounts stacked with beautiful albums full of vacation photos – exotic beach escapes or crazy beach parties with your friends, breathtaking places around the globe, backpacking through Europe, captures of funny moments with your kids on a family camping trip, and so on.

Although Instagram provides a great way to share those memorable moments with your family, friends and virtually anyone else, there are occasions when a more traditional, PDF photo album better serves a purpose. It has multiple advantages like:

  • – PDF photo albums can easily be printed and shared in the most traditional way. Printed PDF album is a great gift for grandpas and grandmas!
  • – PDF albums can be enjoyed without an Internet connection, on any device, running on any operating system.
  • – PDF format is great for archiving and making backups of important files, such as vacation and family photos.

But is it actually possible to create a PDF album from Instagram photos? Continue reading >>