Entries by glitch007

It’s time for you to create

Human beings are a unique breed. We have the ability to think and create things on a level unmatched by other species. It just baffles me just thinking about it. It is unfortunate that many of us fall victim into consuming more and more content and rarely end up creating anything. The good news is […]

Site Analytics

Here are the website stats that you can create with Google Sheets and Google Analytics.

If you're interested in learning a few tricks in Google Sheets, make sure you check out the original blog post and guide as well:

The video tutorial (created by the Official Google Analytics team) is at the bottom of this page.  The video is highly recommended because you can follow along as he does it.  It took me 30 minutes to create the graphs  (from scratch)

Visitors By Country


Visitors In the Last Two Weeks




Visitors By Browser




The video

Here are the website stats that you can create with Google Sheets and Google Analytics.If you’re interested in learning a few tricks in Google Sheets, make sure you check out the original blog post and guide as well: View the infographic (original post) The video tutorial (created by the Official Google Analytics team) is at the […]

Google Sheets : More Useful Than You Think

Hello Internet Neighbors!

Are you frustrated with spreadsheets?  Yeah, I know the feeling.  You probably know the basics, but there is just one little thing that you can't figure out... It sounds easy, but how the heck do you do it?

While I don't consider myself an expert, I know a few tips and tricks and have helped people with Excel, but it seems like Sheets is more popular online and I like the ability of looking up stock prices and sharing/embedded charts.

The guide covers just the most common features that you would use. The following infographic might help you out, (copyable text comes right after).

Let me know your favorite spreadsheet usages or if you have any questions, let m e know  in the comments below!





Try Out the Formulas

Head to sheets.google.com and try these formulas

  • =GOOGLEFINANCE("GOOG","price")
  • =COUNTIF(B:B, ">3")  - Count the number of items greater than 3
  • =COUNTA(B:B) - Count the number of non blank cells
  • =UNIQUE(B:B) - Show only unique items of column B
  • =IMAGE("the URL of image")
  • All the formulas (from the Google documentation)

Split Up Items

Do you ever run into situations where you want to make a comma separated into 2 or more columns?

Highlight the data, then go to: Data > Split Text To Columns

(you can specify another character to split on besides commas)

Filter Data

Once you have your data split into columns, you can assign names to each one of your columns

Now, go to Data > Filter

The Index-Match Formula

Q: You have two sheets mapping two different properties. How do you combine them?

A: Create a new column (in Sheet1) and use the “index match” formula

=index( [column to output (in table 2) ] , match( [ cell value you want to look up] , [column to look up the value in] , false) , 1)

If the second table is in another worksheet, use 'Sheet name'!A:A to reference column A

  • You have to put the sheet name in SINGLE QUOTES

Color the cells automatically

Select the column

Go to: Format > conditional formatting

You can highlight (and format text of) the cell with the following conditions :

  • cell value contains some text you specify
  • cell value is greater/less than (or between) certain dates/numbers or letters​

Count ALL THE THINGS!!!

So you have a list of items and want to count how many of each?

Select column A

Go to: Data > Pivot Table

  1. Under ‘Rows’, click Add field and select the column heading (e.g. ‘choice’)
  2. Under ‘Values’, click Add field and select the same column heading
  3. Select ‘COUNTA’ to count the number of entries

Embed Charts on Your Site

Select the columns/cells you want a chart for

Hold down Ctrl to select multiple cells

Go to : Insert > Chart

Did you know? You can get HTML embed code to publish the charts on your website!

Don’t have a site? Use sites.google.com create one quickly - if you can copy and paste text, then you can do this!

For website owners: Your Google Analytics in Charts

Using the Google Analytics spreadsheet add-on, you can: show visitors by country/browser or show # visitors for the past two weeks (these are just a few examples)

​The charts can be embedded and automatically updated!

Here are my charts

Leave a Comment!

Keep Guide Feedback

What did you like about the guide?
What would you like to update in the guide? e.g. an audio format, text on the mobile is too small? etc



Remove Picture What did you like about the guide? What would you like to update in the guide? e.g. an audio format, text on the mobile is too small? etc Done Thanks for the feedback

How do you stay productive [Results of Questionnaire]

Hello Internet Neighbors!

A while ago, I've posted links on Facebook, Reddit, and my family on Whatsapp asking how people keep themselves organized.  This was done so that I could get a better understanding of where people were coming from while I was writing my guide.  If you would still like to take the questionnaire, please see the link Facebook post below - you'll be able to get the guide at efficientHacks.com/Keep

This post is just to share the results that people gave.  If you've participated in this survey, thank you so much!

(I've received 45 responses total, which is actually more than I thought!)

And here are the results!

When you need to do a lot of things, how do you keep track of the tasks?  (check as many as you want)

Desktop app (Evernote/OneNote/Google Keep) 14
 
31%
Mobile app 19 42%
Sticky Notes/Writing on paper 25 56%
Email myself 10 22%
A spreadsheet 8 18%

 

Other responses (18 of 45 people responded)

  • Calendars
    • Calendar notes in cell phone
    • Calendar reminder in outlook
    • Microsoft Outlook Task & Follow up Tab
    • Google Calendar
    • Google Calendar
    • if only a simple task, i'll key into my calendar, make sure myself to finish it on time, no extend
  • I also use Google Inbox, which seems to have Google Keep tasks + email
  • Evernote
  • S Note (a mobile app)
  • I want a desktop app that easily syncs/pushes to a mobile app with reminders easily set for specific dates and times with the option to set an alarm half/hour/preset before the actual task is due, along with a reminder.
  • List on a whiteboard I look at everyday
  • White board and bullet listing
  • mark on diary.
  • notepad
  • Slightly biased, Things for Mac/iOS. I've been with it since closed alpha testing and stuck with it, because it's the only one that really works for me.
  • TeamGantt
  • Train your brains 🙂
  • Use my kids to remind me

All great tools, thanks for sharing!

In a typical weekday, how many hours do you have for leisure?

4+ 12 27%
3-4 12 27%
2-3 11 24%
1-2 8 18%
< 1 3 7%

 

When trying to get work done, a lot of time is spent: (check as many as you want)

Fighting with Photo/Video Editing Software 2 4%
Battling a word editor 9 20%
Cursing at your spreadsheet 5 11%
Responding to Email/Texting/Instant Messaging 30 67%
Facebooking 15 33%
Redditing 12 27%
Tweeting 2 4%
Some other form of news/social media 17 38%

I’m glad that you’ve identified your distractions, the first step to combatting procrastination is to acknowledge it.

The second step is to focus on your task, after that, feel free to go back to responding to people.

How do you stay focused while doing the task? (check as many as you want)

Headphones/Music 23 51%
Turn off phone/email 14 31%
Close browser 10 22%
Disconnect from Internet 12 27%
Reward myself afterwards 16 36%
Set a timer for X min 8 18%

 

Do you have any other techniques to help you stay focused?

  • Break down the task (usually a university essay or something similar) into smaller tasks and tick them off as I go.
  • Broken down lists
  • Change of scenery (ie library)
  • Coffee
  • do it after coffee break.
  • Create a space where nobody can bother me in anyway.
  • I keep my outlook email notifications off rather than completely cut off from emails. For me that’s the biggest distraction.
  • Keep quiet
  • Keep the end goal in mind
  • Listen to podcast
  • meditation
  • No distractions (turn off music, social media, etc)
  • Use the pomodoro technique ("tomato" in Italian, named after tomato-shaped kitchen timers).
  • Try and work in a public place, so I feel guilty if I'm off-task because of the other people around me.

Thanks for sharing! The Pomodoro technique is a good one. Try sleeping more too (so that you can rely less on coffee).

Just note that there is no one technique that works for everyone, only you know what works for you.

Finally...

Head over to efficientHacks.com/Keep for productivity tips implemented using Google Keep, a free app that stores your notes and reminders

Hello Internet Neighbors! A while ago, I’ve posted links on Facebook, Reddit, and my family on Whatsapp asking how people keep themselves organized.  This was done so that I could get a better understanding of where people were coming from while I was writing my guide.  If you would still like to take the questionnaire, […]

Keep Being Productive! Simplify the Way You Track Personal Tasks.

Hello Internet Neighbours!

What apps or techniques do you guys use to stay productive? I've evaluated and used a bunch of tools like Evernote, Asana, Wunderlist, etc. and I just found myself not using it because there were just too many clicks to go through. Now, I've been using Google Keep for a few years now, and I thought, wouldn't it be nice if there was a very quick start guide for people who don't really have the time to experiment with it?

The guide shows you how to organize your tasks and todos effectively with Google Keep. I've created an infographic, which is a tl;dr version of what the guide contains.

Finally, I'd be interested in knowing what productivity app you currently use - let me know in the comments below!

Not feeling productive some days?

Get some quick productivity mindsets.

The Infographic

If you use Pinterest, pin this by hovering over the image. Much appreciated!

Google Keep 7 Tips - Keep yourself organized!

Now a Word From the Advertiser





Finally... Get the guide 

Hello Internet Neighbours! What apps or techniques do you guys use to stay productive? I’ve evaluated and used a bunch of tools like Evernote, Asana, Wunderlist, etc. and I just found myself not using it because there were just too many clicks to go through. Now, I’ve been using Google Keep for a few years […]