For calculations in Excel can be often assumed difference between the format of the result and the real value rounded. In this tutorial you will learn how solve this problem and learn practical function to correct round. If this guide has helped you, become a fan on Facebook and recommend this site to your friends, it can be useful […]
Excel users often struggle with functions, which are total more than 350. Many of them will learn on my trainings, but how to remember them after a long time? In this article we will focus on some useful functions for working with dates. For each function you will find not only a general description, but a […]
Using the Outlook calendar and want to see our or foreign holidays? No need to manually writet them as events, but just use a simple procedure described below. 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. Adding holidays Follow this […]
Sorry, this entry is only available in Czech.
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 working with different applications or the Internet we sometimes need to take a screenshot or cutout window that appears. Such image we then save as picture file, send through an e-mail or put it into the document. Users often use time-taking ways eg. press Prt Sc (PrintScreen), insert into the Paint, subsequent crop, and then save […]
