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 […]
Going on a vacation for longer time and you want your e-mail box automatically inform the sender of your absence? In Outlook, there is a tool called Out of Office Assistant. It allows you to activate an automatic response to a received messages, especially for corporate colleagues and outside the company for the sender. Then there is the […]
Making a presentation is not only about to insert text and images, it should also look nice. If you do not have time to create your own design, you can use pre-defined themes that are in PowerPoint and other Office applications available since version 2007. How to turn it on or use only for selected slides? […]
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 […]
Sorry, this entry is only available in Czech.
In presentations we have often the problem of text align in the same place on all slides. Aligning it manually is quite time-taking :-). Therefore you can use eg. the helping guides that can align objects on all slides presentation at the same place. How to turn, copy and move them, you will learn in this video. Laso […]
