85 results
Business worksheets for Microsoft Excel
Health Insurance Scenarios
Help your students figure out the cost of health insurance. Students are required to figure out the yearly medical expenses for various individuals factoring in their deductibles, stop loss provisions, and co-pays. This assignment can be done as a worksheet or having students utilizing their excel skills by filling in the spreadsheet. It is updated to reflect new health care provisions of preventative care coverage mandated through the Affordable Care Act.
Grades:
9th - 12th
Types:
MICROSOFT EXCEL: Halloween Spreadsheet Using Basic Functions
This is an assignment for students in grades 4-12 learning about spreadsheets to practice using formulas such as SUM and AVERAGE and practice formatting techniques. This is a basic activity which does NOT require students to have a comprehensive knowledge about Microsoft Excel or other spreadsheet programs, only basic techniques! Students will have to type information into a spreadsheet and use functions to calculate results. File type will be in zipped folder with PDF of worksheet and answer ke
Grades:
6th - 12th
Types:
Budget Worksheet
Simple one month budgeting worksheet. Let students discover what it might be like to budget expenses verses income in the "real world." This activity will help students understand what kind of expenses they will be expected to pay once they get out on their own.
Subjects:
Grades:
8th - 12th, Adult Education, Staff
Excel Formulas and Functions
These downloadable spreadsheet exercises are ideal for teachers that want to show students how to use Excel or Google Sheets to solve math problems, learn statistics and how spreadsheet data can help people make decisions. The exercise instructions are provided inside each spreadsheet, which makes it easier for students to learn and work independently.Here's what's included:1. 42 practice exercises, which cover the following topics:a. Formulasb. Math functionsc. Statistical functionsd. Logical
Subjects:
Grades:
5th - 12th, Higher Education, Adult Education, Staff
Types:
Excel payroll Assignment
Excel sheet requiring the students to enter data and formulas related to payrolls. They will figure Gross pay and net pay depending on the hours worked and payroll deductions.
Subjects:
Grades:
9th - 12th
Types:
MICROSOFT EXCEL: Autumn & Fall Themed Spreadsheet Using Basic Functions
This autumn and/or fall themed project, designed for students learning beginning Microsoft Excel, allows students to create a new workbook, type in relevant information from a landscape business and use formulas to calculate total income, total expenses, and net income (income minus expenses).This project is designed for beginners, in grades 7-12, and students should have some background in formatting (such as currency style, accent styles, applying bold and italic, and inserting rows). File typ
Grades:
7th - 12th
Types:
Project Management Template| GANTT Chart Template| Excel + Google Sheets
Project Management Template| GANTT Chart Template| Excel + Google Sheets Project Management Template | Online Modification & Printable.GANTT Chart template for project management : Microsoft Excel & Google Sheets Templates for Gantt chart project management & Team Management| Modification + Printable + Sharable with the team.You will get 2 versions : Excel + Google Sheets
Subjects:
Grades:
Not Grade Specific
Types:
Accounting Digital Worksheets (Journal, Ledger, Worksheet, Inc. Stmt. + Bal. S )
Help your students understand the concepts of the Accounting Cycle with these color coded and user friendly Google sheets! Your students will love the pop of color and creative fonts used to complete different Accounting documents, including:General Journal, Ledger, Reconciling a Bank Stmt, Worksheet, Income Stmts for both Sole Proprietorship & Corporations, and a Balance SheetIt doesn't get better than this! Happy teaching!
Grades:
9th - 12th, Higher Education
Types:
Microsoft Excel Icon Identification Worksheet
Great for an introduction to the Excel ribbon icons or as a review. Commonly used Microsoft Excel icons and commands are shown. Students identify the name of the icon, give a description of its function, and draw a picture that demonstrates understanding of its function. You may choose to have students use Microsoft Excel to help complete the worksheet (especially if using as an introduction) or complete it from memory. Also a great worksheet for a substitute to use.
Grades:
7th - 10th
Types:
Check Writing Exercise-Spanish, ELL, Intro to Personal Finance
If you have high school or adult students who need to learn how to write checks and balance an account, this activity is the place to begin. The file includes a check register (with instructions of where the money goes) and sample checks. This spreadsheet can be an engaging and effective exercise in the ELL, Spanish, or business class.
Instructions are in English with some Spanish words, such as the bank’s name and the address. However, this file is fully customizable – you can translate it st
Subjects:
Grades:
7th - 12th, Adult Education
Types:
Adjusting Entries - Quiz Package - BAF3M, Financial Accounting Fundamentals
Comprehensive BAF3M Adjusting Entries Quiz PackageElevate your accounting class with this meticulously crafted BAF3M Adjusting Quiz Package, ideal for teachers aiming to reinforce their students' understanding of adjusting entries and worksheet preparation. This all-encompassing package includes a series of quizzes, each tailored to different points throughout the academic year, ensuring a progressive learning curve.Features:Varied Difficulty Levels: From introductory concepts in November to mor
Grades:
10th - 12th
Types:
Financial Literacy Checking Assignment (check writing)
This is an assignment to teach students how to write checks and balance a checkbook. It is an interactive Excel Spreadsheet and self scores if the student completes it on the computer.
There are two parts to the assignment. The first part has the students correctly fill out 8 checks based on prompts given to them. The 2nd part uses those 8 checks and other non-check transactions to teach them how to fill out and balance a check register.
Also included is a .pdf printable version of the ass
Subjects:
Grades:
6th - 12th, Adult Education
Types:
Practice creating business balance and income statements
In this activities students can practice creating business balance and income statements for three years worth of data. Then students will be asked to do financial ratio calculations that can be further analyzed to determine the health of the business. If you want to further enhance the activity you can share it with your students as an excel or google sheets documents so they can calculate it using spreadsheets. It reinforces students ability to figure on assets, liabilities, expenses, and r
Grades:
9th - 12th
Types:
Monthly Budget for High School Students
Every high school student who has some form of income should have a budget!This budget sheet is like having a personal financial wizard right at your fingertips. With its user-friendly design, you can easily track your income, expenses, and how much you are able to save each month. It gives you a clear picture of where your money is going and helps you make smarter financial decisions.
Grades:
9th - 12th, Staff
Payroll Register & Earnings Record (Google Sheets)
Help your students learn about Payroll using this user friendly & color-coded digital worksheet! Students will be more engaged as they enter data into this Google sheet that comes with different font styles and easy to follow template, making learning fun!! Includes free sample Payroll Register and Earnings Record sheets for better comprehension. Happy teaching!
Grades:
9th - 12th, Higher Education
Types:
Income Statement for Corporations (Google Sheets)
Help your students understand how to solve an income statement for Corporations by using this user-friendly, color coded Google sheet. Your students will love using this unique technology resource as an effective learning tool they can access from any device! Happy teaching!
Grades:
9th - 12th, Higher Education
Types:
Excel Accounting Journals and Ledgers
This package has 26 journals, ledgers, and other accounting documents. Included in this package includes: General Journal, Sales Journal, Cash Payments Journal, Cash Receipts Journal, Purchases Journal, 8 and 10 Worksheets, General Ledgers, Payroll Registrar, and many more.
Grades:
9th - 12th
Types:
Income Statement for a Sole Proprietorship (Google Sheets)
Help your students understand how to create an income statement by using this user-friendly, color coded Google sheet. The sheet includes a sample income statement with formulas indicating how to solve for vertical ratios! Happy teaching!
Grades:
9th - 12th, Higher Education
Types:
Balance Sheet for Sole Proprietorship (Google Sheets)
Help your students understand how to complete a balance sheet by using this user-friendly, color coded Google sheet. The sheet is easy to follow and fun to complete due to its nice layout! Happy teaching!
Grades:
9th - 12th, Higher Education
Types:
Posting from a General Journal to a General Ledger (online worksheet)
Teach your students how to post from a General Journal to a General Ledger using this color coded & user-friendly Google sheet! Your students will enjoy learning using technology tools that they are familiar with. Happy Teaching!
Grades:
9th - 12th, Higher Education
Also included in:Â Interactive Accounting Cycle Worksheets Bundle
Invoice Example
Template of an invoice. Have students create their own invoice for their own business.
Subjects:
Grades:
10th - 12th, Adult Education
Types:
Creating a Worksheet
Teach your students how to create a complete company worksheet using this color coded and user-friendly Google Sheet document! Enclosed you will find a completed sample worksheet and a blank one ready for you to edit, as well as a Teacher's Copy with helpful annotations! Happy teaching!
Grades:
9th - 12th, Higher Education
Also included in:Â Interactive Accounting Cycle Worksheets Bundle
Excel Candy Activity
This is such a fun activity that all students enjoy! It gets them up and walking around, working in groups, and work through learning the basics of Excel. You can use any variety of candy. I use M&Ms but you cold use Skittles or even cereal. The kids just love being able to eat as they work on their assignment.There are 2 parts to this assignment. The first part covers the basic steps of building a table. Part two covers more advanced use of functions and charting. I typically use the first
Grades:
9th - 12th
Types:
Accounting Posting Practice
Some of my students STRUGGLE with calculating balances when posting to their ledgers. This is a three-page practice uses four accounts in each the general, accounts receivable, and accounts payable ledgers. I created the ledgers using Excel so they do not completely match the regular workbook students are used to, but the lines and shading are similar. The numbers include a lot of cents and some zero balances. I've included a key where the answers are bold and in red. I am including both the pdf
Subjects:
Grades:
9th - 12th
Types:
Showing 1-24 of 85 results
TPT is the largest marketplace for PreK-12 resources, powered by a community of educators.
IXL family of brands