It happens to everyone in life, that suddenly you do not see the Excel cell gridlines and no matter what you do, you can not show it back? The solution is not difficult, only to find it. How to do it, you will learn just in this video. Hiding the grid does not have to be on your […]
Excel is an effective tool for managing data in tables. The easiest way to learn to work in it, is to attend Excel training. Learn how to create, edit, combine tables, use the tools of filtering functions over to the summaries and pivot tables. You may be surprised what you can do in Excel and […]
Creating a chart may not take minutes or hours. Using simple trick you’ll have it in a few seconds. In the video you can find a way to create a chart, but it is not the only way. Remember that the key to success is to have properly created source table and the data correctly selected. Wrong data […]
It also happens that you have to repeatedly change the color, font type or cell borders? End of slavery … to copy the appearance of one cell to another, use the Format painter tool. How to do it? Look at this minute video widgets. The same procedure can also be used for transferring the appearance […]
For larger tables in Excel often happens that when you scroll down or right mouse it will hide heading rows or columns, and so we lose sight of the importance of information displayed. To avoid this, you can use a tool of freeze panes. How this work and what can it do, you will learn in this free […]
How to work with calculations with square roots and powers in formulas Excel? It serves mathematical symbols and functions for this. In this article we will focus on just how to use it in excel formulas or insert a square root of various levels. They are not used too often, but in certain subjects like math, statistics, […]
Check out the new video for free about Flash Fill tool in Excel 2013 that helps you to divide words into several columns, the attributes of the date and more. Just to show what you want to do, and Excel 2013 will complete the job. You do not need to some functions, which used to take […]
