Check Your Tech

This project provides the learner with multiple opportunities to practice creating and working with charts using Microsoft Excel in real-world situations. This is on an intermediate level, and the content is for practicing what learners have already learned, not to teach how to use Microsoft Excel. The project can be assigned to a single learner, or as a small group collaborative project. The workbook includes, a cover sheet for the students, all the required data, and a solution worksheet for

This project asks the student to complete an accounts receivable workbook for an auto dealership which provides in-house auto loans. They will need to import loan data, and add 3 additional borrower accounts, calculate monthly payments, calculate whether the borrower is on time or past due in their payments, apply conditional formatting, and if an account is past due how many days they’re in default. They are to prepare a status sheet, in addition to creating a histogram of the default accounts,

Purpose: To offer learners scenarios to practice creating functions using Microsoft Excel. Content: Using an Excel spreadsheet to work in, learners are given 10 different basic scenarios and are asked to create functions. This is on an intermediate level, and the content is for practicing what learners have already learned, not to teach the functions themselves. Functions included are AND (), CONCAT (), TEXTJOIN (), LEFT (), UPPER (), AVERAGE (), COUNTBLANK (), IF (), SUMIF (), MAX (), VLOOKUP

This project gives the learner four tasks with multiple steps to complete in Microsoft Excel, using a real-world situation. This is on an intermediate level, and the content is for practicing what learners have already learned, not to teach how to use Microsoft Excel. The project can be assigned to a single learner, or as a small group collaborative project. The project includes one data file, a Microsoft Excel workbook solution, a PDF copy of the solution, the Project Directions, and the Micros

This project gives the learner two tasks with multiple steps to complete in Microsoft Excel, using a real-world situation. This is on an intermediate level, and the content is for practicing what learners have already learned, not to teach how to use Microsoft Excel. The project can be assigned to a single learner, or as a small group collaborative project. The project includes two data files, two Microsoft Excel workbook solutions, a PDF copy solution, the Project Directions, and the Microsoft

This project provides the learner with 8 different tasks to complete in Microsoft Excel, using a real-world situation. This is on an intermediate level, and the content is for practicing what learners have already learned, not to teach how to use Microsoft Excel. Learners can also use this project to prepare for the Microsoft Office Specialist Exam. Skills Addressed: Convert data from a range to a table, apply table styles, use AutoFill, nested functions, conditional formatting rules, create an

This project gives the learner four tasks with multiple steps to complete in Microsoft Excel, using a real-world situation. This is on an intermediate level, and the content is for practicing what learners have already learned, not to teach how to use Microsoft Excel. The project can be assigned to a single learner, or as a small group collaborative project. The project includes two data files, a Microsoft Excel workbook solution, the Project Directions, and the Microsoft Office Specialist Excel

This project provides the learner with 10 different tasks to complete in Microsoft Excel, in a real-world situation. This is on an intermediate level, and the content is for practicing what learners have already learned, not to teach how to use Microsoft Excel. The project can be assigned to a single learner, or as a small group collaborative project. Learners can use this project to practice for the Microsoft Office Specialist Excel exam. The workbook includes, a cover sheet for the students,

Purpose: To offer learners scenarios to practice creating functions using Microsoft Excel. Content: Using an Excel spreadsheet to work in, learners are given data in a worksheet and are asked to answer the questions by determining and using functions. This is on an intermediate level, and the content is for practicing what learners have already learned, not to teach the functions themselves. Functions included are SUMIF (), COUNTBLANK(), COUNTIF (), ROUND(AVERAGE), VLOOKUP (), MID (), RANDBETW

Purpose: To offer learners a quick way to study Microsoft Excel functions by matching the function names with the definition of what they do. This is on a basic level, and the content is for a quick study guide to reinforce function knowledge. Content: Learners are given a word bank of 24 different Microsoft Excel function names and are asked to match them to the definition of what they do. This is a stand-alone Microsoft WORD document that can be downloaded and copied or filled-in and saved el