This is a project for collage.
Another example would be to setup a Hotel Reservation System, whereby Microsoft Access stores the room and customer details, while Microsoft Excel is used to structure, maintain and analyse all of the hotel charges incurred by the customer. Your information system should provide a service to the business you have chosen.
The Excel element of this project should be professionally formatted demonstrating data management via calculations applying absolute, relative and mixed cell referencing principles across a maximum of two worksheets that demonstrate the following skill set:
• Examples of BASIC FUNCTIONS (Sum, Count, Min, Max & Average) and their application with Logical Criteria applied:
Example of COUNTIF and COUNTIFS.
Example of SUMIF and SUMIFS.
Example of AVERAGEIF and AVERAGEIFS.
A cell reference and the Criteria used as the basis for the logical construction of each of the "Basic Functions” and a label describing the resulting cell contents MUST be provided to enable your lecturer make assessment against the submitted functions. Failure to provide these details within the Information System Documentation File (See section 18.104.22.168) will result in no marks being awarded.
• Example of PIVOT TABLE and Professional use of CHARTS.
• Examples of BASIC IF STATEMENTS and NESTED IF STATEMENTS (Single, & Multiple Test Criteria). A cell Reference and the Criteria used as the logical basis for constructing each of the "if statements” and the related value for entry MUST be provided to enable your lecturer make assessment against the submitted functions. Failure to provide these details within the Information System Documentation File (See section 22.214.171.124) will result in no marks being awarded.
• Examples of LOOKUPs (Both Vertical & Horizontal).
26 freelance font une offre moyenne de $151 pour ce travail
Greetings sir, i am an expert freelancer for this job and your 100% satisfaction is assured if you allow me to serve. Here is the reason. Why you should pick me? a) I am a very expert and have the same kind of ex Plus
Hi there - My name is Paris. I've read your brief and can see that you'd like to have a macro-enabled (VBA) Excel spreadsheet. I have 7 years’ experience designing and developing Excel spreadsheets. I would approach y Plus
Dear Valued Employer, I can add value to your project, by suggesting new ideas. I am fast and reliable. For further understanding why I am the right firm for your project, kindly check my profile, reviews, rating and Plus
Hello. I have read your project description and I can you surely assist you with all the points you've mentioned and more. I have a video in my profile showing the final results from one of my last works and can shar Plus
Dear Client, Thanks for the opportunity to bid on this project. I’ve read your brief on the project and is ready to go for it. I’ve done work on data gathering, data analysis, web researching, data entry and transla Plus
Hi, I have ~4+ years of experience of creating and operating low to very high complexity of Excel/VBA/SQL,SAS, Powerpoint, QlikView based tools/processes, reports. I can assure you of high quality and on-time de Plus
Hi I am here to assist u inthis project I am an acca member currently wor in finance dept of Qatar Airways Have great skill and exp in excel can assist u with high regards Plz share more info to proceed Thanks Lookin Plus
Dear employer, I have been in this industry for more than 10 years and such jobs are my daily practice. I am new on this site, just did three projects with best ratings. I can assure you that if you work with me on Plus
Please hire me for this project. I have vast experience in data entry and updates. I have worked in data entry department for 2 and half years. Most notable was in jubilee insurance company and Diani Beach Restraurant Plus
Sir I am doing data entry from last several years. I am familiar with MS Office products. I am familiar with internet. I am having typing speed of 30 wpm. I am eagerly looking forward for your reply. With regards, T. Plus
Hello, I provide services with 100% accuracy. My main objective is to provide excellent service, with timely, accurate, and professional results. Thanks
I think for this sort of project at least 2 weeks with some iteration is required for a satisfactory result. Looking forward to hear from you. Thanks.
Hi, I'd like to express my interest for the job. I am expert in both excel and access so , I hope I can complete the task efficiently. Thank you.
Dear Sir/Madam I have read your project description and interested in this project. I have 2 years of working experience in Excel . I assure you to deliver my best. Thanks.