For larger tables in Excel often happens that when you scroll down or right mouse it will hide heading rows or columns, and so we lose sight of the importance of information displayed. To avoid this, you can use a tool of freeze panes. How this work and what can it do, you will learn in this free […]
The eighth videotutorial will focus on PowerPoint 2013, namely new feature allowing for performance combination and merging several shapes, like it can do Microsoft Visio. These are the five operations: union, combination, intersection, division and subtraction. In this manual, you can look at how it works in practice, and then you can send us the shape that […]
Plenty of websites want to be with their visitors in prolonged contact and one of the ways they regularly send updates is to use the RSS feed. How can be such channel added to Outlook, so you can receive ITLektor.cz news from the site directly to your favorite email client? You will learn it in this article. […]
How to work with calculations with square roots and powers in formulas Excel? It serves mathematical symbols and functions for this. In this article we will focus on just how to use it in excel formulas or insert a square root of various levels. They are not used too often, but in certain subjects like math, statistics, […]
Check out the new video for free about Flash Fill tool in Excel 2013 that helps you to divide words into several columns, the attributes of the date and more. Just to show what you want to do, and Excel 2013 will complete the job. You do not need to some functions, which used to take […]
I have prepared another video; and this time we are back to Excel, which will introduce a quick tweaks to select empty cells. You need the table quickly find and select blank cells? This trick saves a lot of time. See one minute video and everything also try on the attached file. If this guide has helped you, become […]
If you do not like going to the training, you can use the new service on the web ITlektor.cz – online webinars. It is a modern and highly interactive way of learning that takes place over the Internet using a remote control and desktop sharing. Arrange a time, boil a cup of coffee, sit in […]
