How to Decide When to Use Worksheets & Workbooks in Excel

Video Transcript

"Hi, I'm Amar Enhsaihan, and I'm going to speak with you about when to use worksheets and when to use workbooks. I have an example here open. It has multiple sheets, multiple worksheets, and all combined with the workbook. So, "y", we use workbooks in complicated analysis, with multiple parts. Each part can be updated in the future. That's why we have them in separate sheets. We have two thousand nine information, two thousand eight information, a summary that combines them two, combines them both. And, I have equal sheets that fit the analysis. This is a good example of when to use a workbook. You can update the individual parts, and it's easy to track where the information is. If, if you're working on something simple, maybe you should just consider using a worksheet, you know. That way, you don't have to switch between tabs, and look for information. I'm Amar Enhsaihan and this is when to use workbooks and worksheets. Thank you for watching."