Last seen: Jul 22, 2026
Hi Peter, The third argument of VLOOKUP should be a number i.e. the column number in the range B37:E41. Your formula should translate to this: ...
The main advantage is formulas update immediately, whereas PivotTables require you to click the Refresh button or right-click > Refresh.
Hi Peter, Great to see you're practicing! First, you wouldn't be presented with a question like that in the MO-211 exam. This is quite an advanced ...
Hi Tracy, If you changed the 'Days for Completion' to only include for workdays, then you could use the WORKDAY function the way it was designed. i...
Oops! Good catch, Peter. Thanks for letting me know.
Hi Peter, That's odd. Make sure you're logged into Excel. If that doesn't help. Try the feedback button on the Help tab and send a report to Micros...
Hi Robert, What exactly were you trying to do in terms of editing? Change amounts, change formatting, something else? Mynda
Hi Robert, I think that site has changed its structure/layout, so Power Query isn't able to work with it as it did when I recorded the video. I...
Hi An, This is a setting change that you or your IT admin have to do. You can see if you have access to make the change by clicking on the cog icon...
Apologies, Bax. I haven't been clear. In Power BI you can copy and paste your data into a table. Doing this creates JSON code for your dataset in t...
Hi Ann, This week they renamed Datasets to Semantic Models! Just to keep everyone on their toes. So you want +New > Semantic Model. Mynda
Hi Bax, Just copy the query from the Advanced Editor in Power BI and paste it into a new query via the Advanced Editor in Excel. Mynda
Hi Steven, The error says that Microsoft 'changed or removed it on our side' meaning that they stopped supporting this data and there is no fix as ...
Hi Bax, You could convert the data to a static data table as explained here. If you have a lot of data, then you might like to use Power BI to past...
Hi Ayal, I edited the query and changed the data type for column E to whole number (as Velouria said, it's currently formatted to 123ABC which is d...