
1. Re: Excel Data in Tableau
Jim Dehner Jan 18, 2019 7:39 AM (in response to Robert Kroener)Good morning Robert
Excel and Tableau are fundamentally different  excel is cell based  tableau is daa based oriented  so the answer is no
you can load the data and probably reshape data but will need to recreate any calculations using Tableau commands which are similar but not the same
see the training videos at Tableau Training: View Training Courses
Jim
If this posts assists in resolving the question, please mark it helpful or as the 'correct answer' if it resolves the question. This will help other users find the same answer/resolution. Thank you.

2. Re: Excel Data in Tableau
Michael Gillespie Jan 18, 2019 8:06 AM (in response to Robert Kroener)Robert:
There are 2 ways to interpret your question.
1) Can Tableau extract the calculation from a cell in Excel and use THAT? This is more or less what Jim is answering.
2) Can Tableau get the RESULT of a calculation in a cell in Excel, or do you have to do something like "paste values" to allow Tableau to read the result?
For question 2, the answer is, Tableau will happily read the result of any calculation in a cell and use that as the value it imports into Tableau.
Which question is your question?

3. Re: Excel Data in Tableau
Robert Kroener Jan 18, 2019 8:13 AM (in response to Jim Dehner)Hi Jim,
many thanks for your answer. Is the same true for a case where there is just made reference to another cell (instead of having a number in the cell it is wrtiten in the cell: =E1)?

4. Re: Excel Data in Tableau
Jim Dehner Jan 18, 2019 8:29 AM (in response to Robert Kroener)Hi Robert
Tableau works on dimensions (think like an entire column in excel) and measures ( the values in the rows of that column)  so if you had 2 dimensions (columns A and B) and wanted to add them together A + B
will add the 2 values together not just for one "Row" but for every row (the form in Tableau is actual sum(A) + sum(B)
It is different and can be confusing
see below  there is one dimension (Product category  it has 3 members  in excel you would make 3 separate columns)
there are also 2 measures Sales and Quantity 
the values in the table are the total Sales or Quantity for the 3 product categories in the data set 
there are actually several thousand records that are added together  each record is a sales transaction by customer, date, and product)
In excel you would list all the transactions and do Sumifs() type of calculations to get the totals and then a vlookup to move the totals to a summary sheet
It takes some practice and some training  I came to Tableau from Excel  also need some training  stat at the site Tableau Training: View Training Courses
Jim
If this posts assists in resolving the question, please mark it helpful or as the 'correct answer' if it resolves the question. This will help other users find the same answer/resolution. Thank you.

5. Re: Excel Data in Tableau
Robert Kroener Jan 19, 2019 3:42 AM (in response to Michael Gillespie)Michael:
it is the second questen which refers to my problm. Are there any additional actions needed to wot with this data in tableau or is it the same importing process as in any other case?

6. Re: Excel Data in Tableau
Michael Gillespie Jan 20, 2019 12:55 PM (in response to Robert Kroener)Now that the forums are back up I can answer you!
Nope, nothing special you have to do to get Excel data into Tableau.
Once it's THERE, however, take Jim's guidance as to how to work with it. Tableau and Excel have superficial similarities but they are not the same too, and you have to think about calculations differently.
Best of luck, and keep asking questions!