Search from various English teachers...
Russia flagDenis
funding Funds in business and rules of work with them “There is a gigantic difference between earning a great deal of money and being rich.” —Marlene Dietrich (Import data from another sheet, hide rows and cells, summary, insert cells and columns, unite columns, fixed value in formulas, formula 0 If) Hi everyone! I am Denis Kulikov and today we will start to work! First of all I ask you to follow me on instagram and Facebook. That’s how we can keep in touch, and also how you can ask me a question if you need to. Today we will talk about funds. Moreover we’ll create your own table with funds. So firstly, we should create the new sheet. we should click here and rename be this way. I m clicking on this triangle and choosing command @rename@. ok. now we should to import couple information from our previous sheet. I highlight B15 text equal symbol, choose another sheet and click on B14, but before clicking male sure, that your arrow line on correct position - after equal symbol. Look hows look like this formula. Then we highlighted next sell C15. And create revenue data. How we can do it? it is very easy. We’re starting to tape a formula. equal choose the command Summary and highlight next cells C 15 and D 15. Why I suggest you to use this formula? Because, this formula is very flexible. For example some days you ll be have the new one product and you create the new one section in cash flow list, so this formula will tale data from this cells too. Let I show You, how you can insert cells. We go on our previous list. Highlight all column, call the context menu and choose common insert column. If you want than formula apply data from this column you should insert column between columns which include in formula. Just look the example. Ok. Next we will create 5 funds. This is my strategy, then after you'll understand algorithm you ll be able create your own funds. On each fund we will need 3 columns. Lets start. Title D13 as Income, E13 as outcome and F13 as total. And lets change their size by this way. Title D12 as 30. This is percentage of your money which you want to keep in this fund. Then, you should unite E 12 and F12 by this way. ( showing). And here we will write title of this funds, for instance - salary.

Corrections · 0

Don’t miss out on the opportunity to learn a language from the comfort of your own home. Browse our selection of experienced language tutors and enroll in your first lesson now!

Start Learning Today