Are you working with spreadsheets, where multiple users make changes? Then maybe I will agree that compare various changed tables between each other is a nightmare. Sure, there is Track Changes tool, but it is not omnipotent, and in addition, many people do not even know how it works. So what to do with the different tables that […]
You need to have calculation in Excel always with current value of foreign currency or stocks? You do not need to constantly check the website and manually write data in Excel. There is a simple solution for you – connect online table directly to Excel spreadsheet. How to do this, you will learn precisely in this manual. […]
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 […]
