Airtable for Entrepreneurs

Name: Airtable for Entrepreneurs
Rating: 4.4 (326 reviews)

The ultimate guide to online business databases

Created byJohn Whitford

Last updated 10/2016

English

What you'll learn

Create an interactive and public database capable of running their own small business
Analyze their data using sorting, filters, grouping, and formulas
Feel comfortable operating Airtable from both desktop and mobile

Course content

4 sections • 22 lectures • 1h 29m total length

Creating your Airtable account2:17
Getting started. Students will learn how to create and log into their Airtable account. They will also learn how to navigate the home screen and create their first base.
How to add data to your new base3:32
Now that we've created a fresh base, let's start adding data to it, covering text fields and images
Importing spreadsheets and linking records6:54
No one wants to start from scratch! This lecture will show you how to import .CSV files into Airtable. It will also introduce the function of linking records between bases.
Going deeper into linking records3:04
Students will learn the finer details of record linking in this lecture
Basic data types: single select and date fields3:41
There are so many data types available in Airtable! This lecture covers single selects and date fields
Creating a table to run a business: Transaction Tracking4:38
Any business needs to keep track of how they make money. This lecture will create a basic template to track business transactions.
Quiz on the basics

The Count function: counting linked records1:47
The first math we learned as kids was counting, right? Let's get back to the basics in this lecture :)
Look up records in other tables5:38
Students will learn how to bring data from multiple tables together in this lecture using Lookups.
Date and time functions3:12
Students will learn basic functions with Date and Time fields in this lecture - critical for any business management.
Calculating Revenue using Airtable Formulas3:40
You're in business to make money, right? In this lecture, I'll show you how to turn your data into dollars. Let's create a calculated field to show the revenue per transaction, using nothing but airtable formulas!
The almighty IF statement2:50
If this then that. So simple, right? Find out in this lecture!
Stringing your data together with functions4:55
The possibilities of formulas are ENDLESS! Let's start to peel back the onion by stringing together some functions.
Data Field Quiz

Sorting through your data3:43
ABC, 123. It's nice when things are in order. Learn how to sort your data in Airtable in this lecture!
Filters, Filters, Filters5:31
As your business grows, you can't look at it all at once. Students will master filters in this lecture to see the important data at the right times.
Grouping your data3:49
A new feature of Airtable that you immediately can't live without. Group your data to easily visualize your business
Putting it all together - sort, filter, group2:03
Sorts, Filters, and Groups are powerful all on their own. Just image what they can do together! Watch out!!
Quickly summarize your data3:18
Leave the calculator in the junk drawer. Airtable makes summarizing large amounts of data simple - let's explore it in this lecture!
Quiz on Filters and Sorts

Publish a public form view - interacting with your customers8:26
Sure, you could jot down notes while on the phone with a customer, then turn the computer on and type all the notes into an excel spreadsheet... but that sounds miserable! Leverage the customers with direct data entry through public form views!
Managing your time with Calendar View3:10
Students will learn all about the calendar view - how to create one, how to adjust values through drag and drop, and the limitations of the calendar views.
Visualizing with the Gallery View2:59
For businesses focused around art or faces, the gallery view is a life saver! We will cover the finer details in this lecture
Share your data through Public Views4:45
Students will learn how to safely share their data with their customers in this lecture.
Going Mobile with iPhone app5:28
You're always on the move. Your data should be too. Learn how easy it is to interact with your data using Airtable on the iPhone!
Quiz on Views

Requirements

Students need only basic computer skills
No prior accounts are required, we will set you up with a free account as part of the course
Familiarity with Excel is a plus, but definitely not required

Description

Welcome to Airtable for Entrepreneurs! Do you own a business? Do you struggle keeping all the records and data together and organized?

This course is for you! I'll walk you through step by step, from setting up your account to having a full fledged database that can run a small business.

You need to take this course because Airtable is the most flexible and responsive database program around right now. With limited technical skill, you can avoid thousands of dollars buying a clunky and expensive system. And you'll have the control to do what YOU want. Neat, huh?

This course will only take a couple of hours to complete, but you can reference it whenever you need a refresher!

I can't wait to work through this course with you!

Who this course is for:

This course is great for entrepreneurs, corporate workers, or anyone who has struggled to make traditional spreadsheets work for their business data
You should NOT take this course if your company does not allow you to use outside tools, even if they would make your company 10x more efficient :)

Airtable for Entrepreneurs

What you'll learn

Explore related topics

Course content

Getting Started in Airtable6 lectures • 24min

Data types and formulas6 lectures • 22min

Sorting, Filtering, and Grouping your data: Making sense of it all5 lectures • 18min

Mastery in Views5 lectures • 25min

Requirements

Description

Who this course is for: