Here are some problems that our users have asked and received explanations on
how to define date in excel is equal one
Solved by E. J. in 25 mins
I need to define a date to the right accounting period in my excel worksheet.
Solved by Z. Y. in 23 mins
i have loaded an excel table into power query and merged it with a table pulled from another database. i then subsequently created a series of referenced queries to define a set of tables i want to connect to tableau. i found a mistake in my original excel table and fixed it at the source, however, i cannot get my power query 'refresh' button to pull in the newly updated table. it just shows the old version of the table after the refresh... HELP! I've spend hours on this already.
Solved by E. B. in 19 mins
I need to use a lookup function, but instead of manually entering formulas every time, i want to use the same table array that is in multiple workbooks, and use a hyperlink to define which workbook its coming from.