Forum

Hi Genevieve, Glad you're enjoying the course and learning lots. You need to put the project manager names in one column and have a separate col...

Hi Kenneth, Yes, I mean filtering out the items with FilterDatabase in the name in the step where you're shown all the elements in the file. No...

Hi Harrie, Your screenshot is not attached. Please try again and be sure to click the 'start upload' button after selecting your file, then wait fo...

Hi Alver, UNIQUE considers a whole row or whole column when it looks for unique results. Therefore each row or column in your 2D array has a differ...

Hi Alver, Welcome to our forum! Please tell us whether you're using Excel Office 365 so we know what functions you have available to use? Thanks...

Hi Kenneth, Welcome to our forum! The _FilterDatabase names refer to the filters on each table. These aren't something Power Query can read, whi...

Hi Charles, I'd use Power Query to split the date and time components into separate columns, just in case there is a minute or two difference from ...

It seems like a waste of money for them to pay for 365 but not use it. Anyhow, I don't envy your situation. You can try this dependent data valida...

Hi Lionel, If you have a 365 subscription then you should have FILTER and UNIQUE. I'm not sure why you're still using Excel 2016. I would uninstall...

Hi Christopher, The course files are available to download from a link at the top of the course syllabus page. Let me know if you still have tro...

Hi Harrie, It's not clear what tablet or smartphone you're using but it will be specific to that device. When I use Excel online on my iPhone I can t...

Hi Jenny, Welcome to our forum. The problem is caused by your data being in the wrong layout for a PivotTable. You need to unpivot the name columns...

Hi Nasir, Please see file attached. In columns E and F are formulas to split the first column of text. You can modify them for the other columns. ...

Hi Sofie, Conditional Formatting in PivotTables will only be retained in the values area, as per Catalin's second link in his reply above. If you a...

Hi Nasir, Not much we can do with a screenshot. Better to share a sample Excel file. I'm thinking that the Arabic characters might start at a speci...