I often encounter questions as how to insert a video from YouTube to the new PowerPoint 2013, so we do not need to run a web browser. Inserting online video, although it seems like a simple thing, because on the Insert tab there is an icon Video > Online Video. But the redirects us to embed the […]
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 […]
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? […]
