Users commonly use predefined series of numbers, dates, days of the week or month. Besides these, you can create your own custom list (eg. the foreign names of the days, months, list of counties and cities, etc..), which will accelerate the formation of stereotypes, frequently used, consecutive values. Custom lists Creating custom lists is a litlle hidden setting in Excel, […]
When connecting Microsoft Office applications we often use copy a table from Excel into PowerPoint or Word. Usually people would have used the simplest way, ie via CTRL + C (copy) and CTRL + V (paste). Such a procedure may not insert a table in the desired format. Check out this article on methods that […]
Did you receive a table full of calculations that someone else did and you got lost inside them? Use the tools to evaluate formulas, it can browse calculation step by step and discover errors that are worth for a bad result. Watch the video to activate Predecessors and Successors. Let’s not forget the Formula Evaluation tool that shows step-by-step calculation […]
It happens that the table contains a group of heading lines, but these titles will not appear in the other cells and these are seen as empty cells. When we want to take these values and copy them into empty cells down to another value (someone says to fill down), there is an interesting trick to do it. […]
Did you know that Excel can calculate a different way than by creating formulas? A little bit different procedure demonstrates this video. You can actually change the selected value via the “Paste Special” option. If this guide has helped you, become a fan on Facebook and recommend this site to your friends, it can be useful […]
When selecting the cells in Excel it is sometimes necessary to quickly find cells with some special features. E.g. we want to quickly select the blank cells or cells containing only numbers. Other times, it fits in group or summaries selecting only the visible cells. In short, there are situations where users would give anything in the […]
In Excel 2013, you can compare numeric data geographically on a three-dimensional globe, using the add-in PowerMap. Look at the video how to do it. If this guide has helped you, become a fan on Facebook and recommend this site to your friends, it can be useful for them too. Please note that this tutorial is presented […]
