This Advanced Spreadsheet Skills Project for Google Sheets teaches the below advanced functions which can be used to manipulate and analyze data held in spreadsheets.

Students and teachers are expected to look and read through the slides in the presentation provided and then complete the advanced level project (which is based on a scenario called Gregg's Store LLC).

Not only are students expected to use their spreadsheet skills to complete this project, but they must use their skills to read through and understand scenario based worded problems before the attempt the given tasks.

This project is perfect to use to form part of a main lesson. This project will take at least 2 week/10 hours to complete depending on the ability of your students.

Advanced Functions covered:
- Counta()
- Count()
- CountIF()
- Countblank()
- SumIF()
- Lookup()
- Vlookup()
- Concatenate()
- AND()
- OR()
- Combining IF()
- Nesting Vlookup()

Students are also taught how to name a range of cells in Google Sheets.
All answer keys have been provided.

This 46 page resource is provided in digital format and will be accessible via Google Drive.