What is a spreadsheet?

Free open source spreadsheets

Creating a spreadsheet

Formatting data

Currency formatting

Getting the spreadsheet to work

Copying formulas

Range Functions

Average function

Advanced spreadsheet features

Introduction

Linking Cells in Google Sheets

Linking Ranges in Google Sheets

Linking separate spreadsheets in Google Sheets

Introduction

Creating a New Spreadsheet

Spreadsheet Rows, Columns and Cells

Entering Data into a Spreadsheet

Dealing with Dates

Extending Date Ranges

Number Formats

Calculations

Sums and Functions

Font and Cell Formatting

Sorting Data

Importing and Exporting Excel , PDF and other formats

how to create a new spreadsheet using drive.google.com and sheets.new

how to convert .csv and .xlsx files to Google Sheets files

how to create sheets inside of a spreadsheet - how to color, organize, and navigate through them

how to add columns in Google Sheets, how to freeze columns and rows

using Google Sheets as database

format data and cells

most useful shortcuts

smart spreadsheet features: pasting values, format, transposed, sequences, using Math operators (* / + -)

formulas in Google Sheets: SUM, AVERAGE, COUNT

using comments and notes to collaborate right in the spreadsheet

Accessibility Legislation

Mark Up Headings

Web Aim Color Contrast Checker

Font

Check Accessibility

Is There Guidance on Placement of Logo Images

Is There Accessibility Guidance for Other Programs like Sharepoint Power Bi and Word Docs

What about Tables That Have Subheadings in the Table

Background Fill

Subscribe to the Analysis Function Newsletter

how to create a new spreadsheet using drive.google.com and sheets.new

how to convert .csv and .xlsx files to Google Sheets files

how to create sheets inside of a spreadsheet - how to color, organize, and navigate through them

how to add columns in Google Sheets, how to freeze columns and rows

using Google Sheets as database

format data and cells

most useful shortcuts

smart spreadsheet features: pasting values, format, transposed, sequences, using Math operators (* / + -)

formulas in Google Sheets: SUM, AVERAGE, COUNT

using comments and notes to collaborate right in the spreadsheet

Full Overview: The All-in-One Spreadsheet

Introduction to Data Types

Introduction to the Table Header Row

Introduction to Views (e.g. Kanban, Gantt, Forms, etc.)

Introduction to Kanban Views

Introduction to Gantt Views and Project Management

Introduction to Forms and Form Views

Introduction to Related Rows

Introduction to Automations and Integrations

Importing from Excel, Google Sheets, and CSV

Shared Spreadsheet for Project Management

Add Explanation to Every Tab

Make Deadlines Obvious

Hyperlink to Specific Tabs

Use Descriptions below Header Rows

Data Validation is Your BEST FRIEND

Use Formulas Whenever Possible

Import Raw Data Properly

Key Info Tabs

Raw Data Tabs

Share Spreadsheet with Teammates

Introduction

Why Are Spreadsheets Still Important?

Microsoft Excel

Apple Numbers

Google Sheets

Quip

EtherCalc

Zoho Sheets

LibreOffice

Apache OpenOffice Calc

Smartsheet

Airtable

Stackby

SeaTable

Recap

Subscribe to Jotform

Introduction: 7 typical spreadsheet problems

Problems adding product information to your database

Problems controlling access/permission levels in spreadsheets

Spreadsheet collaboration issues

Dealing with large numbers of SKUs in spreadsheets

Problems managing product images in spreadsheets

Problems checking data completeness in spreadsheets

Problems sharing data with other software and platforms

Spreadsheet alternatives

Welcome

Starting with a Blank Workbook

Ribbon Groups

Cells

Entering Data

Entering Text in Excel

Entering Data in a Cell

Drag and Drop

Select to effect

Conclusion

Start

Introduction

Accessing Google Sheets

Navigating in Cells and Menus

Keyboard Shortcuts

Editing Cell Contents

Templates

Using Explore

Opening and Saving Sheets

Using Google Drive with Google Sheets

Showing and Using the Formula Bar and Gridlines

Basic Formulas

Using Autofill to Copy Formulas

Using Autofill to Create Redundant Data

Simple Formulas

Formulas with Absolute References

Cut, Copy, and Paste

Inserting Rows and Columns

Wrapping Text, Rotating, and Aligning Cells

Cell Formatting

Hiding Rows and Columns

Freeze Panes and Full Screen View

Spell Check and Printing

Sharing and Emailing Sheets

Conclusion

Intro

Using the importrange() function

Conclusion

Introduction

Not just a spreadsheet replacement

Save time with powerful automations

Introduction to Spreadsheets

Example of a Spreadsheet

Dynamic Charts

Navigating to Google Sheets

Opening a Blank Sheet

Entering Data

Logical Formulas

Summary

Benefits of Sharing a Spreadsheet

Making charts with spreadsheets