Google Sheets Automation Needed
Budget: $10 – $30 USD
I'm urgently looking for a Google Sheets expert who can help me streamline my workflow. I currently use Google Sheets but may benefit from certain automated functions. However, I'm not quite sure what functions might be useful for automation, so I'd appreciate your expert input and recommendations. A strong knowledge of Google Sheets is essential, and previous experience in similar projects will be greatly valued. Please get in touch as soon as possible.
Use the attached set of data with the following sheets:
Sheet 0: Data (1)
Sheet 1: (1) Profile by Section and Sex
Sheet 2: (2) Profile by Section and Grade in Previous Math
Sheet 3: (3) Profile by Section and SHS Attended
Sheet 4: (4) Profile by Sex and Town
Sheet 5: (5) Profile by Section, Sex and Age
In Sheets 1-5, prepare the required profiles.
Present the summary data in a table and graph. Discuss the result.
Research and use the commands "VLOOKUP", "COUNTIF" pivot tables and date computation in spreadsheets.
All solutions and answers must be done in the sheet attached,
DO NOT CONVERT into PDF, because the formulas will be checked.
Include also the narratives on how you did the specific profile at the lower part of each sheet
Use the attached set of data with the following sheets:
Sheet 0: Data (1)
Sheet 1: (1) Profile by Section and Sex
Sheet 2: (2) Profile by Section and Grade in Previous Math
Sheet 3: (3) Profile by Section and SHS Attended
Sheet 4: (4) Profile by Sex and Town
Sheet 5: (5) Profile by Section, Sex and Age
In Sheets 1-5, prepare the required profiles.
Present the summary data in a table and graph. Discuss the result.
Research and use the commands "VLOOKUP", "COUNTIF" pivot tables and date computation in spreadsheets.
All solutions and answers must be done in the sheet attached,
DO NOT CONVERT into PDF, because the formulas will be checked.
Include also the narratives on how you did the specific profile at the lower part of each sheet