Raports+of+Excel-+Joanna+Kraska

Wpisz tu zawartość s 19th, 24th, 26th of February and 3th, 5th of March

During these classes I learnt how to use Microsoft Office Excel to make exercises of statistic and finance. I already know how to count mode, median, quartiles, variance and average value of numbers (geometric, harmonic). Maximum and minimum value of several numbers. It is very helpful to make an final evaluation for students in class, to check how the distribution of results looks like. Moreover, thanks to it we can find out how GDP index is changing during time. Besides we can count average price of stuffs when we know units prices and amounts. Standard deviation and distribution. Probability of the highest and the lowest value of all set. How to obtain the value that you can use to construct a confidence interval for a population mean. For example, if x is the sample mean of delivery times for products ordered through the mail, x ± CONFIDENCE is a range of population means. Additionally, I also know how to check the amplitude between two values. Hlookup function which let us find and to match value from the another table. The function of liner trend which helps us to estimate future value of some phenomenon. Later, I got know how to make financial analysis of business project thanks to excel- how to count profits value, cash- flow, costs of the project- fixed and variety costs, amortization costs of car. How to estimate the price when the sales amount is changing. How to count value of taxes. trony 10th, 12th, 17th, 19th, 24th, 26th of march, 14th, 16th of april During the classes of march I was finishing Excel. I was improving my abilities in creating formulas of finance and statistic. Thanks to this program I can estimate amount of money wich will acumulate after period of time in bank- credits and how to invest the money. I got knowledge how important and useful the program can be in caunting are. Thanks to it- just knowing formulas -you can check economical side of your bussiness. Putting suitable datas I can compare now the bids of banks or companies. On april we started with Data Basis- using Microsoft Acess. It helps us collecting datas of subject which is intereted for us. Besides we can build reletions between useful datas- as for example students with their frequance lasses. 4th, 7th of may I got knowledge that after creating my database I can run the report which show me summarizing informations which Im interesting in. For example having a company of seiling I can summarize how much money I received from each customer- it can be used as eveidence document. I can fliert data also using one of the queries functions.