The first is trying to figure out if it's possible to make and contain multiple tables within a single file.
Since the release of FileMaker 7, that has been a standard feature for Filemaker databases. Go to Manage | Database | tables and you can create as many tables as you need in a single file.
Importing each worksheet one at a time, each one appears below the previous one on the same table. Is it possible to give each one a unique table, but have them all be contained in the same file?
Certainly possible, and there is more than one way to do that.
Option 1: Use Import Records | File and select "new table" as the target table. You can then import your records, one worksheet at a time into different tables, each row of data in the excel worksheet will be a different record in the new tables, column names can become field names in the new table.
Option 2: Go to manage|Database|Tables and define the tables and fields you want in advance of importing the data. FileMaker will automatically create a new layout for each new table. When using Import records|File to import this data, first select the layout that corresponds with that table. With this approach, you can select which field in your defined table will receive a given column in the excel file.
I'm hoping I can somehow connect the cells for...
Manage | Database | Relationships can be used to link the tables in relationships. The "boxes" found on the relationships window are "Tutorial: What are Table Occurrences?". You can create additional table occurrences that refer to your tables as needed to define the relationships that you need. What happens next will depend on the structure of your tables and now you need those relationships to work.
One last thing: How do you apply formulas to cells
In FileMaker, we call them "fields" or possibly "columns", not cells. You cannot import the calculation expressions from the spreadsheet--only the current value of each cell. The calculations in Excel are simply too different in syntax and based on too different a basic structure to the files to be something that can be imported. But you can go to Manage | Database | Fields and add as many calculation fields as you need. You can also define data fields to have an auto-entered calculation. Learning the differencese between these two options and how to choose the correct option in each circumstance will be one of the important things to learn as you get your FileMaker Database to do what you need it to do.
A final comment:
Bringing data from excel into FileMaker is a very commonly performed task, but Spreadsheets and Relational Databases are two very different applications. If you try to simply replicate the look and function of your spread sheets in Filemaker, you may have a very difficult and frustrating time of it as FileMaker can't easily be set up to do things that are simple in Excel and Excel can't do some things that are very simple to do in FileMaker.
It's best to fully understand the capabilities of both applications and then exploit FileMaker's strengths while minimizing the weaknesses. This may produce screens that look very different from Excel but either get the same job done or achieve tasks nearly impossible in Excel.
Thank you. Is there a list anywhere of field calculations that can be typed in?
That's pretty much an endless list.
Think of how many different calculations you could construct with just the basic four math functions. And there are many different functions and more than just the basic math operators that you can use.
But you can research functions in FileMaker Help.