Streamline Your Billing Sheet in Excel for Operations with airSlate SignNow

Billing sheet in excel for Operations

hello everyone in this short video tutorial you will learn how to make a simple spreadsheet in Excel in just five minutes if this video seems too fast or slow to you then you can easily choose the playback speed that suits you I wish you a pleasant viewing so I'm starting first of all we will analyze the easiest and fastest way go to the insert tab and click on the icon called table a small window will appear in front of you now you need to specify the range of cells that your table will consist of in order to do this you need to click on the cell from which the table will start and without releasing the mouse button stretch the area exactly the way you want do not be afraid to make a mistake because all inaccuracies can be easily corrected if necessary so having decided on the Range press the enter key now it remains to choose the table style pay attention to the tab that appears under the name table Constructor in it you can quickly add or remove the filter button or for example display the final row and so on and a little to the right clicking on this icon will open a menu for selecting the appearance of the table it remains only to choose the parameters that are suitable for you and you can start filling in however this method of creating tables is not ideal in the future you may encounter various limitations when working with data in such a table therefore I recommend mastering the second method of creating tables which we will discuss in more detail first of all select a range of cells please note that this time you do not need to go to the insert tab next click on the Arrow next to the Border selection tool that's what he looks like in the list that opens select the option all borders foreign now I will show you the process of creating a simple table and explain in detail each of my actions the topmost line I have in common and I will call it the sales report I will select this row and use a special command to combine the specified cells and place their contents in the center now I fill in the next cell next I need to specify the months so that I don't have to type the name of each month manually I'll just pull the lower right corner of the cell down thus I use the autofill function and saved my time similarly I will fill in the remaining cells of this row foreign as you can see this function also works with numbers I think you've noticed this misunderstanding at the end of the table I made it intentionally in order to show you how to make certain adjustments surely you already know that most editors have the ability to undo the previous action and Excel is no exception if you made a mistake and want to cancel the action just click on the arrow in the upper left part of the working window so I click on it and all my previous actions are canceled [Music] on the other hand you can do the opposite that is return a previously cancel action in the program to do this there is an opposite Arrow but it's even easier to use a special keyboard shortcut two variants of such combinations will now appear on your screen [Music] the first is the cancellation of the action and the second is the return of the action just pinch them at the same time on your keyboard the more useful keyboard shortcuts you know the easier and faster you will cope with your tasks in Excel next if you need to erase something just highlight it right click select delete and confirm your action by clicking ok [Music] if you accidentally forgot to add a column then move the mouse cursor to the upper part of the workspace where the letters are indicated right click and select insert [Music] or you can do the opposite that is delete the extra column and similarly rows are added or deleted the only difference is that you need to perform these actions on the left side of the document with numeric designations [Music] so we continue I know that you are attentive and could not help but notice how the text in the cell goes beyond its border and blocks the neighboring cell this is very easy to fix to do this move the mouse cursor to the letter designations and set it to the right edge of the column in which your text does not fit after that you need to double-click on the left Mouse button thus the column was automatically scaled and now the text does not go beyond the boundaries of the cell also you can change their size manually this can be done with either one column or several you can change the row sizes in the same way okay I keep filling out the table now I need to enter sales data I will speed up this process so as not to waste your time done what do you think is missing here perhaps I forgot to specify the currency but this does not mean that I will have to enter it manually in each cell everything is much simpler [Music] I select the area with all the numbers and then click on the right Mouse button and go to the cell settings in the first tab I am interested in an item called currency this is where I choose the currency I need and also remove the extra decimal places I don't need them having set my values I press the enter key it remains to calculate the total amount I add one more line and write the word total I'm adding borders I've already shown you how to do it but it's even better if I use the sample format option so I cancel the last action and now look I highlight the penultimate line and click on this icon then I highlight the final row as a result I copied the entire format of the penultimate row including borders and other cell settings even the currency will now be automatically displayed in the final row as you can see the sample format option can be useful it's time to do some simple calculations formulas are used for calculations in Excel I just highlight the necessary data in the column then go to the formulas tab and select automatic sum calculation [Music] and in order to find out the result in other columns as quickly as possible I will use autocomplete I told you about this function recently formulas can also be entered manually you need to know how it's done to begin with the equal sign is put in the cell and then the formula is entered you can enter numbers or select specific cells whose values you want to use for your calculation to do this you need to add them to the formula by simply clicking on them after writing the formula you need to press the enter key for more complex calculations Excel has a lot of various functions and finally I will bring the appearance of my spreadsheet to the desired Style just follow my actions I will slightly enlarge the top two lines I will increase the font of the text and make it bold [Music] I will perform the alignment in the center [Music] foreign and I'll use the fill tool to visually separate the header even more from the rest of the table of course in this video we have not sorted out a lot of things and you will probably have questions when you start creating your own table as soon as 1 000 subscribers appear on this channel I will write down for you a very detailed and free lesson on working in Excel so subscribe to the channel the soon as possible and give a thumbs up there is still a lot of useful material ahead I thank you for your attention goodbye foreign