How to Work with Pivot Tables in Google Sheets

Google Sheets is a spreadsheet program that is a part of Googles web-based office suite. The program represents an online alternative to Microsoft Excel but it’s compatible both with Microsoft and Open Office file formats.

Since its initial release, back in 2006, there is an ongoing debate whether people should use Google Sheets or MS Excel. There’s no right or wrong answer to this. It all comes down to specific needs and tasks.

Someone would praise Google for its simplicity and ease of collaboration. Others would argue that Google Sheets, compared to Excel is lacking in the functionality department

Continue reading →How to Work with Pivot Tables in Google Sheets

How To Visualize Data Instantly With Google Sheets Explore

Excel Spreadsheet Diagram

Working with big datasets is never an easy task. Tons of spreadsheet data divided into rows and columns can be frustrating and stressful so anything to boost our productivity is more than welcome. And this is where companies like Google step in.

From time to time, Google releases a new update, becoming smarter and more practical than before. This happened just recently, when Google released an update for its spreadsheet application, Sheets, making it possible to visualize spreadsheet data even more easily than before.

If you haven’t explored this updated feature yet, here’s a closer look at how and why you should, especially if you work with data.

Continue reading →How To Visualize Data Instantly With Google Sheets Explore

Get Last Minute Halloween Costume Ideas From Google Search Trends

Still stuck for costume ideas this Halloween? Don’t worry. There’s still time.

You can always quickly pull out last year’s costume, but no one ever wants to be the same thing twice. Thus, you may be hitting Pinterest, YouTube or Google for some quick costume ideas that’ll look good and is easy to put together.

But if you really want to know what’s hot and what’s not in terms of costumes, skip the ordinary Google search for images and ideas. This year you may want to try Frightgeist.

FrightGeist Google Search

This is essentially Google Trends with a Halloween twist.  Frightgeist is packaged as a guide on what costumes people are searching for and looking up in the US.

Google Trends pulls the top 500 costume search results that are going on and then ranks and visualizes that data so you can quickly see, at a glance, what others are thinking of dressing up as. You’ll also get a couple of handy FYI snippets on the costume related trends.

You can search for costumes that are trending nationally or locally by region. So if you’re partying it up across town, dressing up for the costume contest at work or trick treating with relatives in another state, you can customize your costume idea accordingly.

When you search locally, you’ll get a map to visually select your area. You can then hover over your region to view the top search trend in that area. Click through and you’ll get a rundown of other popular searches for that region.

FrightGeist Local Search​

Search nationally and you’ll see what’s trending on a much bigger scale. These results will show you the top trends list across the entire country.

When using the search box, you can type in a costume idea or have Fightgeist do the all searching with the “Surprise Me” button. It will randomly pull up a costume search result for you. Clicking on the button once, I get Wonder Man from the Marvel universe, who ranks 475 on the national trends list.

So use the results to start brainstorming ideas. Or use the results to avoid the popular trends and stand out with a costume no one else has. There’s a convenient “Show Something Less Popular” button that shows up when you view details on a popular costume trend.

But if you like dressing up as everybody else—that’s cool too. The button will turn to “Show Something More Popular” if you’re viewing a low trending costume idea.

It’s interesting to see how everyday tools can be put to cool uses like finding a Halloween costume. So don’t miss out on this tool and some awesome ideas. Give it a try and see what costume trend catches your eye.

 

5 Chrome Apps And Extensions Lawyers Should Be Using

Keyboard Law Technology

While it’s true that highly niched professionals like lawyers require a specific set of tools, sometimes something as simple as a Chrome add-on can be just as (or dare we say, even more?) powerful.

If you’re a lawyer looking for better, faster ways to get things done, working with Google Chrome can be a plus.  Whether you’re on the web for legal research, accessing databases, or working remotely outside of the office, Chrome offers a long list of apps and extensions to help improve the way you work.

And the right ones can make a world of difference.

So take your online productivity up a notch. A couple of these Chrome apps and extensions can speed up the most common and time consuming tasks.

Collect Online Evidence With WebPreserver

When you have cases involving social media harassment, incriminating posts, or cyberstalking, it automatically means spending hours online gathering screenshots. Not only that, but your research needs to be legally admissible. Luckily, there’s an extension for that: WebPreserver.

This Chrome extension will allow you to preserve, timestamp and authorize your findings with a single click. The extension links you to a web capture system designed for law firms and agencies to instantly create legally admissible evidence.

Research More Effectively On WestlawNext With Bestlaw

This next Chrome extension is centered upon offering you an expanded toolset to improve your workflow with WestlawNext. Bestlaw claims to add the features WestlawNext forgot.

WestlawNext Research Toolbar

Image Source: Bestlaw.io

Bestlaw does this by adding a toolbar to the document you’re reading. With it, you can copy Bluebook citations, generate table of contents, jump to footnotes, look up case information on Google and Wikipedia, share documents via email or social media and more.

Use Locate A Lawyer To Quickly Find & Consult With Other Lawyers

Looking for another lawyer? Use Locate A Lawyer  in your search. Developed by LawInfo.com, Locate A Lawyer can give you quick access from Chrome to its directory of pre-screened attorneys, all with verified qualifications and credentials. You can easily search by name, zip code, firm, and area of law.

Use Agilewords To Speed Up Legal Document Reviews

The review and approval process is necessarily a lengthy one at times, especially for legal documents that need feedback, editing, updating, and approval. For lawyers who need to collaborate on legal document, there’s Agilewords, the document reviewing tool you can access directly within Chrome.

This tool provides you with features such as real-time collaboration, secure uploading and hosting, revision tracking, online/offline editing, and the ability to audit your document’s access.

Instantly Look Up Citations From Webpages With Jureeka!

When researching a case, you may come across web pages with legal citations that appear throughout the article that aren’t hyperlinked. This Chrome extension can save you that hassle of toggling back and forth, looking up citation sources.  Jureeka! will turn those legal citations into hyperlinks as long as it is on a web page. So even if the author of the article does not link the citation, Jureeka! does.

7 Google Drive Tips To Make Online Research Easier

When you need to learn about something, the Internet is the number one resource to scout out.  And given the amount of information you can find online, no matter what area, industry, or topic you’re researching,  a huge chunk of your time will be spent recording the research you find.

As you can imagine, combined with the web pages you have to go through, this can slow you dow big time. That’s why some users like to keep their workflow online with tools like Google Drive.  But if you’re using Google Drive to quickly record data, then your biggest challenge lies in working between your research and how you use Google Drive itself.

If you’re writing for an online publication, are drafting a research paper, or are reporting on industry trends, accessing the information you record is perhaps one of your main priorities. To make things easier, try a few of the Google Drive tips below to keep your research going smoothly.

1.  Perform A Google Drive Search from Chrome

Because you can need a document at any given time, it’s important to be able to pull up the right file in an instant. Google Drive Quick Search makes it easy to start a search through your Drive directly from the Chrome URL address bar. Type “drive” in the address bar, your keywords and query, then hit enter. You’ll be directed to your drive with the related results ready and waiting for you to sift through.

2. Save Your Text to Google Drive

Save Text to Google Drive does exactly what its name implies. This Chrome extension makes it super easy to export heavily dense text webpage research from the web directly to your Google Drive.

Save text to Google Drive

Once installed, simply highlight the text you’re interested in, activate the extension by clicking on it in your toolbar or extension menu, and click on the Save button. The extension will create a document with the text in the Drive you’re logged into.

3. Quickly Access Folders and Create Google Docs From Your Toolbar

To access folders and separate files instantly, simply bookmark the URL of the file or document on your toolbar.  Open the file or folder in Google Drive and bookmark the URL you see in the address bar. Admittedly, this is a simple tip, but extremely handy if you like keeping things at your fingertips.

Creating Google Docs Instantly

 4. Search Your Google Drive Directly From Gmail

Don’t waste time going back and forth between your Google Drive and Gmail.  You can do both at the same time by adding the Apps Search for Gmail extension. This is handy for when you’re either exchanging emails regarding your research project or are working with colleagues.

It will let you extend your search to Google Docs to fish out the files you’re looking for.  You can add the extension by going into Settings>Labs from your Gmail.  Then select to enable it for your account. Don’t forget to hit the “Save Changes” button at the bottom.

5. Edit PDF Text Uploaded To Google Drive

Because a lot of research comes in the PDF format, you may want to pay attention to the “Convert Text from Uploaded PDF and image files” setting. Have you been ignoring it? Well, it’s time to start paying attention to it. This setting allows you to convert PDF to text which you can then  edit within a Google Doc.

Convert text from PDF

Go to the gear icon Google Drive and access the drop down menu. Then go to Upload Settings. From there, put a check mark in the “Convert Text from Uploaded PDF and image files”  option by clicking on it.  Select the Document language. You can have this permanently turned on, but if you want to use it selectively, keep the “Confirm settings before each upload” option checked.

6.  Save Images Directly to Google Drive

Who doesn’t clip web pages when researching online? Good news is you can do it with Google Drive. Save to Google Drive can serve as a simple web clipping tool, allowing you to instantly save content from the web to a Google Drive folder. Once you have it installed,  go to the page you’re interested in and activate it by clicking on its button to the right of the address bar.  It will then save your content in .PNG format.

7. Access Google Drive And Other Google Services From Chrome

Here’s a great Chrome extension for pushing your research productivity to the limits. Black Menu for Google allows you to access files on your Drive and to your other Google services in a side bar right within Chrome.

Perfect for Google addicts with research spread across different services. You can get the Black Menu extension from the Chrome Web Store.

Got any Google Drive tips of your own? We’d love to hear them! Add them in the comments below and let us know how they helped you deal with your web research.