Excel
3D Formulas in Excel
In this lesson, I’ll show you how to create 3D formulas in Excel. A 3D formula is one that uses cells from multiple sheets in its calculation.
Click here to download the project file used in this lesson.
Excel Quickie Assignment #2
This Excel Quickie assignment provides a good opportunity to learn about or practice using the COUNTIF() function in Excel. For information about the COUNTIF() function, you may want to visit Microsoft’s COUNTIF information page.
Click here to download the Employee of the Month Count starter file. Follow the directions in the textbox on the first worksheet.
Excel Quickie Assignment #1
This is the first of my quickie assignments, which are meant to be short but very useful for teaching and reviewing valuable Excel skills. These assignments do not include step-by-step instructions. They are meant to be used as formative assessment or possibly as material for walking students through how to complete tasks.
Click here to download Smitty’s Restaurant Item Sales Summary. Student instructions are listed in the textbox contained in the sheet. Remember that there are other, much more advanced skills that could be taught with this simple dataset, so think about ways you can rework the instructions to better target whatever skill you are trying to teach.
Intro to Excel – Video 2 – Basic Formatting
Formatting spreadsheets in Excel 2013 is easy! This video will show you some basic formatting techniques, including formatting dates with custom codes, Formatting as a Table, color fill, Merge and Center, and chart color themes.
Intro to Excel Quick Tip – Save Excel Files
Save Early and Save Often!
In this video, you will learn why you should save your Excel files and how to save Excel files. The differences between the Save and Save As commands will also be discussed.
Introduction to Excel – Video 1
In this video, we will be creating a basic, unstyled spreadsheet for So Sweet Lemonade Stand. We will discuss formatting and making the spreadsheet pretty in the second video of the series. You can grab the starter file here if you don’t want to type in the raw data. (I hope you start from scratch because you get better at inputting data through repetition!)