Forum

Hi Rachel, Welcome to our forum! It's great to see you're making use of the techniques in my Project Management Dashboard tutorial. When writing...

Hi Vivian, According to Microsoft's documentation it's available from Excel 2013 onward. Mynda

Hi Vivian, What version of Excel do you have at home? What version of Excel did you build the report in? Has the report been opened in a different ...

Maybe it's easier to teach them how to use the filters in Power Query 😉

Hi Maree, Not that easily 🙂 I would give the user Slicers for the Table if you want them to be able to chop and change what they see. This will b...

Hi Frederick, Welcome to our forum! It looks like the connection between the Excel Table and Power Pivot has been lost. Possibly you renamed the Ex...

Hi Shirley, Welcome to our forum! Did you set the colours when all filters were removed? i.e. all items in the Slicer must be selected, then set th...

See attached.

Hi, You need to add the date to the SUMIFS criteria. It can't just infer it from rows that are filtered out. I suggest you add the date you want th...

Hi Subash, I think Anders did a great job of explaining what the formula does. But maybe you don't know that INDEX returns a value of reference to ...

In the cells that you only want them to be able to select one item, simply insert a regular data validation list as this is their default behaviour. ...

There's no easy formula for this and that's because Excel wasn't designed to stuff multiple items from a data validation list into one cell 🙂 You...

Hi Maree, I don't go into the security settings in a lot of detail in the course, but this post has more information. In regards to the Mac, I t...

Hi Stephen, In the attached file you'll see I've used the FILTER function in cell N2 to retrieve the project team and phases from the data in colum...

Hi Saliha, Your question isn't clear, sorry. First, I'm not sure what cells contain the manual calculation you wish to automate. Second, I can't se...