top of page
bobs logo.png

PORTFOLIO

Selection of articles & websites.

Layer

3/30/22

How to Recover Unsaved Excel Files

If Excel crashed or you didn’t save your hard work, don’t panic! There are ways to retrieve your file. Here's how to recover an unsaved Excel file.

Layer

3/29/22

How to Insert a Hyperlink in Excel

Hyperlinks in Excel are more powerful than simply highlighting and adding the URL. Here's how to use hyperlinks in Excel spreadsheets to their full potential.

Sheetgo

3/28/22

The best invoice software in 2024

Invoice software automatically generates and sends invoices to the right customers. Let’s explore the top 5 invoice software for 2023.

Layer

3/24/22

How to Convert Excel to PDF (Quick & Easy)

There are different methods of how to save and export an Excel spreadsheet as PDF. Here's how to convert Excel to PDF quickly and easily.

Layer

3/22/22

How to Highlight Duplicates in Google Sheets

There are different methods of how to find and remove duplicates in Google Sheets. Here's how to highlight duplicates in Google Sheets.

Layer

3/20/22

Excel INDIRECT Function: Formula & Examples

INDIRECT allows to change the reference to a cell within a formula without changing the formula itself. Here's how to use the Excel INDIRECT function.

Layer

3/17/22

Google Data Studio Tutorial for Beginners

Google Data Studio is a powerful data visualization tool. Learn how to create beautiful dashboards in our Google Data Studio tutorial for beginners.

Sheetgo

3/17/22

Lend-out inventory template in Excel

This article explains how you can implement an automated, easy-to-use inventory lending system using Microsoft Excel into your business.

Layer

3/16/22

How to Add a Header and Footer in Excel

You can insert predefined or custom headers and footers to elevate your Excel spreadsheets. Here's how to add headers and footers in Excel.

Layer

3/14/22

How To Use Excel Power Query for Beginners

With Power Query, you can import data from different sources and prepare the data for analysis. Here's how to use Power Query in Excel.

Layer

3/10/22

How to Find and Remove Duplicates in Excel

Duplicate values in Excel can be a big problem. Here are several ways of how to find and remove duplicates in Excel.

Layer

3/9/22

How to Remove Blank Rows in Excel (Quick and Easy)

There are several quick and easy ways to remove empty cells in Excel spreadsheets. Here's how to delete blank rows in Excel.

bottom of page