Forum

Hi Mitul, Any progress with the formula? /Anders

Anders Sehlstedt said Hello, When trying to play the video for lessons 7.07 and 7.09 I get an error stating "html5: Video file not found". Playing l...

Hello Mohamed, Please explain with details what the issue is, as I can't see any. I assume you expected to see some data connections, but if no dat...

Hello, What I do is to create a copy of the file and in the copy I add comments or whatever suits best to give information of each data set, condit...

Hello Mitul, It seems to me you are doing some training, so instead of giving you the answer, please do try to write an IF formula and then let's s...

Hello Mitul, I don't see what you have trouble with, you have all needed data and you just have to set up the Pivot Table as to your needs. If you ...

Hello, Assuming you have an .xlsx file. Apart from the obvious, remove data you don't need and keeping pictures and formatting to a minimum, you ca...

Hello Mohamed, As per your picture, the problem is because you are working whith an .xls file in compatibility mode. Slicers are not supported in ....

Hi, There are other considerations to take into count when creating a time sheet, for example night and shift work. More about time calculation in ...

Hello Peter, Some more references to start with, check these sites for more information about calculating dates and times. So, now to your i...

Hi Peter, Basic time sheet is easy to do, if you just know how. If you not already have taken one already, I can suggest that you will learn lots b...

Hello Terri, You are not using the same formula in column S. For example: In cell S7 you have =IF(NOT(ISBLANK(R7)),R7,C7) In cell S8 you have...

Hello Mitul, Both 1st and 2nd outlines are needed, if you want to have the data grouped. Click 2nd outline to open up the groups to see the source ...

Hello Mitul, Seems to me your data is not aligned, meaning that you probably have tried different scenarios or whatever could be the reason. In ...