Features of Excel
The software that I am using to make my project is Microsoft Excel.
Excel has feature that would help me make my project and make it
better in a way. These features are written in detail below.
Features include:
· Formulas
· Comments
· Hyperlinks
· Pivot Tables
· Cell shading
· Locking cells
· Cell validation
· Insert Pictures
· Cell referencing
· Using AUTO SUM
· Conditional Formatting
· Relative and absolute addressing
· Charts (graphical representation of data)
· AND, LARGE, IF and TOTAL calculations
· Dragging function (replicating formula using fill handle)
Goal seek
=========
This is when you have a target cell that you want a specific value in.
this could be the profit made for a shop. In excel you have formulas,
and this goal seek will work backwards to calculate the original
information. For example if you wanted to work out how much you would
have to sell coke cans at to get a profit of £50 pounds when you have
25 to sell, goal seek would work backwards to show that you need to
sell each can at £2. You then use this as a guide to see the variables
that you could have.
Pivot Tables
============
Pivot Tables are a feature that will show information from a table the
way that you want it to be shown. I could use this in my project to
display the amount of sales that are made in different ways.
Cell protection
===============
When you have many cells with important information such as formulae
and formatting, the last thing you want is for the user to
accidentally clear these cells. In order to make sure that this does
not happen you can protect the cells against alteration. This will
make sure that the user does not mess-up anything on the sheet.
Functions IF etc.
1.To increase prices according to 4th scenario (total line price increase by 5%) and from short-term revenues income use resources for advertising.
For the month of December, our expected demand is 377 units of Double Team (Fries and Nuggets with Drinks). 377 orders would need 28,297.08grams of fries and 18,864.72grams of nuggets; in cooking this, it will consume 12,563.90ml of oil; to make the juice, 4,716.18grams of powdered juice and 6,036.71ounces of water is needed; and 377 cups and 377 straws because 1 unit of Double Team needs 125g of Fries, 50g of Nuggets, 33.3ml of Oil, 12.5g of juice powder, and 16oz of water, 1 straw and 1 cup. In order to meet this demand for the month of September, we must be able to sell at least 16 orders of Double Team per
(Graph below would be posted using the PowerPoint for students to see before open discussion
van Wijk, J.J., "Views on Visualization," Visualization and Computer Graphics, IEEE Transactions on , vol.12, no.4, pp.421,432, July-Aug. 2006. Retrieved from http://ieeexplore.ieee.org.uproxy.library.dc.uoit.ca/stamp/stamp.jsp?tp=&arnumber=1634309&isnumber=34266
I can do this by setting up the diagram above. You need to get a
Tableau software is making it easier for businesses to analyze data to better their business strategies and intelligence. This software also allows you to connect to specified information from many different sources and can then analyze the collected data in multiple ways. Tableau software ensures that companies are seeing the same picture across multiple departments and levels.
To determine if Lille Tissages, S.A. should lower the price to FF15.00/m or not we need to consider the Variable costs and the Contribution margin associated with Item 345.
symbols (to describe data) that are easily understood by the viewer of the map. By looking
...ultural background to be introduced, but never gives a definite example on how to do this.
chart on a later page. First, though, It probably would be good to tell a
I chose a potential selling price of $24.99 and got a cost per unit of $2 from a manufacturer on Alibaba. I added all the other approximate costs associated with selling the product into the spreadsheet
Process costing is used for homogenous products (continuous flow processes such as producing cans of soda).
my check off sheet with the hematology supervisor. One of the first things I learned was
To do this I highlighted the cells which need this function of validation used and went to the data toolbar and validation.
...mpare price and ask them whet ether they can get the same product cheaper. Another major factor that greater influences other to increase expenses and should be avoided are credit cards. Credit cards can make someone feel like they have a lot of money to spend however all that debt is piling up while you are forgetting to pay.