Tableau Data Model and Dashboard Development

We need to create a proper data model from excel files using Tableau Prep and then create a couple of visualization dashboards within Tableau based on that excel file data. The excel files currently have various formulas/calculations that will need to be understood in order to create a data model from the files.