Posts

Update to Google Sites

Image
If you work with a team, Google Sites is a great tool to improve communication and increase productivity. It allows you to organize your data in a user-friendly way. Additionally, it seamlessly integrates with other Google services, so you can easily add files directly from your Drive. Recently, Google made updates to Sites, and we are excited about it. At Efficient Small Business, we want to keep you up-to-date on the newest developments to improve your workflow. The "New" Google Sites has been around for a few years, but it did not come with many features when it was first released (compared to "Classic" Sites). However, Google is steadily introducing new functionality and updates to make this platform more robust. Here are a few of the most recent updates. Collapsible Text It is now possible, to create a collapsible text element. This is ideal if you have a lot of information that you need to share, but you don't want to clutter your whole page. ...

Connect Google Sheets to Cloud SQL Using Apps Script

Image
Occasionally, you have more information than a spreadsheet can handle. When you have a million or more rows of customer data, it may be time to switch to a database. But how do you keep using Google Sheets if your data is stored in a database? In this video, I demonstrate how to connect Google Cloud SQL to your spreadsheet using Google Apps Script. Interested in learning more about Google Apps Script and Google Sheets? Subscribe to my channel.

Free Tools to Help You Work Faster and More Efficient

Image
If you are looking for faster, more efficient ways to run your business (or to help your employees work), there are thousands of services that can automate or manage different aspects of its. Everything from human resources and accounting, to inventory management and receptionist, can be outsourced or automated. These services can save you a significant amount of time, but they often charge a monthly or annual fee. What if you could save the same amount of time without recurring fees or spending anything at all? Spreadsheets to the rescue! You’re probably aware that spreadsheets are one of the most powerful tools for any small business, and the spreadsheets you’re using have likely saved you a significant amount of time. Without them you would be using a pen, paper, and calculator to run your sales reports (ain’t nobody got time for that). The real power that spreadsheets provide is the ability to automate tasks. This includes calculating your reports, but it is only limited by your im...

How To Create A Professional Brochure With Google Docs

Image
If you've been looking for a program to create brochures and flyers, look no further than Google Slides! This member of the Google Docs family is designed for presentations, but it's easy-to-use drag & drop functionality make it perfect for designing small scale marketing collateral. In this video tutorial, I will show you tips and tricks to give your brochures a professional touch using this free online program. How to create a professional brochure with Google Docs: As you can see, Google Slides makes it very easy to create beautiful marketing content. When you are finished with your brochure, you can download it as a JPEG or SVG. Are you getting the most out of the programs your business is using? Find out by taking our free online Evaluation.