Special Note to New Hampshire Residents
Airtable Advanced Course Outline
This course has not yet been approved by the New Hampshire Department of Education. Please contact us for an update on when the class will be available in New Hampshire.
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.
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
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 through expanded records
Navigating through expanded cells
View search bar
Quick base switcher
Flagging records with record coloring
Coloring based on conditions
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