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 […]
I have prepared another video; and this time we are back to Excel, which will introduce a quick tweaks to select empty cells. You need the table quickly find and select blank cells? This trick saves a lot of time. See one minute video and everything also try on the attached file. If this guide has helped you, become […]
Besides standard icons in office applications users are using, there are a number of shortcuts that will speed up your work. I picked several most common, which I also frequently mention on training, for many tricks in Excel, and also here is an useful special symbol list. The list of these shortcuts can be downloaded for free in […]
