# Do some Excel Work

SCENARIO Related lecture activity (taken from the lecture slides in week 2) Imagine you and a few of your classmates decide to become entrepreneurs. Together you have \$100,000 seed money. Develop a business idea (e.g., in retail or service) – be as precise as possible. Take notes to describe your business model and related business processes. In this project, you will demonstrate your MS Office skills based on this business idea. Note: 1. This is not a group based assignment and every student needs to submit an individual project. 2. If you do not have a business idea from week 2 or if you do not like the idea that emerged in your group you can also develop another idea or submit an alternative project (see below). PREPARATION

Part 1 – MS Excel Develop a business plan to illustrate the financial aspects of a new business of your choice. The Excel workbook should include 5 of the following Excel functions

- Absolute References - Relative References - Aggregation Functions (e.g., sum or average) -

IF Function - LEFT Function - VLOOKUP Function - Chart 2 - PivotTable - PivotChart - Filters subtotals

- Note: You need to include sample data to demonstrate your Excel skills. However, the data and Excel functions should be included for a specific purpose that is relevant for decision makers. This relevance is a substantial part of the marking. The following list gives you some ideas about what you could do to demonstrate the functions above. However, alternatives are possible and welcome! - Overview of start-up cost for the new business - Expected income statement based on different developments (e.g., poor, moderate, good) - Break-even analysis Format your spreadsheet appropriately. You may use colours, styles and fonts of your choice to enhance the readability of your workbook. Formatting is a substantial part of the marking. Limitations: Part one is limited to 5 Excel functions and three sheets (including the original data)

. Do not submit more than one Excel workbook. Alternative project: A workbook with sample data is provided for students who prefer not to work based on the business idea developed in week 2. You will find the file “Office project_alternative [url removed, login to view]” in the project folder under “Assessment” at L@G. Students should complete the above requirements of 5 Excel functions and three sheets using this data. It is also possible to extend the data if necessary. Textual explanation (maximum 150 words): Write a text that explains your business idea briefly. In case you select the alternative project, describe a possible related business. The text should also explain the functions used to demonstrate your Excel skills and why the analysis is relevant for decision makers. Format the text appropriately. Format and presentation are part of the marking. Structure as well as English language capability, including vocabulary, grammar and punctuation will be considered for marking

Part 2 – MS Access Develop a database using MS Access for a company of your choice. The database should be created to support specific information needs. - The database should not include more than five tables. - Every table should be filled with some example data. - Create three queries that are useful for your business. - Create a report that is useful for your business. 3 This is an exercise to demonstrate Access skills. Include specific Access knowledge such as referential integrity and make sure that your queries are useful and correct. Limitations: Do not submit a database with more than five tables, three queries and one report.

Keahlian: Entri Data, Pemrosesan Data, Excel, Penulisan Laporan

Tentang Pemberi kerja:
( 6 ulasan ) runcorn, Australia

ID Proyek: #10303185

johncarteratfl

I am Microsoft Certified Office Expert who has Master level certifications on all the office applications - word, excel, powerpoint and access. I understand your requirement very well. And, if i am considered for this Lebih banyak

\$144 AUD dalam 2 hari
(9 Ulasan)
3.5

## 7 freelancer menawar dengan rata-rata \$150 untuk pekerjaan ini

mehedi276

"Rate and duration will be fixed on discussion" Dear Hiring Manager, I have gone through your job posting and become very much interested to work with you. I am an expert in these fields. I have already completed se Lebih banyak

\$144 AUD dalam 3 hari
(324 Ulasan)
7.1
imranhossain

Hi there, I would very much like to work with you on this project .I am professional with versatile supportive skills set developed through experience. I am an energetic and enthusiastic person who enjoys a challenge Lebih banyak

\$150 AUD dalam 3 hari
(60 Ulasan)
5.9
\$155 AUD dalam 3 hari
(45 Ulasan)
5.0
hardikshah83

Experienced programmer with more than 10 years of development experience here. I have handled production applications with various technologies like .NET, PHP, Classic ASP and many more using databases like MySQL, Micr Lebih banyak

\$150 AUD dalam 5 hari
(10 Ulasan)
4.3