How do you copy and paste a formula in Excel while changing one cell reference?
This is a little lesson that teaches the difference in Relative and Absolute Cell References: Legs, Eggs and Pigs. It is a spreadsheet that will calculate the daily sales for three products.
There is one sheet for each product: Legs, Eggs and Pigs. There is a summary sheet that adds up the sales for all products on each day.
Here is a YoutTube video that shows all the steps that you can watch if you wish.
Microsoft Excel 2013 Intermediate: Legs, Eggs and Pigs in a Basket
Buy the books at Amazon: https://thecomputermama.us/books-page/
Please evaluate my Courses: Visit our school at UDEMY