TechCheck Lessons

Perfect for teaching a Microsoft Excel course! Editable lessons, activities, projects & exam preps. Great for MOS Excel certification exam training from Certiport too. Files open in Microsoft Excel so you can edit them to your liking. Optimized for Excel 2019, 2021 / 365 & 2016. (Will also work for MS Excel 2013 but some tabs and menus may be named differently) ***Files open in Microsoft Excel or Word and you can edit them as you please. :) Suggested order of teaching and Skills Taught Index

Students use the Insert Function tool to find the missing answers in the light blue cells. This lesson will teach you how to insert and edit charts and also teach you the following functions:SUMAVERAGEMAXMINCOUNTIF**Files open in Microsoft Excel and are fully editable if you so choose..***************************************************************************************This lesson is contained within my Microsoft Excel Skills Bundle.Other individual Microsoft Excel Skills you may be interested

Students create an amazing (or mediocre) piece of artwork using Microsoft Excel today. I know this is not Art class. Fear not! This lesson will actually teach you:• Cell shading• Cell borders• Format Painter• Merging Cells• Resizing Columns and RowsI have provided an example of Excel Pixel Art on Sheets #2 & 3 (named Pixel Art Example). Check it out! And if you can’t think of any good ideas…google Excel Pixel Art and see other examples from people all over the world. Don’t copy them though! Crea

A brief activity designed to teach students the following Microsoft Excel skills:Simple IF FunctionsIFSUMIFAVERAGEIFCOUNTIF**Files open in Microsoft Excel and are fully editable if you so choose..***************************************************************************************This lesson is contained within my Microsoft Excel Skills Bundle.Other individual Microsoft Excel Skills you may be interested in:Basic Functions and Formulas LessonCell References LessonConditional Formatting LessonD

A fun project where students create charts to specifications to show their mastery of the following Microsoft Excel skills:Inserting ChartsChart StylesChart TypesChart ElementsCharts Rows and ColumnsI’ve placed an example of what your finished project should look like on the 3rd worksheet named “Finished”. Do all of your work with the existing data on the 2nd worksheet named “START HERE”**Files open in Microsoft Excel and are fully editable if you so choose..*************************************

Well-designed slideshow containing the 38 most important Microsoft Excel terms to know for your students who are new to Excel . Show includes some transitions, audio and animation effects. Each slide includes the vocabulary word, it's definition in easy to understand middle school language and a picture reinforcing the definition visually. Feel free to make any modifications you'd like once you purchase! Enjoy!**Files open in Microsoft Excel and are fully editable if you so choose..*************

A fun project where students show their mastery of the following Microsoft Excel skills:Inserting columnsMerging cellsApplying a font and cell styleModifying number formatsAlignment indentationsFormatting datesInserting and cropping picturesI’ve placed an example of what your finished project should look like on the 3rd worksheet named “Finished”.**Files open in Microsoft Excel and are fully editable if you so choose..******************************************************************************

Your teacher is getting married! Congrats!!!! Help me make a wedding song playlist using Microsoft Excel. File opens in Microsoft Word and you can edit the directions as you wish. This lesson will teach you the following skills:Cell shadingCell bordersStylesInserting SmartArtResizing ColumnsAlignment IndentsFormatting as a Table**Files open in Microsoft Excel and are fully editable if you so choose..***************************************************************************************This lesso

You are the teacher next week! Congrats! (Not really), but you will create a week’s worth of lesson plans using Microsoft Excel. View the example on the Example Worksheet. Then, use the tools in the Home Tab to recreate a lesson plan sheet that looks identical and fill it in with your own creative lesson plans. This lesson will teach you how to:Cell shadingCell bordersFormat PainterResizing Columns and RowsFormatting text in a cellAlignment**Files open in Microsoft Excel and are fully editable i

Students use the Insert Function tool to fill in the empty table cells and answer questions. There is an example of how to use this important but rarely taught function along with a detailed explanation of it's parameters for use (file opens in Microsoft Excel)**Files open in Microsoft Excel and are fully editable if you so choose..***************************************************************************************This lesson is contained within my Microsoft Excel Skills Bundle.Other individu

A fun project where students create tables to specifications to show their mastery of the following Microsoft Excel skills:Inserting TablesTable StylesSorting data and Multi-Level SortsFilteringSparklinesBanded RowsAlternative Text for TablesI’ve placed an example of what your finished project should look like on the 3rd worksheet named “Finished”Do all of your work with the existing data on the 2nd worksheet named “START HERE”**Files open in Microsoft Excel and are fully editable if you so choo

Students will learn 3 basic cell references:Relative Cell ReferencesAbsolute Cell ReferencesCell References From Another Worksheet**Files open in Microsoft Excel and are fully editable if you so choose..***************************************************************************************This lesson is contained within my Microsoft Excel Skills Bundle.Other individual Microsoft Excel Skills you may be interested in:Basic Functions and Formulas LessonCell References LessonConditional Formatting

Students use the Insert Function tool to fill in the empty table cells.This lesson will teach you how to insert and edit charts and also teach you the following functions: (file opens in Microsoft Excel).ANDORRIGHTLEFTCOUNTIFSUMIFCONCATENATE**Files open in Microsoft Excel and are fully editable if you so choose..***************************************************************************************This lesson is contained within my Microsoft Excel Skills Bundle.Other individual Microsoft Excel S

Students use the Insert Function tool to fill in the empty table cells. This lesson will teach you how to insert and edit charts and also teach you the following functions:If ThenSUMAverageNested IfOK, the hardest part about this lesson is understanding If/Then Functions and Nesting more than one If/Then Function inside another If/Then Function.**Files open in Microsoft Excel and are fully editable if you so choose..********************************************************************************

A brief activity designed to teach students the following Microsoft Excel Functions:UPPERLOWERPROPERLENROMANROUNDROUNDUPROUNDDOWNMEDIANPOWER**Files open in Microsoft Excel and are fully editable if you so choose..***************************************************************************************This lesson is contained within my Microsoft Excel Skills Bundle.Other individual Microsoft Excel Skills you may be interested in:Basic Functions and Formulas LessonCell References LessonConditional F

A fun project where students show their mastery of the following Microsoft Excel skills:Inserting ImagesInserting HyperlinksPicture Correction ToolsAdding and Renaming WorksheetsTab ColorsFollow the steps to create your own Family Vacation Planning Workbook**Files open in Microsoft Excel and are fully editable if you so choose..***************************************************************************************This lesson is contained within my Microsoft Excel Skills Bundle.Other individual M

Students learn how to insert and edit charts and also teach you the following Conditional Formatting Techniques:Highlighting Cell RulesIcon SetsData BarsText ConditionsClearing Conditional Formatting**Files open in Microsoft Excel and are fully editable if you so choose..***************************************************************************************This lesson is contained within my Microsoft Excel Skills Bundle.Other individual Microsoft Excel Skills you may be interested in:Basic Funct

A brief activity designed to teach students the basics of importing external data into a spreadsheet from both a comma-separated text file and a tab delimited text file. Students also will format the data as a table and complete a test prep extension activity covering various Excel skills they'll see on the Certiport Certification Exam.**Files open in Microsoft Excel and are fully editable if you so choose..***************************************************************************************Th

A brief activity (Answer Key included) designed to teach students the following Microsoft Excel skills:Defining range namesUsing range names in a formulaUsing multiple range names in a formulaFinding named rangesDeleting and editing named ranges **Files open in Microsoft Excel and are fully editable if you so choose..***************************************************************************************This lesson is contained within my Microsoft Excel Skills Bundle.Other individual Microsoft Ex

A brief activity designed to teach students the following Microsoft Excel skills:Protecting files with passwordsMarking files finalDigital signatureProtecting worksheets, locking and unlocking cellsProtecting workbook structure.**Files open in Microsoft Excel and are fully editable if you so choose..***************************************************************************************This lesson is contained within my Microsoft Excel Skills Bundle.Other individual Microsoft Excel Skills you may