Hello to all. I am a Data Analyst and Excel and Google Sheets proficient who works for more than two years in these programs. The link below is one of my projects. It calculates the grades, prepares dynamic dashboards and current participant profile. You can control all this workbook just with one or two drop-down cells in each sheet, two macro buttons, and entering the data about homework scores in HW&CS sheet. This sheet is an open-source document that you can source freely giving the necessary credentials that contain my full name, link to this file and my Linkedin and Github account. I am the only author of this project. And kindly ask you to give credits while sharing this with others or using it by yourself.
This project was prepared for Data Science Academy Bootcamp that is held in Azerbaijan by "QSS Analytics" LLC (a local data company) for the appraisal system in Bootcamp Training. Some recent modifications were made over the workbook after I quit my job and began to work as a freelancer. All the data provided were pseudonymized and are completely fake, except for the name of the company and training.
This workbook is a complete pack and the change in some part of them may require additional changes to the whole workbook, because of relational tables, functions and changing length and width of ranges.
For further information, you can contact me at agayeva.sitara@gmail.com or the accounts I have provided in my workbook.
Hello to all. I am a Data Analyst and Excel and Google Sheets proficient who works for more than two years in these programs. The link below is one of my projects. It calculates the grades, prepares dynamic dashboards and current participant profile. You can control all this workbook just with one or two drop-down cells in each sheet, two macro buttons, and entering the data about homework scores in HW&CS sheet. This sheet is an open-source document that you can source freely giving the necessary credentials that contain my full name, link to this file and my Linkedin and Github account. I am the only author of this project. And kindly ask you to give credits while sharing this with others or using it by yourself.
This project was prepared for Data Science Academy Bootcamp that is held in Azerbaijan by "QSS Analytics" LLC (a local data company) for the appraisal system in Bootcamp Training. Some recent modifications were made over the workbook after I quit my job and began to work as a freelancer. All the data provided were pseudonymized and are completely fake, except for the name of the company and training.
This workbook is a complete pack and the change in some part of them may require additional changes to the whole workbook, because of relational tables, functions and changing length and width of ranges.
For further information, you can contact me at agayeva.sitara@gmail.com or the accounts I have provided in my workbook.
Thanks for your attention!
https://docs.google.com/spreadsheets/d/1eh3Ul5ZmmqaeexldpKgarZ8JloJXFoywPeA8Y1TYwwg/edit?usp=sharing