Welcome to ONLC Training Centers

Airtable Advanced

Microsoft Gold Partner
Need a price quote?

Follow the link to our self-service price quote form to generate an email with a price quote.

Need a class for a group?

We can deliver this class for your group. Follow the link to request more information.

Email Alert

Receive an email when this class is available as "Ready to Run" or "Early Notice" status.

Train from your home or office

If you have high-speed internet and a computer you can likely take this class from your home or office.

Airtable Advanced Course Outline

Airtable is as straightforward as a spreadsheet but as powerful as a database and it lets you organize anything you can imagine! It is not just numbers and text. With Airtable you can organize checkboxes, dropdowns, long notes, links to other tables as
well as attachments, Records can be organized in a grid like a spreadsheet but can also be grouped, shown on a calendar, arranged in a gallery and can be embedded into a website. With Airtable you can organize anything, with anyone from anywhere!

This two-day course is designed for individuals who have been using Airtable and want to take their expertise to the next level.

Before attending this course, students should have taken our Airtable Basics course or have equivalent experience with the product.

Course Outline

Getting Info into Airtable Quickly
Batch uploads in gallery view
Copy and paste tips
The fill handle
Importing an existing spreadsheet

Cleaning Up Data
Cleaning up imported files and converting field types
Converting text fields into checkbox fields
Converting text fields into select fields
Converting text fields into linked record fields
Converting text fields containing commas

Linked Records
Should a field be a linked record field?
Linking to existing records in another table with a linked record field
Creating a new table from a linked record field
Avoiding manual or duplicative data entry with linked records (count and lookup fields)
Calculating based on linked records (rollup fields)

Structuring Bases Effectively
Combine or split tables? What about bases?
Using blocks and blocks dashboards to bring in more information
Filtered linked record fields can help limit what you see

Linked Records & Dependencies
Linking record within the same table
Why would I want to link records within the same table?
Choosing the right direction for your linked record field
Building a Gantt chart using dependencies

Navigating Airtable
Keyboard shortcuts
Navigating through expanded records
Navigating through expanded cells
View search bar
Quick base switcher
Flagging records with record coloring
Coloring based on conditions

Leveraging Formulas
Using a formula as the primary field
The many uses of IF
Nested IF formulas
Conditional emoji formula
Using IF to combine and/or filters
Formula output types
Using formulas in rollup fields
Using IF for conditional rollups
View outline in Word


Attend hands-on, instructor-led Airtable Advanced training classes at ONLC's more than 300 locations. Not near one of our locations? Attend these same live classes from your home/office PC via our Remote Classroom Instruction (RCI) technology.

For additional training options, check out our list of Courses and select the one that's right for you.


Class Format
Class Policies
Student Reviews

Bookmark and Share

First Name

Last Name