top of page
bobs logo.png

PORTFOLIO

Selection of articles & websites.

Layer

12/13/22

How to Add a Drop-Down List in Google Sheets

If a Google Sheet spreadsheet requires you to enter the same options over and over, you can make data entry easier by adding a drop down list. Here’s how.

Layer

12/12/22

How to Unshare an Excel Workbook Quickly and Easily

Sometimes, it’s necessary to control access and unshare an Excel workbook. Here's how to unshare an Excel file quickly and easily.

Layer

12/10/22

How to Add, Edit & Delete Comments and Notes in Excel

You can easily annotate and comment on Excel files for easier collaboration. Here's how to add, edit and delete comments and notes in Excel.

Layer

12/8/22

Excel Limitations: Problems, Issues, Disadvantages

Excel spreadsheets are a great tool for anyone who works with data. However Excel does have many limitations particularly when it comes to team collaboration.

Layer

12/6/22

How to Email an Excel Spreadsheet (Multiple Solutions)

Sometimes, you might have to send an Excel worksheet (or part of it) to your boss or colleague. Here's how to email an Excel spreadsheet as an attachment.

Layer

12/5/22

Audited Financial Statements: What You Should Know

An audited financial statement is a financial statement that has been reviewed by an independent auditor for accuracy. Here’s everything you need to know.

Layer

12/4/22

6 Excel Hacks and Tricks Anyone Should Know

From keyboard shortcuts to easy formatting hacks – these Excel hacks, tips and tricks will save you time and make you look like an Excel pro.

Layer

12/1/22

How to Calculate Cost of Debt

Cost of Debt is essentially the interest expense you pay on your business loans. Here’s how to calculate the Cost of Debt.

Layer

11/30/22

Create A Data Entry Form in Excel (4 Easy Ways)

If data entry is part of your daily work, then data entry forms can save you a great deal of time. Here’s how to create and use Excel data entry forms.

Layer

11/28/22

How to Calculate EBITDA

Earnings before interest, taxes, depreciation, and amortization (EBITDA) can be used to measure a company’s profitability. Here’s how to calculate EBITDA.

Layer

11/25/22

Annual Recurring Revenue (ARR)

The Annual Recurring Revenue (ARR) is a key metric for any subscription business. Here’s what it is, why it’s important and how to calculate it.

Layer

11/17/22

How to Consolidate Rows in Excel (Step-by-Step)

When you have columns with multiple duplicate rows, you may want to combine the rows and sum the values. Here’s how to consolidate rows in Excel.

bottom of page