Creative Teaching Ideas

An ideal task to teach students how to use the VLOOKUP function in Excel and other essential skills. Makes learning these skills simple and easy for students. Tasks include: 1. Use the VLOOKUP function to find the Markup percentage to be added to each flower arrangement. 2. Format the cells in Column B to Currency. 3. In the sale price column use a formula to calculate the sale price. Sale price is calculated by adding the cost to the markup percentage of the cost. Example = cost + (cost *mar

Zip file includes 5 separate Excel files ready to use with your students. Each task has step by step, clearly numbered and labelled instructions. Makes teaching Excel simple and easy with these easy to follow instructions and files. Tasks include VLOOKUP, sorting/filtering data, calculating numbers for wages, sales, overall costs etc.. Creating simple graphs and pivot charts. (Please Note: Prices may need to be updated to reflect local currencies and current prices.) * Only shows preview for 4 f