Find Jobs
Hire Freelancers

Need expert

$10-30 CAD

Đã hoàn thành
Đã đăng vào hơn 4 năm trước

$10-30 CAD

Thanh toán khi bàn giao
What is the group project about? This assignment may be completed in a group of 3 students or less (you may also work on your own). You will prepare an Excel Workbook based an existing organization or topic of your choice presenting company information and statistics such as: • inventory • human resources • sales and revenue • budgets • financial analysis and forecasting • industry data • sport statistics How do I do the group project? The following steps will guide you through the process of doing your group project. • Form a group of 3 students. • Brainstorm the organization’s general information such as its goals, structure and function • Collect relevant data and examine the data • Design the user interface (the worksheets) • Develop the worksheets • Test and debug the completed application • Submit your work through the Blackboard. The work should be properly referenced (i.e., where are you getting your numbers from?). • Each worksheet should be “properly formatted” (e.g., clear titles, worksheet tab named, use of dollar signs for currency, etc.) • The spreadsheet should not be simple recreation of tables/charts found on websites of your subject organization. In other words, you must analyze or summarize the data using tools learned in the class. Specifications about your workbooks/worksheets Your workbooks/worksheets will meet the following requirements and your marks will be based primarily on these criteria. • Include at least 8 worksheets • Include a documentation/reference worksheet • Link to a website related to your organization • Use document header/footer • Include 3 different type of charts (module 1) • complex calculations using multiple operations and parentheses (module 2) • Use AVERAGE, MAX, MIN and COUNT functions (module 2) • Conditional formatting (module 2) • Include relative and absolute references (module 3) • What if analysis (module 3) • Goal seek (module 3) • Freeze rows/columns (module 3) • IF functions (module 3) • Data table (module 4) • Use a FINANCIAL FUNCTION, i.e., PV, FV or PMT etc. (module 4) • Amortization table (module 4) • Protecting worksheet (module 4) • Headers and footers (module 5) • Round functions (module 5) • 3-D references (module 5) • Linking workbooks (module 5) • VLOOKUP functions (module 6) • Autofilters (module 6) • Tables (module 6) • Database functions (module 6) • Other tools learned in the class. The more, the merrier!! Make sure to indicate on the spreadsheet what functions are being used to so that I won’t miss it! Your worksheets must be substantially different from the worksheets found in-class exercise or MindTap projects. In other words, your spreadsheet must be original. Resources for financial data 1.​[login to view URL] 2.​Financial Post Advisor (accessed through GBC Library Website) 3.​Organization’s website often has a page called “investors”. 4.​Industry statistics, such as [login to view URL] 5.​Google finance, Yahoo finance
Mã dự án: 22709013

Về dự án

2 đề xuất
Dự án từ xa
Hoạt động 4 năm trước

Bạn muốn kiếm tiền?

Lợi ích khi chào giá trên Freelancer

Thiết lập ngân sách và thời gian
Nhận thanh toán cho công việc
Phác thảo đề xuất của bạn
Miễn phí đăng ký và cháo giá cho công việc
Đã trao cho:
Avatar người dùng
     Let's chat and discuss regarding the project .i can assure you A grade quality work. Running Academic writing firm since 2005. Have served over 200,000 of students all over the world in their online course and degreeI have 12 Year Experience in Academic, research paper, assignments, paper writing, Buss writing, research projects. We know all Format and referencing style like APA, MLA, Harvard. No need to make the full payment, I will start the work and if you like the work go ahead with me if you don't like do not pay. Let's chat and discuss. Hope to hear from you soon. Thanks
$10 CAD trong 1 ngày
5,0 (2 nhận xét)
1,7
1,7
2 freelancer chào giá trung bình $18 CAD cho công việc này
Avatar người dùng
This assignment may be completed in a group of 3 students or less (you may also work on your own). You will prepare an Excel Workbook based an existing organization or topic of your choice presenting company information and statistics such as:
$25 CAD trong 1 ngày
4,8 (141 nhận xét)
6,1
6,1

Về khách hàng

Cờ của CANADA
Toronto, Canada
5,0
1
Phương thức thanh toán đã xác thực
Thành viên từ thg 12 5, 2019

Xác thực khách hàng

Cảm ơn bạn! Chúng tôi đã gửi email chứa đường link để bạn lấy tín dụng miễn phí.
Đã xảy ra lỗi trong khi gửi email của bạn. Hãy thử lại.
Người Dùng Đã Đăng Ký Tổng Số Việc Đã Đăng
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Đang tải xem trước
Đã cấp quyền truy cập vị trí.
Phiên đăng nhập của bạn đã hết hạn và bạn đã bị đăng xuất. Hãy đăng nhập lại.