Getting Comfortable With The Basics

Productivity

Count the Days Between Two Dates in Google Sheets

Count the Days Between Two Dates in Google Sheets – By Ben Stockton howtogeek.com

If you want to count the number of days between two dates, you can use the DAYS, DATEDIF, and NETWORKDAYS functions in Google Sheets to do so. DAYS and DATEDIF count all days, while NETWORKDAYS excludes Saturday and Sunday.

Counting All Days Between Two Dates
To count the days between two dates, regardless of whether the day is a weekday or a holiday, you can use the DAYS or DATEDIF functions.

Add the Current Date and Time in Google Sheets

How to Add the Current Date and Time in Google Sheets – By Ben Stockton howtogeek.com

Rather than manually inserting times and dates into a Google Sheets spreadsheet, you can use the NOW and TODAY functions. These functions show the current time or date, updating as your spreadsheet changes or on a regular basis.


How to Use the AND and OR Functions in Google Sheets – By Ben Stockton howtogeek.com

If you’ve ever wanted to check whether data from your Google Sheets spreadsheet meets certain criteria, you can use AND and OR. These logical functions give you TRUE and FALSE responses, which you can use to sort through your data.

– Google Sheets Tips

How to Freeze or Hide Columns and Rows in Google Sheets – By Ben Stockton howtogeek.com

The greater the number of rows and columns in your Google Sheets spreadsheet, the more unwieldy it can become. Freezing or hiding rows and columns can make your spreadsheet easier to read and navigate. Here’s how.


How to Merge Cells in Google Sheets – By Brady Gavin howtogeek.com

Merging cells in Google Sheets is a great way to keep your spreadsheet well-organized and easy to understand. The most common use is for headers to identify content across multiple columns, but regardless of the reason, it’s a simple process.


How to Add or Remove Rows and Columns in Google Sheets – By Brady Gavin howtogeek.com

Google Sheets lets you add rows or columns to an existing spreadsheet on the fly to help you organize even better. Whether you want one or ten, above or to the right, here’s how to insert rows and columns into Sheets.

How to quickly scan documents with the Google Drive app

How to quickly scan documents with the Google Drive app – By Sydney Butler 9to5google.com

Unless you have huge pockets, chances are that there’s no document scanner on you most of the time. However, plenty of people have figured out that they can simply take a picture of any document with their smartphone. That’s a smart idea, but the Google Drive app actually has a supercharged camera-based scanning function that takes this simple trick to the next level. Let’s learn how to scan documents to Google Drive.

Web Browser is Running Slowly and How to Fix It

Why Your Web Browser is Running Slowly and How to Fix It – By gizmodo.com

We do just about everything inside a browser nowadays—stream movies, write essays, chat with friends, edit photos—and serious slowdowns inside this key bit of software can have a serious impact on how much we get done. With that in mind, these are the reasons that your browser is slowing down, and what you can do to fix it.

Android 10 features how to use them

8 of the best Android 10 features and how to use them – By Jason Cipriani cnet.com

Google's new Pixel 4 and Pixel 4 XL phones run Android 10, Google's newest Android operating system that launched for older Pixel phones in September. More devices will gain the latest version of Android in the near future. Google recently announced Android 10 as the official name, replacing Android Q and the dessert naming scheme Google has always used. Operating system updates like Android 10 add new features and capabilities and can be refreshing if you're growing tired of your phone. Google released the first beta of Android Q in March, and we've been testing it all along. 

– Photo Editing Apps Photographers Love

7 Photo Editing Apps Photographers Love – By Michelle Rae Uy techlicious.com

For the record, if you want or need to do professional-grade editing work on your photos, there's nothing better than Adobe Lightroom and Photoshop. Lightroom not only has a fantastic image cataloging system, it also allows for more control and flexibility when making edits and doing fine-tuning. Photoshop, on the other hand, allows for more precise photo altering.

Customize your Chromebook’s desktop

Chromebook 101: how to customize your Chromebook’s desktop – By JR Raphael theverge.com

Chrome OS isn’t the most option-packed operating system around, but there are some things you can do to make your Chromebook’s desktop look and work the way you want.


The best Chromebooks for 2019 – By CNET seattletimes.com

Consider the Chromebook, the (mostly) economical laptop that runs on Google’s browser-based operating system, Chrome. The OS is naturally suited for the cloud-based services prevalent in modern work life. But it’s also great for watching movies, listening to music and, of course, browsing the internet.


How to Shop for a Chromebook – By Andrew Heinzman reviewgeek.com

Chromebooks are a powerful, affordable alternative to Windows laptops and MacBooks. While they can fulfill just about any need, picking the right one is crucial. Here’s how to choose the Chromebook that will work for you.

How To Use A Password Manager

How To Use A Password Manager  – By Tyler Leeubergizmo.com

Using the same password for all your online accounts is probably the worst idea ever. This is because in the event your password is leaked, hackers will be able to access all your online accounts and services.


Best password managers: Reviews of the top products  – By Michael Ansaldopcworld.com

We are terrible at passwords. We suck at creating them (the top two most popular remain “123456” and “password”), we share them way too freely, and we forget them all the time. Indeed, the very thing that can ensure our online security has become our biggest obstacle to it. This is what makes a good password manager essential.

Google Drive Tips

5 Google Drive Tips You Might Have Overlooked or Forgotten – By freetech4teachers.com

Google Drive is the core of many aspects of G Suite for Education. There are lots of little features of Google Drive that are often overlooked or simply forgotten about. Many of those little features can improve your Google Drive experience. So as we head into the new school year, take a look at these five Google Drive settings that you might have overlooked or just forgotten about.

14 incredibly useful things you didn’t know Google Drive could do

14 incredibly useful things you didn’t know Google Drive could do – By JR Raphaelfastcompany.com

If you’re thinking of Google Drive as a mere place to plop your files, you’re missing out on some pretty powerful possibilities.

Beneath its fluffy cloud exterior, Drive holds all sorts of useful tools for collecting information, working with data, organizing your virtual goods, and sharing stuff externally. In some cases, the options are built directly into Drive; in others, they require a little help from a connecting app or service.

10 Can’t-Miss Gmail Tips and Tricks

10 Can't-Miss Gmail Tips and Tricks That Will Change the Way You Email – By Currie Engeltime.com8 min
Summer usually means a vacation from your Gmail inbox. But all your unread emails aren’t going to get answered on their own (well, actually, they might — but I’ll get to that later). Over 281 billion emails were sent last year, according to Radicati, a tech marketing firm. And that number will only grow, hitting 330 billion in the next three years. That’s a lot of emails that will require our attention.

LastPass Password Manager Review

LastPass Password Manager Review— Worth Downloading? – By Gwynn Ballard securitybaron.com

We all heavily depend on password-protected sites and apps. Between social networking, work emails, personal emails, and online banking, using the same password for everything may seem convenient. But using one password across multiple accounts makes you much more vulnerable to hackers and security breaches. Luckily, there are password managers that allow you to store all of your unique passwords in one place.


The Five Best Password Managers – By Alan Henrylifehacker.com12 min

A while ago, all it took to be a great password manager was to keep your passwords in an encrypted vault. Now the best password managers give you the option to sync or keep them local only, change web passwords with a click, log in to sites for you, and more.

How to Protect Cells From Editing in Google Sheets

How to Protect Cells From Editing in Google Sheets – By Brady Gavin, www.howtogeek.com

Protecting individual cells in Google Sheets is a great way to prevent data in your spreadsheet from getting changed—accidentally or intentionally—by anyone viewing the sheet. Fortunately, Sheets provides a handy tool to protects people from altering cells in your document.

Chromebook Touchpad Gestures:

Chromebook Touchpad Gestures: How to Navigate Chrome OS Like a Pro By Phillip Tracy, www.laptopmag.com

Chrome OS earns praise for being an easy-to-use operating system but there's still a learning curve for new users, especially those who are coming from Windows 10 or macOS. To navigate Google's operating system efficiently, you'll first want to master your Chromebook's touchpad gestures.

The Best Grammar Checkers For Every Type Of Writing

The Best Grammar Checkers For Every Type Of Writing by Jennifer Allen  @jenjeahaly

We all want to write better and more effectively. It’s easy to become both paranoid and complacent over one’s writing style. Fortunately, there are plenty of online services that help by checking your grammar. We’ve looked at some of the best grammar checkers out there.

Use Your Password Manager for Security Answers, Too

Use Your Password Manager for Security Answers, Too By David Murphy, lifehacker.com

It’s been a while since I’ve had to type in some stupid answer to a made-up question when creating an account on a new service. You know what I’m talking about: Forget your password, and you can regain access to your account by typing in the name of your first pet (Mr. Mrglglrm), your favorite sports team (Saskatoon Sirens), or the street you grew up on (Third Street).

– Grammarly, an online grammar checking tool

Grammarly Review: Is Grammarly Worth All The Hype? by bloggingocean.com

Do you make a lot of grammatical and punctuation errors? Don't worry; you are not the only one to face this problem.

Grammarly, an online grammar checking tool, claims to make writing a lot easier by proofreading your content in real time as you type. Off late, it is gaining a lot of popularity and is being used and recommended by many people.


Grammarly – Advanced grammar and spell checker for iPad and Mac by michaelkummer.com

Grammarly is an advanced grammar and spell checker for iOS and the Mac. It helps me to write better copy at work and in my capacity as a blogger. If you write as much as I do, I would highly recommend to check it out.

Tired of Pasted Text Messing Up Your Formatting? Try This

Tired of Pasted Text Messing Up Your Formatting? Try This by howtogeek.com

You paste text into a document and for some dumb reason the formatting comes with. Gah! Here’s how to stop that.

Pasting text without formatting is possible on both Windows and macOS, assuming you know the correct keyboard shortcuts—typically Ctrl-Shift-V on Windows and Command-Option-V on macOS.

How to log in to multiple Gmail accounts at once

How to log in to multiple Gmail accounts at once by digitaltrends.com

Have you found yourself rapidly accumulating Gmail accounts? Between work, school, and any personal or spam accounts you may have created, it’s completely reasonable to have three (or more) Google accounts that need to be checked regularly.

It can be annoying (not to mention time-consuming) to log in and out of each of your accounts every time you want to use them. Luckily, Google makes it easy to log in to multiple Gmail accounts at once and quickly switch between them on your phone and computer. Here’s how to make use of Google’s multiple sign-in feature.

Customize Swipe Gestures on Mail, Gmail, and Inbox

How to Customize Swipe Gestures on Mail, Gmail, and Inbox by lifehacker.com

To be honest, I’m not sure what different swipes do on your favorite email app, because every app is a little bit different. And it’s possible that you don’t like how your favorite email app handles swiping. Maybe you’d rather delete messages than archive them; maybe you just like swiping in one direction over another.

Windows 10’s Backup and Recovery Tools

How to Use All of Windows 10’s Backup and Recovery Tools by howtogeek.com

Windows 10 includes several different types of backup and recovery tools. And we’re going to take a look at all of them.

Sometimes, bad things happen to good computers. Fortunately, Windows includes a number of tools you can use to make sure your files are properly backed up and to recover your computer should you need to. On the backup side of things, File History is the…

Google Translate’s Offline Mode Just Got a Lot Better

Google Translate's Offline Mode Just Got a Lot Better by lifehacker.com

Google Translate is an app that’s been critical to my success when traveling in other countries. When you don’t speak the language (or don’t speak the language well) somewhere you’re traveling, being able to quickly look something up, or speak into the phone to create a translation you can use to chat with that guy on the street can be a lifesaver. 

Extensity – Enabling and Disabling All Your Extensions for Google Chrome

Chrome extension that allows you to enable and disable all of your extensions within Google Chrome. Ideal tool to efficiently manage your Chrome extensions.

Tired of having too many extensions in your toolbar? Try Extensity, the ultimate tool for lightning-fast enabling and disabling all your extensions for Google Chrome. Just enable the extension when you want to use it, and disable when you want to get rid of it for a little while. You can also launch Chrome Apps right from the list.

  • Keep your browser fast – disable extensions that you won't use right away.
  • Keep your toolbar clean
  • An ideal companion for extensions collectors.
  • Turn all extensions off (and back on) with a single click.
  • Quick switch between several extensions groups using the Profiles feature.
  • Keep computers in sync with Chrome Cloud Storage support.

Resize Photos In Windows, Mac & Chromebook

Image Resizer Online Is a Fast Image Resizer

Image Resizer Online does all image resizing in the browser, so you do not need to upload any photos to the server to resize the pictures. Not uploading also allows you to keep your photographs secure as all the images stay on your computer at all times as well as using no bandwidth for sending copies to a server which also makes Image Resizer Online very fast. Or visit: https://imageresizer.online/

Installing the Chrome Extension lets you use the tool with a Chromebook.

Or visit the Web Site to use the tool online directly: https://imageresizer.online/

About

Image Resizer Online was created for a simple reason, to make resizing images online as simple, secure and fast as possible. Image Resizer Online does all the image resizing in the browser which means that your pictures stay on your computer at all times, they never get sent to a server to be processed like many other services.

Image Resizer Online is actively being worked on to improve functionality and user experience. We want to make image resizing and conversion as fast and as simple as possible.

Why use Image Resizer Online

  • Works with Windows, Mac, and Chromebooks.
  • Pixel or percentage based image resizing
  • Image Resizer Online can convert images to JPG, PNG, GIF, TIFF, and WebP (Chrome only)
  • Image Resizer Online can compress JPG and WebP images.
  • Very fast. Because Image Resizer Online runs in your browser, it's extremely fast.
  • Batch image processing. Image Resizer Online can batch process images which means that you can select multiple photos and process them all together. 

Need more features check out TinyPNG.

Why use TinyPNG?

PNG is useful because it’s the only widely supported format that can store partially transparent images. The format uses compression, but the files can still be large. Use TinyPNG to shrink images for your apps and sites. It will use less bandwidth and load faster.

 

 

Make Fake Email Accounts for Website Signups

Make Fake Email Accounts for Website Signups Using the 'Burner Emails' Extension by lifehacker.com

Chrome and Firefox: There are plenty of reasons you might not want to give out your real email address when signing up for a site or service. Maybe you’re really big on privacy; or, more likely, you just hate spam, and figure the fewer places that know your real email address, the better.

This Savings-account Hack Will Give You Almost 20 Times What You’re Earning Now

This Savings-account Hack Will Give You Almost 20 Times What You’re Earning Now by marketwatch.com

The world is awash with cash, but you don’t seem to be getting any of it from your bank account.

Banks pay almost nothing for deposits these days — the average savings account gives customers 0.09% a year, according to Bankrate. That means you’d earn $9 a year on an account worth $10,000.

How to Use PayPal via Google Pay on YouTube, Gmail, and Google Play

How to Use PayPal via Google Pay on YouTube, Gmail, and Google Play by lifehacker.com

You can already use your PayPal account to make purchases through Google Pay. Now, Google and PayPal are extending their partnership to allow you to use your PayPal account to pay for things across the Google ecosystem, including Gmail, YouTube, and the Google Store. Better yet, if you link your PayPal account to Google Pay, you won’t have to keep signing in to PayPal every time you want to make a transaction. 

For $250, laptops don’t get better than this

For $250, laptops don't get better than this by laptops.reviewed.com

Ah, Chromebooks. They may not be everyone's cup of tea, but I'll continue to praise them for as long as I walk this mortal plane. I mean, what's not to love? They're secure, affordable, and durable. The only complaint I ever have is that they're plain-looking. Well, that's not the case with the Acer Chromebook 11

Google I/O 2018 – Duplex: A.I. Assistant

Google just gave a stunning demo of Assistant making an actual phone call by theverge.com

Onstage at I/O 2018, Google showed off a jaw-dropping new capability of Google Assistant: in the not too distant future, it’s going to make phone calls on your behalf. CEO Sundar Pichai played back a phone call recording that he said was placed by the Assistant to a hair salon. The voice sounded incredibly natural; the person on the other end had no idea they were talking to a digital AI helper. Google Assistant even dropped in a super casual “mmhmmm” early in the conversation.

Tech News by Topic