Basic Spreadsheets

Basic Spreadsheets

Google spreadsheet   July 12, 2020

Basic Spreadsheets

What is Google spreadsheets

Google Sheets is a free, cloud-based spreadsheet application. That means you open it in your browser window like a regular webpage, but you have all the functionality of a full spreadsheet application for doing powerful data analysis. It really is the best of both worlds.

No doubt you’ve heard of Microsoft Excel, the long established heavyweight of the spreadsheet world. It’s an incredibly powerful, versatile piece of software, used by approximately 750 million – 1 billion people worldwide. So yeah, a tough act to follow.

Google Sheets is similar in many ways, but also distinctly different in other areas. It has (mostly) the same set of functions and tools for working with data. In fact, some people mistakenly call it “Google Excel” or “Google spreadsheets.”

Google Spreadsheet Analysis

Google Spreadsheet Analysis

Google Spreadsheet Analysis   June 30, 2020

Google Spreadsheet Analysis

I love Google Sheets. It has a clean interface, it’s easy to collaborate with people and it integrates with other Google products that I use every day (like Google Analytics and Google Data Studio). It’s really easy to start using Google Sheets, but did you know it offers some great ways to get even more our of your data?

We’re going to cover a range of tips that will help you save time and do some awesome things, all using the power of Google Sheets! Let’s get started!

And if you like, you can jump straight to a tip:

• Send emails when you comment
• Add heatmaps using conditional formatting
• Apply filters
• Clean up values with CLEAN and TRIM
• Protect data in cells
• Validate data in cells
• Integrate with Google Forms
• Insert a chart from Google Sheets into a Google Doc
• Import data from a website or RSS feed
• Change capitalization in cells
• Translate text
• Split names and other data
• Check for valid email address
• Quickly summarize data
• Import data from other sheets
• Visualize data with a sparkline
• Create QR codes
• Quick data visualization
• Extend Google Sheets with add-ons
• Quickly learn formulas
• Keyboard shortcuts

Are you just getting started? Then take a moment to watch my Google Sheets tutorial for beginners. It’s covers important foundatio