Fermé

Rework or Create Spreadsheet for Scheduling Classes and Instructors

Job Description:

I am looking at reworking a training schedule our company use on Excel. We are a training company with 5 locations around Australia with 5 separate spreadsheets. My biggest goal is to get them combined onto a single spreadsheet to be able to have better vision across the company. We have multiple classes that learn a variety of subjects and our Instructors all have slightly different qualifications. On the spreadsheet, I program the subjects that a class needs to learn and then assign an Instructor to that class that can teach that subject using their initials. Their initials are captured on another tab which can show me instructor availability or if they are in class.

I want to be able to expand this spreadsheet to include the 5 locations, having filter/splice functions for locations, classes, training type etc so the document is easy to navigate and forward plan for areas where we may be short instructors. I would also like to be able to extract data from this, like Instructor use (highlight an instructor with a period of time to see what % they were in a class or available.

I have attached a copy of a spreadsheet we use, the other locations are much smaller. You can see the class name down the left, which would be nice to break up into the different types of training they do, and then throughout the year you can see the subjects they have which are numbered subjects. The 2 letters under the subject are for which instructor type needs to teach that and then the other 2 letters are the initials of the instructor which gets displayed on the 'Availability' tab. The 2 main tabs we use are the 'Schedule' and 'availability'. The other tabs on this are for the subject templates for copying and pasting onto the 'schedule' tab.

I am happy to hop on a call to show you through the sheet and discuss what I would like to achieve. It will also be good to hear any suggestions you have that could be incorporated.

Compétences : Excel, Saisie de Données, Traitement de Données, Visual Basic, Analyse des Affaires

Concernant le client :
( 0 commentaires ) Melbourne, Australia

Nº du projet : #35889883

31 freelances font une offre moyenne de 205 $ pour ce travail

schoudhary1553

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

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% AUD en 7 jours
(577 Commentaires)
8.5
Giovanni704

Hi there! I have more than 10 years of experience as a Data Base Administrator and Analytics Engineer. I'd love to work together on your project creating spreadsheets. I'm so responsible and kind, I'll always send you Plus

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% AUD en 1 jour
(49 Commentaires)
6.9
topacademictutor

I have a fair amount of experience in managing projects like Rework or Create Spreadsheet for Scheduling Classes and Instructors. Please consider me for this job. I am a full-time freelance writer with more than 6 ye Plus

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% AUD en 1 jour
(60 Commentaires)
5.4
assignsolver

I have read and understood all your project details "Rework or Create Spreadsheet for Scheduling Classes and Instructors" and I feel my self the best candidate to complete this project with 100 percent accuracy. I ha Plus

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% AUD en 1 jour
(101 Commentaires)
5.8
AmazingEngr76386

Thank you for giving me the opportunity to work on your project. I understand that you would like to rework the training schedule that your company uses on Excel. You would like to combine the 5 separate spreadsheets i Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% AUD en 7 jours
(18 Commentaires)
5.5
hritikdanng

Hi, I’m a qualified Chartered Accountant/CPA and Investment banker, I’m expert in MS Excel, task you mentioned is basic for me and maybe we could do a quick zoom meeting to discuss more. Thank You

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% AUD en 1 jour
(29 Commentaires)
5.1
toplinesolutions

I have read and understood the details of this project "Rework or Create Spreadsheet for Scheduling Classes and Instructors". I am a professional ghostwriter since 2010. I have helped in writing a magnitude of Artic Plus

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% AUD en 1 jour
(25 Commentaires)
4.9
HelpingHut

I am damn sure that I can complete this project "Rework or Create Spreadsheet for Scheduling Classes and Instructors" beyond your expectations and within your given time and budget. I have command on multiple copywri Plus

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% AUD en 1 jour
(20 Commentaires)
4.1
TopWritingGuru

Rework or Create Spreadsheet for Scheduling Classes and Instructors My name is Rabia Faisal, I am working in the writing industry since 2011. In this time, I have served countless clients with full amount of satisfact Plus

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% AUD en 1 jour
(6 Commentaires)
2.7
SolutionMart

Rework or Create Spreadsheet for Scheduling Classes and Instructors I am a supreme writer who has full command over Academic Writing including; SWOT, PESTEL, Porter Five Forces Analysis, 7Ps, summaries, Case Studies, Plus

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% AUD en 1 jour
(3 Commentaires)
1.9
WritingLabb

Rework or Create Spreadsheet for Scheduling Classes and Instructors I am Minahil Hameed with a vast amount of experience in multiple fields like; Finance & Economics, Accounting & Cost Accounting, Business & Managemen Plus

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% AUD en 1 jour
(2 Commentaires)
1.4
FineIdeas

✦◼️✦ "Full-5 Stars Rating✦◼️✦ - ✦100% Marks Guaranteed!✦ I have 9+ years of experience in managing academic writing jobs successfully. I have done my Master's in English Literature, but I have worked with clients co Plus

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% AUD en 1 jour
(1 Évaluation)
1.0
HelpingLab

I am an academic expert who can help you with your solutions like; Case Studies, Summaries, Reports, Thesis & Dissertations, and Online Exams and Courses in almost every language. I am new to this website but I assure Plus

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% AUD en 1 jour
(0 Commentaires)
0.0
Cvtvlinvrojvvs

Hello, im catalina and i'm second grade studient, hence i can make the work, in four days, I will be attentive to your answer, greetings in advance

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% AUD en 4 jours
(0 Commentaires)
0.0
ishikasheikh90

Hi am interested in the project you are hiring If you are choose me ,then I will do my best an on time

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% AUD en 7 jours
(0 Commentaires)
0.0
snorashikin7

First of all, i would like to thank you for your time to read my cover letter and process my application. As i recently came across your job posting, i was thrilled to be a part of your company’s success. I’m 30 years Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% AUD en 7 jours
(0 Commentaires)
0.0
dattatrayG2238

My computer knowledge Excel course Typing cource and I do this in proper without any queries I'll give my best

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% AUD en 7 jours
(0 Commentaires)
0.0
s8888alikhan4

Hi there! I have more than 3 years of experience as an Accounts Executive and Payroll Officer. I would love to work together and do the project you indicate in a professional and efficient manners. I have a lot of know Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% AUD en 7 jours
(0 Commentaires)
0.0
nurulaimanabjali

hi i have exprience in data entry and microsoft excel i can produce good work to customer based on their recommendation and preference. looking foward to work with you thanks

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% AUD en 7 jours
(0 Commentaires)
0.0
aishaalthaf448

Freelancer is responsible for executing the tasks that require a skilled and capable person to complete in the shortest amount of time. This includes resolving customer issues, writing and editing content, managing pro Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% AUD en 7 jours
(0 Commentaires)
0.0