Media training 101 for small businesses

-
Image
Great news: you just scored a big press interview to promote your business. The story will expose your brand to the perfect new audience and drive meaningful traffic to your website. So…don't blow it. Yes, just as quickly as the excitement for the opportunity arrived, the realization that you now have to do an interview sets in. I get it—press interviews can absolutely be intimidating. The resulting coverage represents a significant opportunity to acquire new customers, drive sales, or raise awareness, and you want to be sure to represent your brand well and really compel the audience to check out your company. On top of that, you have to contend with adrenaline and nerves in the moment. You may be thinking, "So many other business owners are so polished and articulate in their interviews. How am I going to pull that off?" Deep breath. A successful interview is usually the result of good media training: preparation and practice in advance of an interview. I've tr
1 comment

Google Sheets: App of the day

-

No matter what your line of work is, one thing unites most knowledge workers: the spreadsheet. From number-crunching to planning projects, spreadsheets are a workplace staple—and a common source of frustration for some.

There's no denying that Google Sheets has changed the spreadsheet game. First, it's web-based, so anyone can use it—for free. But just because it's free doesn't mean it skimps on features.

Google Sheets uses the same terminology and has many of the same functions as Microsoft Excel, such as formulas. Along with standard functions, such as AVERAGE and SUM, Sheets also has unique ones to translate text into different languages and even import an RSS feed right to your spreadsheet.

You can also create pivot tables within Google Sheets—which can summarize and analyze your data more efficiently—and turn your spreadsheet data into beautiful charts and graphs.

We should also mention that it auto-saves. How many times have you lost a file because you forgot to save, or your computer crashed? No more tears in your keyboard over lost files.

Just like other G Suite products, Sheets' collaboration features make it easy to share and edit spreadsheets with your team, so you can have a few more helping hands on that 1,000-row sheet. You can set blanket sharing and permission levels, or customize it per person.

Don't want to make permanent changes to a spreadsheet? You can make suggestions and add comments for your colleagues to review. If you lose an important piece of data, don't worry. Google Sheets saves automatically and keeps records of your version history, so you can revert to a previous version if necessary.

Need your spreadsheet to do a specialized task, such as detecting and deleting duplicate rows automatically? You can build and publish custom add-ons with the Google Apps Script to take your spreadsheets to the next level. Don't know code? Browse the Google Sheets add-on store to see what features others have built.

And even though Google Sheets is web-based, you can save a file as a PDF, Excel, or other formats so you can get your spreadsheets to the right people.

If you're looking for a better way to crunch numbers and collaborate with others, look no further than Google Sheets. It'll turn your love-hate relationship with spreadsheets into a full-on lovefest.

You can automate your spreadsheets with Zapier's Google Sheets integrations. Here are a few popular Google Sheets workflows to get you started:

New to Zapier? It's a tool that helps anyone connect apps and automate workflows—without any complicated code. Sign up for free to use Google Sheets with Zapier.



from The Zapier Blog https://ift.tt/2XqiUEI

Comments

Post a Comment

Popular posts from this blog

If Time-Tracking Apps Don't Work for You, Try a Productivity Journal

-
Image
Monitoring how you spend your time leads to a wealth of useful information: It can tell you what time of day you're most productive , help you create better estimates for how long tasks will take, and show you what activities you'd have to cut to focus your energy on a new idea or project. The most precise way to monitor how you spend your time is to use a time-tracking app . But these apps require a lot of overhead. You have to diligently log your hours (or make sure your app is logging them correctly) and sort your tracked time into categories. You have to pause after every task—no matter how brief—to capture time spent accurately. If tracking your time at such a granular level sounds like a punishment, but you still want insight into how and where you spend your time, consider the less menacing sibling of time-tracking apps: a productivity journal. What Is a Productivity Journal? I kept a journal as a preteen, though in those days I called it a diary. Snoopy and Woods
Read more

The 25 Best Productivity Apps for iPhone in 2018

-
Image
The best productivity apps for iPhone make possible something that would otherwise be impossible, or they make something you need to do simpler and faster. Imagine being asked, unexpectedly, for a copy of a tax form from last year as proof of address during an important appointment that you traveled many miles to attend. In fact, it happened to me, and thankfully I had a copy of the document I needed saved to a file syncing application, which meant I could pull it up on my phone and show it to the gracious Customs and Border Protection officer who demanded to see it. If that's not productivity by way of efficiency, I don't know what is. Perhaps a more routine example is keeping track of time spent in an off-site meeting so that you can claim it as an expense later. If you have the right time-tracking mobile app, you can record the time on the spot rather than having to estimate it and remember to record it later. The use cases for productivity apps are infinite, and sometimes
Read more

Forget Folders: The Best Ways to Organize Your Files with Tags and Labels

-
Image
Trying to find old files is like trying to go back in time and read your own mind. Where would I have saved those pictures from Australia?!? you think, before spending a frustrating half hour digging through folders and folders of miscellaneous images. What would I have called that report I wrote in August 2012?!? Tags (or labels in some apps) can eliminate these exasperating and time-consuming mental exercises. With a couple of tags, you can instantly categorize and label files for hassle-free searches down the road, and then find all of those files again easily no matter where you save them. Let's explore why tagging is so useful, and how to set up your own tag system. Then, we’ll dive into how to tag your emails, photos, notes, and files, and glance at the benefits of using tags alongside folders. Intro to Tagging Tagging Best Practices How to Tag Folders How to Tag Emails How to Tag Photos How to Tag Notes How to Tag Files Turn Tags into Actions Intro to Taggi
Read more