 Alright, this video is a quick demo on what to do with tables in Excel to put them into a report. So we've got some raw data here. Let's zoom in to see it and it's about temperatures and times. So it's a kinetic experiment We've got averages and errors and a percentage error And I think what most people end up doing is you do this and you think oh, well I haven't I can't see the the titles for these so if I double click that it'll make them really wide and make More fit and then you'll highlight all of it. Add bounding boxes and borders to everything copy it Dump it into word and go. Oh, it doesn't fit It doesn't fit on then faff around with trying to resize everything or even worse You'll right click and paste it as an image and then it's just scale it down and that will really break if you say Let's put it in here in a two-column layout if I put it in here Well, it definitely doesn't fit. So I'll put it in as an image and then it reduces down and Honestly that this this this hurts me. You you you can't read this. This is not what you should be doing So the rule of thumb usually is if you can't fit your table into this two-column layout you are using Too much data, you know, you're including too many things. So rather than faffing around technically Let's start with thinking critically about what we want to actually show and demonstrate What do we see here? Well, we've got this here It's called an approximate temperature and this was the temperature that I set a water bath at and these are suspiciously round numbers Because here. Oh, it actually wasn't zero degrees. It was slightly above zero degrees Oh, it hadn't quite got to 45 degrees because maybe it's slightly cooler. This one was slightly overly warm. Okay, fair enough That's allowed and the thing is with reporting data. We don't Care as much about what you intended to do We really do care about what you did do and the actual temperatures what you did do so Bye bye that you can get rid of it. You can mention that those are the Temperatures you set your water bath to in an experimental section. We don't need it for raw data And then we've got these two competing temperatures here. We've got Kelvin and C centigrade Celsius whichever Fahrenheit if you're American, but don't Which one is more important? Well, if this is kinetic data for an activation energy experiment, for instance Then Kelvin's what we want because that's what goes into the Arrhenius equation So we can actually drop That we don't really need it. We don't need to know what Celsius is if we've got Kelvin there And put it somewhere else so that you've set those to the Or you pick one of the other it doesn't really matter I'm gonna pick Kelvin for now and Now we don't need to say that it's actual temperature that is just the temperature The word actual is almost implied there. In fact, we don't even need to write the word temperature because pretty standard It's known as T capital T for temperature and then Lowcase T for time for instance. So what we've got here is in fact is an average time in seconds So we can actually put lower case T There we go There's a little bit better. It looks a bit nicer. We don't have to this stuff with temperature that we don't need Another question is do we need this? I'm not usually a massive fan of calling things runs, but okay for whatever Do we even need them? Is it data that's pertinent? If we're doing rigor statistics on it may be but also we can hide that away in supplementary information Not necessarily getting rid of it and not reporting it, but that is information we can stash Somewhere other than the main document. We're not interested in we don't need to know that we did one thing And it was 78 seconds the other one was 76 seconds. What is interested in the average? So that's one thing we can and the error In see well, we can leave that As is but do which one do we want to report? Do we want to report the percentage error or the absolute error? I would usually only go for one unless the fact that there are two different things tells us something For instance percentage errors tend to systematically get bigger as your measurement gets smaller Remember 10 plus or minus one is a bigger percentage than 100 plus or minus one So I'm going to get rid of that. I don't need it So actually that massive table only needs Three columns reported. We don't need to use All of this another thing. I'm going to tidy the decimal places up I'm going to have that to one decimal place That I'm going to add to one decimal place that I'm going to add to one decimal place We can do stuff like truncating those together Concatenating them and maybe I'll do that another time, but we can leave it as this And I'm going to center them just to make them Relatively eat and what we can even do here in excels goes format as a table and pick the table style that we want And there we have It's really useful. It's it's Given these these what on a tiger stripe sometimes which tells you what row everything is on It's really nice if you can run along a big row of data. For instance, I find that they're all the same color So your eyes can track along it Smaller tables. It's not 100 necessary, but We can use it So what happens if I'm a copy that and go into Our two column layout. I'm just going to control v There it is. That's the numbers there. Um, this is not as an excel object It's not as an image. It just fits and what I'm going to go to do is the table tool is highlighted and in the layout There's a single auto fit And then we've got three options. We also fit the contents, which will usually Suck it all down to just fit whatever's there We can also fit the column width. I don't even know what that even does um and also fit the window which actually just Doesn't fit the whole window that you see it's actually the column here So that's a little bit better, right? Now we can see That we've got some clear numbers. They're all titled up nicely. They look nice, right? That's a little bit better Now what are we going to do? Well, we need to know what the Uh, these headers actually mean so we could then start going our references insert caption Figure one and I've got my figure one actually let's do it properly. Let's call it a table call it table one What's the table one? I've got the chapter number in there for some reason. Um, so We can start typing what this is. Um, data used in the RNA equation Now the caption needs to start telling us new things. So Let's put in that new data, right? So let's see what we can do here. We can put in an asterisk there and at the bottom we can do asterisks um time average of four data points Uh, an error here. I've got this character in auto correct dagger dagger, um Standard deviation Uh sample Before the data points Fair enough you can keep it like that. So that's a lot more useful Uh, and a lot more readable For what we're managing. Maybe I'll go stick that as a figure. So I've got it there. I could even stick the table caption at the top So now that's a lot more readable We've thought critically about what data we want to put into the report And we've also formatted it in a way that's very very Readable and added more information as well. So rather than presenting every single run because I'm not going to read it No one's going to read it when copying pasted. It's maybe to do more data analysis if you want to fix things Uh, but we're really interested in how many data points did you have? And what is your error? Is it a standard deviation? Is it a standard error? Is it a confidence interval? And you can put that all in the caption to make it more useful