An Excel Expert to Develop an Excel Spreadsheet for Tracking Student Submissions

Completed Posted 1 month ago Paid on delivery
Completed Paid on delivery

Firstly, I want to know if what I am asking can actually be created in Excel 365 and used in Excel 365 Online. Please dont reply to this post without replying that it can or can't be done. If not, an alternative solution would be greatly appreciated.

I need help creating an excel spreadsheet to track student progress in a course using 5 different options that also includes the date the option was selected.

I can create the drop down list with the submission options, and apply color rules but I can not work out how to make the cell below change to the same color as the option selected and the date it was selected appear in the same cell.

I need to include the date the option was selected selected and because you can't have two formulas in conditional formatting. I thought making a cell in the below row for the date was the only option - any other options to achieve this?

Column A, Row 3 contains Client Name (code), Columns B-K, Row 3 contains the course 14 x units. Column A, Rows, 5 - 19 contains student names. The cells in Columns B-N, Row 5 will include the submission options with a drop down menu or alternatively.

The 5 different grading options are:

Not yet started

Not yet submitted

Submitted for marking

Partially Complete - More work to submit

Competent

Each cell and submission option will be selected from a drop down list and needs to have a different fill colour (#b4c6e7, #ffd966, #ffff00, #fff2cc, #92d050). The row directly below the cell will show the date the option was selected and that cell will be the same color of the grade selected.

All cells in the spreadsheet will need to change based on the submission option selected so cell references won't work.

For example, if Not yet submitted is selected in one cell on 16/04/24, that cell will show Not yet submitted with a fill colour of #ffd966 and the row below will show the date 16/04/24 and have a fill colour of #ffd966. Later that day the student will submit and I will need to change the option to Submitted for marking filled with its specific color and the cell in the row below will need to show the date changed and the same colour as the above option.

The spreadsheet must work in Excel 365 and be able to be shared with other users in OneDrive.

I have attached the Excel file I started for your reference. I have also attached a screenshot of the existing file I currently use showing how its used I context, and how manual it is.

Thank you in advance.

Excel Process Automation

Project ID: #38000490

About the project

56 proposals Remote project Active 1 mo ago

Awarded to:

zubairmbafinance

Hello Yes, it can be done in Excel 365. We can utilize VBA (Visual Basic for Applications) to achieve this functionality. VBA can handle events like cell value changes and can execute code accordingly. By using VBA, yo More

$70 AUD in 4 days
(15 Reviews)
3.5

56 freelancers are bidding on average $141 for this job

schoudhary1553

Top 1% in Freelancer.com Hi, Greetings! ✅checked your project details: ✅Completed Time: In project deadline We have worked on 900 + Projects. I have 6 + years of the experience in same kind of projects. If you are look More

$180 AUD in 4 days
(531 Reviews)
8.4
livegoodlife

Hello there, I am experienced in web scraping and to build script or a windows desktop application by using python. I am also experienced in large data scraping from the given website, by pass IP, Captcha, and anti bo More

$150 AUD in 3 days
(291 Reviews)
7.9
daniyal3214

Hello, Excel expert here. I can perfectly assist you with this and can start on an immediate basis. I am an experienced Excel professional with years of experience in all the tools of Excel including Visual Basic, Auto More

$40 AUD in 1 day
(241 Reviews)
7.3
MartinDudumi

Hi there, I see that all of your task can be done on Google sheets better giving you the opportunity to have great insights on the data. As long as i am an expert on Excel/ Google sheets of course that i can help on c More

$150 AUD in 2 days
(53 Reviews)
6.2
rahulg5466

-------------------I CAN DO IT RIGHT AWAY-------------------- ⭐⭐EXPERT IN EXCEL⭐⭐ Dear client, I can help you with your project of data entry in excel, VBA, EXCEL MACROS, VBA Scripting, building an excel file, excel d More

$130 AUD in 2 days
(64 Reviews)
5.6
merinsinha

I can do it. As 9+ years experiences in these field. I can give good quality work. I have read the guidelines of your work.I believe that i can provide you the best quality works you are anticipating from this platform More

$240 AUD in 3 days
(144 Reviews)
5.7
snehamehta525

Hello, Greetings of the day! I have a vast experience of working in Advanced Excel and I have completed many projects based on Advanced Excel. I have read your requirements and I can complete your project within time More

$250 AUD in 4 days
(49 Reviews)
5.8
softsolution2000

Hi there Yes, it is possible to create the Excel spreadsheet to track student progress in a course using 5 different options in Excel 365. One way to achieve the requirement is by usin More

$163 AUD in 7 days
(6 Reviews)
5.1
sahildogra222

Dear Astrid V., I have carefully reviewed your project requirements for developing an Excel spreadsheet to track student submissions in a course. I am confident that I can deliver this project with perfection by utili More

$30 AUD in 1 day
(9 Reviews)
4.5
hayteekeys

As an Excel-lent expert with a keen eye for detail, I indeed can develop the spreadsheet you need. Working primarily with Excel 365, I can build a system in which each of the five grading options has its unique filled More

$220 AUD in 7 days
(14 Reviews)
4.6
ACCASpogmai

"""""""""""""""""""""""""""TOP EXCEL EXPERT"""""""""""""""""""""""""""" Greetings! It can be. I clearly understand what is requirement of the project Excel Spreadsheet for Tracking Student Submissions. I am an EXCEL Ad More

$55 AUD in 1 day
(29 Reviews)
4.3
zaahidali61

Hi, I have read your project and interested to work with you. I hold master degree in business administration (Finance). Having 5+ years’ experience of Accounts, Finance, Bookkeeping, data entry, excel, word, documents More

$100 AUD in 2 days
(24 Reviews)
4.6
shahhiral27

As an experienced Excel specialist, I believe I can provide a smart and efficient solution for your need to track student progress using five different grading options. My expertise in Excel extends to the creation of More

$140 AUD in 1 day
(6 Reviews)
4.4
saim2105

As an Excel specialist with extensive experience in creating actionable and intelligent spreadsheets, I'm confident that I can deliver a solution to your submission tracking needs. I understand how crucial it is for yo More

$110 AUD in 1 day
(6 Reviews)
3.5
kavitadhingra

As an Excel aficionado for the past 15 years and a Power BI expert, I believe I'm more than qualified to offer the comprehensive solution you need. I've not only developed numerous spreadsheets in Excel 365 but have al More

$250 AUD in 5 days
(8 Reviews)
3.1
syedalihassansh4

Hello Sir, I have read your instructions and I can do it efficiently according to your requirements. Please give me this project and get 100% extra ordinary work with unlimited revisions even after completion of the w More

$65 AUD in 2 days
(10 Reviews)
2.3
IcsfIT789

Hi there, I am a Data Scientist with excellent knowledge and enthusiasm for Microsoft application development. I can do advanced Excel, Word, Access, Power BI, and Outlook and create VBA macros. Advanced Array Formulas More

$50 AUD in 3 days
(1 Review)
2.2
mian62

Hi I have read the requirements and understand them. I can assure you that if you work with me once, you will always work with me on these kinds of projects. would you like to discuss the project with me?

$55 AUD in 1 day
(4 Reviews)
1.6
muhammad12545

HI!! I can develop the dynamic solution you need using VBA in Excel 365. I've reviewed your requirements and understand the limitations of conditional formatting. My approach: Setup Dropdowns: Assist with dropdown cr More

$50 AUD in 2 days
(1 Review)
1.5
ashokflrs

I can do this in few hours, and as a senior developer, I feel, i have enough experience to handle this project. Let's have a discussion , I can start Immediately

$50 AUD in 1 day
(0 Reviews)
0.0