USS - Creating and Managing Workbooks and Worksheets Lesson

BusTech_LessonTopBanner.png Creating and Managing Workbooks and Worksheets

Introduction

What are some business operations that require companies and organizations to collect, record, analyze, and share numerical data? Let’s go back to the bakery example used earlier in this module. You have opened your dream business – a gourmet bakery! Even though you have done your homework and estimated projections in your business plan, opening a new business is both scary and exciting, depending on how customers respond. Many new business owners get too excited and forget to pay attention to financial indicators and make adjustments as needed.

*

You will need to analyze your daily sales so you know which items are selling and which are not, as well as order supplies. You will also need to keep track of expenses, such as payroll, supplies, advertising, rent, taxes, etc. Spreadsheet software allows you to do that! Microsoft Excel is a most popular spreadsheet and data analysis software.

This lesson contains an overview of spreadsheet software, demonstrates how to create and manage spreadsheet workbooks and worksheets, and discusses how businesses use spreadsheet software for daily operations.

explore-25.jpg  

Spreadsheets

There are some terms that will be used throughout this module:

  • Spreadsheet is a computer application used for entering, calculating, analyzing, and sharing business data.
  • Workbook is an individual spreadsheet file, composed of one or more worksheets.
  • Worksheet is a single page of a spreadsheet workbook file.

*

Example Videos

Please watch the videos below which are demos of features of spreadsheets. There are 8 videos. Use the scrollbar to the right of the video title list to scroll down to see all videos.

 

challenge-26.jpg  

 

BusTech_LessonBottomBanner.png   IMAGES CREATED BY GAVS