Welcome to ONLC Training Centers


Airtable Advanced Course Outline

 (2 days)
Special Note to New Hampshire Residents
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.

Overview
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!

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

Prerequisites
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
DATETIME_FORMAT
DATETIME_PARSE
View outline in Word

XATMNS

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.

Microsoft Gold Partner
Class Dates
(click date for class times)
(click Enroll for locations)

Fee:  $895

Savings options:

 15 Day Pass
 CEA Tech Saver
Need a price quote?

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

Email Alert

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

Attend from your office or home

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

Need a class for a group?

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

Attend computer classes from ONLC Training Centers Request a copy via mail

GENERAL INFO

Class Format
Class Policies
Student Reviews

Bookmark and Share


HAVE QUESTIONS?
First Name

Last Name

Company

Phone

Email

Location

Question/Comment



ONLC TRAINING CENTERS
800-288-8221
www.onlc.com