Demonstrate a clear knowledge of the role that information technology and information systems play in the business world: Technologies for Business Excel Skills, Assignment, GCD, Ireland

Learning Outcomes addressed and assessed in this Assignment:

(i)Demonstrate a clear knowledge of the role that information technology and information systems play in the business world

(ii)Display an understanding of IT concepts relevant to business and understand how they relate to each other

(iii)Apply practical skills in the most common office applications such as MS Word, MS Excel and MS PowerPoint as the industry standard

ASSIGNMENT DETAILS

In this assignment, you are required to use a spreadsheet and format it appropriately for the communication of financial details while carrying out some financial functions.

Instructions:

The spreadsheet can be found on moodle entitled “ExcelAssignmentTFB2024”. The spreadsheet details information relating to Sales for products of a companies within a given industry.

1. Open the spreadsheet “ExcelAssignmentTFB2024” on the first worksheet. The spreadsheet should be formatted in a user friendly manner so that it is easy to read and analyse the existing data. For example, in the first worksheet is it easy to read all the data/headings? What could you do to improve it? What is missing for it to be more user friendly? We want to make the spreadsheet look professional and attractive to analyse.
2.    For this data we need to be able to see the total, average, min, max and countof the sales units for each companyand for each year .Illustrate these calculations on the spreadsheet ensuring that the values are presented professionally. This must be done using formulae. We also need to find the total sales in euros for each company. 
3. For each company, we need to classify as to whether they are good sales, average sales or poor sales. Therefore we need to add a new column and use a formula to automatically decide for each company which of the three categories each order fits into based on the following information:

Total order greater than or equal to 2,500,000 is “Target sales achieved”Total order above or equal to 1,500,000 but lower than 2,500,000 is “Average Sales” Total order below 1,500,000 equals “Poor sales”

Again presentation of this is important

4. The spreadsheet has four worksheets. In the second worksheet entitled “LinkstotalSales” create linked formulaewhich shows the total of the sales for each of the companies. Each formula in this second worksheet must link by totalling multiple cells in the first worksheet.
5.  Separately, Sony is calculating sales bonuses based on last years sales in the worksheet entitled “Commission” for its sales reps. Working with the other worksheet entitled” rates” devise a function which will work out the commission for each rep. Also, sort the names in the “Commission” worksheet in descending order as this was requested.
6. Create a  suitable chart to show each company’s total  sales in Eurosfrom the first worksheet.Make the chart as user friendly as possible showing enough information to make it clear to everyone. In other words, design it well. Place this chart in a new worksheet and name the worksheet to reflect what the values are representing. Ensure all worksheets named to suit information.
7. Set it up to print effectively.