Lesson 10 – Quick and Easy If Statements in Google Sheets/Spreadsheets
We go over how to add if statements into Google Sheets, a very important and useful formula
Lesson 6 – Quick and Easy Data Validation (Drop Down Lists, Avoiding Fatal Data Errors, Lists)
Data Validation is a great tool to use to both protect your spreadsheet from major data errors, but also to create drop down lists.
Lesson 8 – Graphs (How to easily make, edit, and add a trendline to a crisp graph in Google Sheets)
In this article, we will teach you how to make a graph in Google Sheets. But also how to edit it, and do some basic statistical analysis, such as adding a trendline.
How to easily and quickly freeze a row or column in Google Sheets (2020)
You may need to freeze a row or a column for easier readability in your spreadsheet. Here we teach you step by step how to do so.
How to embed hyperlinks into your spreadsheets (in 6 easy steps)
Introduction Today we will be teaching you a more unique type of formula, one which can be very useful in certain situations. We will teach you specifically, how to create a hyperlink within a spreadsheet. This way, you can create links (with whatever label you want), that once you click on them, will bring you […]
How to easily change decimals into percentages in Google Sheets (4 Simple, Foolproof Steps)
Have decimals but need to change them into percentages? Here we will teach you how to do so quickly in the click of a button
Lesson 5 – Top 10 Easy Google Sheets Formulas to Know For Beginners
Here we teach you 10 of the most useful and most used formulas in Google sheets, which are easy to learn for beginners.
Lesson 3 – Dragging Formulas and Absolutes (How to efficiently apply one formula to hundreds of cells in a matter of seconds)
This article will let you be able to drag and apply a formula to hundreds of cells, in the matter of seconds, by the method of dragging
Lesson 4 – Conditional Formatting Fundamentals (Beautiful Color Coding, Understanding Formatting Equations)
Conditional Formatting lets you easily color code items based on the contents of their cells. For example, you can create tables where all numbers above 5 turn green, and those below turn red. This is a beautiful way to clearly display your data, making it easy for others to understand.