From the course: Excel Weekly Challenge

Unlock this course with a free trial

Join today to access over 22,600 courses taught by industry experts.

TJ's arts and crafts: How can we improve this workbook?

TJ's arts and crafts: How can we improve this workbook? - Microsoft Excel Tutorial

From the course: Excel Weekly Challenge

TJ's arts and crafts: How can we improve this workbook?

- [Instructor] Alfred and TJ makes some of the most beautiful crafts you've ever seen. And he started a side business. Now TJ is starting to track things in Excel and asked us to come over and check out this beautiful workbook he's put together. But we see problems. And that's where your help is needed. Come up with at least four ways that this workbook could be better so that it's dynamic and it's meaningful. And if you want to take this further, go ahead and make your own revised or improved workbook. But let's look at the data. Here's a summary sheet. We go over here and we look at this total. There's no formula, there's just a 2895 typed in but highlight here and then look down in the lower right and sure. $2,895 is what that adds up to. Click away, now let's look at these other sheets. We got January 11 sales let's highlight here right? $1,235 click here. There's no formula. Let's look at February,…

Contents