Excel calendar - auto populate task and conditional format

$30-250 USD

Færdiggjort

Slået op

5 måneder siden

$30-250 USD

Betales ved levering

I am looking for a freelancer to create an Excel calendar that can auto populate tasks and apply conditional formatting. I have the calendar format I like and the activities in a data sheet under chicago requirements. I attached my calendar with some formula attempts. Basically, want it to copy task to corresponding date and color code. Would be great if dynamic and would change to the current year automatically, so can see the task that are years out. I like the year view that is in template, great for printing out, but open to others. The calendar should have the following specifications: - Calendar Type: Yearly - Task Categories: The calendar should include specific tasks organized by categories. Want to auto populate task that match calendar due date. (If same due date populate both (all) task with same date in calendar. - Conditional Formatting: The preferred method for conditional formatting is color-coding. I have column with colors. I really liked if the legends could populate in center top of cell, but I am fine if just color coded. Ideal Skills and Experience: - Proficiency in Excel and advanced knowledge of formulas and functions. - Experience in creating dynamic calendars with auto-population features. - Familiarity with conditional formatting and color-coding techniques in Excel. - Attention to detail and ability to organize tasks into categories effectively. If you have the necessary skills and experience to create an Excel calendar with auto-population and conditional formatting, please apply for this project.

Projekt-ID: 37558410

Om projektet

12 forslag

Projekt på afstand

Aktiv 5 måneder siden

Leder du efter muligheder for at tjene penge?

Emailadresse

Fordele ved budafgivning på Freelancer

Fastsæt dit budget og din tidsramme

Bliv betalt for dit arbejde

Oprids dit forslag

Det er gratis at skrive sig op og byde på jobs

Tildel til:

@sultanang464

Hi there, I am an expert in excel. I can do your work perfectly. Can we discuss the details in chat? Regards Razia

$55 USD på 1 dag

5,0

(321 anmeldelser)

7,4

12 freelancere byder i gennemsnit $100 USD på dette job

@AnjaliMehta

Hi There! I have understood the requirements for the task. I have 8+ years of experience in performing Data Analytics, Automation and various other calculations and analysis using VBA, Macro, Power Queries, Pivot tables, and excel based formulas. My expertise is broad and versatile and includes: *Microsoft Excel- Advance formulas -VBA/Macros -Dashboard -Data Analysis -Web-Scraping and Data Entry. *Adobe Acrobat-Fillable forms -Editing and Scripting. *Google Sheets-Advance formulas -Custom Scripts -Dashboard I am Proficient in Microsoft Excel, Adobe CS & CC Photoshop, Illustrator, InDesign, Adobe Acrobat and Google Sheets, and Wordpress I am waiting for a response from your side. Thanks Anjali

$100 USD på 2 dage

5,0

(15 anmeldelser)

5,8

@ExpertSoul

Hi there, I have extensive experience in Excel and can create a customized yearly calendar with auto-population of tasks, dynamic year updates, and color-coded conditional formatting. I'll ensure the design aligns with your preferences, providing an efficient solution for your Chicago requirements.

$100 USD på 1 dag

4,8

(7 anmeldelser)

4,1

@hossamsoliuman4

Hello there! My name is Hossam and I am a skilled backend developer with extensive experience in Laravel and MySQL queries. I have the necessary skills and experience to help you create an Excel calendar that can auto-populate tasks and apply color-coding conditional formatting techniques. I understand your need for a freelancer to create an Excel calendar that can auto-populate tasks and apply color-coding conditional formatting techniques. I have the necessary skills and experience to do this job properly. Specifically, I have proficiency in Excel and advanced knowledge of formulas and functions that allow me to create dynamic calendars with auto-population features effectively. Additionally, I have experience in software development that enables me to write optimized code that delivers fast and efficient results as well as ensure client satisfaction. If you are looking for a reliable and experienced backend developer to help you with your project, please don't hesitate to contact me

$40 USD på 3 dage

5,0

(1 bedømmelse)

1,8

@raojawadahmedna2

Hello, I understand you are looking for a freelancer to create an Excel calendar that can auto-populate tasks and apply conditional formatting. Specifically, you want it to copy task dates to corresponding colors and change to the current year automatically so you can see which tasks are years out. I have the necessary skills and experience to tackle this project: - I have extensive experience in Excel which makes me well suited for this job. Additionally - specifically related to this project - I am proficient in creating dynamic calendars with auto-population features that give users access to current data without having to manually update it throughout the year. This is especially important for calendars where users want to see past events but also benefit from the ability to change layouts based on the current year without manually updating them every time it changes. I would love the opportunity to help you create an Excel calendar with auto-population and conditional formatting features as

$140 USD på 7 dage

4,6

(1 bedømmelse)

1,4

@Jeffcasiyo10

I understand you are looking for a freelancer to create an Excel calendar that can auto-populate tasks and apply conditional formatting. I have experience in creating dynamic calendars with auto-population features and would be confident that I can meet your requirements. My name is Jefferson and I am the founder of SEOPAGE1, a content writing agency based in Dhaka, Bangladesh. After gaining much experience while completing projects, I decided to incorporate the service into my venture. With the support of a team of 50 writers, web developers, graphics designers and marketers we ensure quality end products are delivered to our clients. We specialize in content writing, web design and development as well as graphics design and optimization. We have worked on many successful projects which have been published on reputed platforms online. We understand how important it is for you to have an Excel calendar with auto-population features that change automatically to match the current year so they can be viewed in year view. This is why we take such care in ensuring quality control during the production process - from data entry through processing to end product printing. We would be delighted if you would consider us for this project. Please let us know if you require any additional information

$140 USD på 7 dage

0,0

(0 anmeldelser)

0,0

@Dimasan569

Hello there! My name is Dima, and I am a technology freelancer with many different skill sets. I have been working with programming, databases and networks for over 20 years. I have a strong background in Excel and advanced knowledge of formulas and functions. Specifically, I have the skills necessary to create an Excel calendar that can auto-populate tasks and apply conditional formatting. I understand that you are looking for a freelancer to create an Excel calendar that can auto-populate tasks and apply conditional formatting. I believe I am the perfect fit for this project due to my extensive experience in creating dynamic calendars with auto-population features as well as color-coding techniques in Excel. Additionally, I pay close attention to detail and organize tasks into categories effectively so they are easy to access for users' needs.

$150 USD på 2 dage

0,0

(0 anmeldelser)

0,0

@saim2105

I am excited to hear about your project for creating an Excel calendar that can auto-populate tasks and apply conditional formatting. I specialize in data entry, data processing and Excel so I am confident that I can provide the necessary skills to complete your project. My experience includes creating dynamic calendars with auto-population features so you can count on me to deliver an accurate calendar year after year. I am confident that I can provide the necessary skills to complete your project within budget and on time. My attention to detail and ability to organize tasks into categories effectively make me an ideal candidate for this job. If you are interested in hiring me please don't hesitate to get in touch!

$80 USD på 1 dag