When completing tables we may offer some items to be selected from the list of options using the Data Validation. You can ensure that users always selects one of the values and no other, or perhaps let Excel to calculate a formula or format the cells in a table right by the selected option. Whether in […]
To automate the calculation and display values depending on the fulfillment of conditions we use IF function in Excel. Anything that depends on another cell, the result of the formula or filling values, can be easily determined by just this feature. This is a function from the Logical category and in this article, learn how to use it. Adding IF […]
The conditional formatting in Excel automatically help color the cells with numbers, text or dates according to the selected criteria. You do not have to search values or use difficult filter, you can just see the colored cells. In addition, when changing values, conditional formatting immediately respond by repainting cells. You can format individual cells and also the […]
In large tables it is not easy to navigate and quickly find what you need. This tool will serve AutoFilter, which is presented inside the video. Learn how to turn it on, how to set one or more conditions, and how to use a new feature – filtering by color. If this guide has helped you, become a […]
One of the new features introduced by the developers of Microsoft Excel version 2013 is the timeline. In the 2010 version had preceded the tool Slicer of Pivot tables, of which you will learn more in the video. The pivot table is a general summary tool used for analyzing data. It can display effectively and comprehensively summary […]
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 […]
