top of page
bobs logo.png

PORTFOLIO

Selection of articles & websites.

Layer

6/26/22

How To Use Goal Seek in Google Sheets

Goal Seek for Sheets is a powerful add-on for Google Sheets for data analysis. Here’s how to use Goal Seek in Google Sheets.

Layer

6/22/22

How To Merge Google Sheets (Manually & Automatically)

Oftentimes we need to combine data from multiple sheets into one master sheet. Here’s how to merge Google Sheets manually and automatically.

Layer

6/21/22

Google Sheets Macros: Enable, Create & Use Them

Google Sheets macros are a great way to automate repetitive tasks. Here’s how to enable, create and use macros in Google Sheets.

Layer

6/16/22

How To Share Only One Tab in Google Sheets

When sharing a Google Sheets spreadsheet Google usually tries to share the entire document. Here’s how to share only one tab instead.

Layer

6/15/22

How to Make Google Sheets Editable (by Multiple Users)

Google Sheets is the perfect collaboration tool. Here's everything about editing permissions and how to make google sheets editable for multiple users.

Layer

6/14/22

How to Share Google Sheets (Complete Guide)

Google Sheets is a fantastic tool for working in teams. Here’s everything you need to know about sharing permissions and how to share Google Sheets.

Whola

6/14/22

Wholesaler vs. Distributor vs. Supplier: What’s the Difference?

When you’re just starting your journey as a clothing store owner, it’s hard to wrap your head around all the stages of the fashion supply chain. How does a clothing item get from the manufacturer to the customer? Who works with whom? And why all the middlemen? In this guide, we’ll explain the entire process step-by-step.

Whola

6/14/22

How to Find a Niche for Your Clothing Store in 5 Steps

Serving a niche market is essential to making your clothing store stand out. But finding a niche that is profitable, popular and at the same time close to your heart is not so easy. Here’s our 5-step guide to finding a niche that you can get passionate about.

Layer

6/9/22

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

If you have various Excel files but would like to access the data in one centralized worksheet, this guide is for you.

Layer

6/8/22

How to Aggregate Data in Excel (Multiple Ways)

Aggregating your data often helps to better analyze and understand it. Here’s how to aggregate data in Excel with the AGGREGATE function or Power Query.

Layer

6/2/22

How to Track Changes in Excel (Step-by-Step)

If a colleague would like to update or review your Excel file, the option to track changes is very useful. Here’s how to track changes in Excel.

Layer

6/1/22

Data Entry Automation for Workflow Optimization

Manual data entry processes can be time-consuming and tedious. Many workflows can be automated. Here’s how to use automated data entry.

bottom of page