Archiv článků

Sorry, this entry is only available in Czech. ...

Sorry, this entry is only available in Czech. ...

Sorry, this entry is only available in Czech. ...

Sorry, this entry is only available in Czech. ...

Sorry, this entry is only available in Czech. ...

Sorry, this entry is only available in Czech. ...

Training descriptionAt this training, students will learn advanced template creation tools ...

Training descriptionAt this training you will learn about concepts such as procedure, meth ...

Sorry, this entry is only available in Czech. ...

Sorry, this entry is only available in Czech. ...

Sorry, this entry is only available in Czech. ...

Sorry, this entry is only available in Czech. ...

Sorry, this entry is only available in Czech. ...

Sorry, this entry is only available in Czech. ...

Sorry, this entry is only available in Czech. ...

If you need to convert a text expression to a formula in Excel, there is a way even withou ...

Sorry, this entry is only available in Czech. ...

Sorry, this entry is only available in Czech. ...

Sorry, this entry is only available in Czech. ...

Sorry, this entry is only available in Czech. ...

Sorry, this entry is only available in Czech. ...

Sorry, this entry is only available in Czech. ...

Sorry, this entry is only available in Czech. ...

Sorry, this entry is only available in Czech. ...

Sorry, this entry is only available in Czech. ...

Sorry, this entry is only available in Czech. ...

Sorry, this entry is only available in Czech. ...

Training descriptionCheck out the new features in MS Office (2013/2016/2019). Teaching is ...

Sorry, this entry is only available in Czech. ...

The last part of tutorials Deal with Pivot Tables represents tweaks that do not fit into p ...

Another episode of tutorials Deal with Pivot Tables continues with the topic how to consol ...

Another episode of tutorials Deal with Pivot Tables continues with the creation and capabi ...

Another episode of tutorials Deal with Pivot Tables continues with the topic Filters, Slic ...

Do you need in Excel at some point to see what is in another table? To have a live picture ...

Using the Outlook quick reply (CTRL + R) and the need to change the language grammar check ...

In tables working with time values is sometimes necessary to calculate a period longer tha ...

You may know that Excel can subtract from each other not only numbers, but also dates. The ...

Another episode of tutorials Deal with Pivot Tables continues with the topic Calculated fi ...

When creating presentations, we often use slides of previously created presentations. In t ...

Another episode of tutorials Deal with Pivot Tables continues with the topic Grouping of d ...

Another episode of tutorials Deal with Pivot Tables continues with the topic Page field. I ...

With the arrival of new version Windows 10 you may have lost track of possible settings, a ...

When writing in Word, you can automatically set the format with words, bullets, and in man ...

The video series Deal with Pivot Tables continues with episode Design tab. In this tutoria ...

The video series Deal with Pivot Tables continues with episode Calculation options. In thi ...

When creating presentations or other documents sometimes we need to insert an image of ano ...

The video series Deal with Pivot Tables starts with a tutorial Basic model. You will learn ...

Do you have wrong direction of a table and you do not want to rewrite the cells from a col ...

How many tasks in Excel can be performed with double click? You may be surprised to learn ...

We use the Address book in Outlook to organize our contacts. What to do if we want to send ...

Are you a fan of innovations in software? In this manual you will find useful information ...

Many of you certainly not only create the presentation, as well as present them to your co ...

For calculations in Excel can be often assumed difference between the format of the result ...

Excel users often struggle with functions, which are total more than 350. Many of them wil ...

Using the Outlook calendar and want to see our or foreign holidays? No need to manually wr ...

Sorry, this entry is only available in Czech. ...

Users commonly use predefined series of numbers, dates, days of the week or month. Besides ...

Děkuji klientům a návštěvníkům těchto stránek za podporu v roce 2014 a přeji mnoho úspěchů ...

When working with different applications or the Internet we sometimes need to take a scree ...

When connecting Microsoft Office applications we often use copy a table from Excel into Po ...

The document with Tracking changes on you can easily record, what adjustments were made. I ...

Every day we work with many documents, sometimes we want to connect to them over the phone ...

We finish the series Deal with Disserations with topic Hidden symbols (nonprinting). Many ...

The series Deal with Disserations continues with topic Page margins. For the entire docume ...

The series Deal with Disserations continues with topic Picture captions. Have each figure, ...

The series Deal with Disserations continues with topic Adding footnotes. Use these numbere ...

When writing your thesis or dissertation, you will probably use citations. If you use a to ...

The series Deal with Disserations continues with topic Citations and Bibliogprahy. Setting ...

The series Deal with Disserations continues with topic how to Split to sections. A documen ...

The series Deal with Disserations continues with topic Page numbering in footer. Automatic ...

The series Deal with Disserations continues with a topic making of a Table of contents fro ...

Information about the upcoming new version of office package Microsoft Office appeared on ...

The series Deal with Disserations continues with topic tématem Multilevel numbering of hea ...

The series Deal with Disserations begins with a topic Heading Styles. See how to set style ...

Have you ever seen that the font size in Word comments become so diminished that the comme ...

Presentations should contain only the key points that the speaker is talking about. It mak ...

Did you know that it is possible to make organizational chart in Visio by simply a few cli ...

When creating shapes in the drawing it is needed to use the connector. These lines allow t ...

You need to present information to different users who can not personally attend your meet ...

Access Reports are designed for printouts. The proposed structure of the graphical element ...

Did you receive a table full of calculations that someone else did and you got lost inside ...

Forms of Access serve as a user interface, which allows us to easily inspect the data, mod ...

The flowchart is one of the basic types of diagrams in Visio. Roughly speaking, that is us ...

To get information from tables are designed Queries. This object in Access gets the data f ...

In the created database it is good to start with tables because without them the database ...

For the arrangement of slides in presentations to chapters in PowerPoint (since version 20 ...

Microsoft Access is used to create and manage databases. Generally, it is a higher level o ...

How to set a paragraph in Word rightly so, to begin a new page? People often use the Enter ...

When creating presentations, I often see that I need to merge several presentations into o ...

It happens that the table contains a group of heading lines, but these titles will not app ...

Did you know that Excel can calculate a different way than by creating formulas? A little ...

When selecting the cells in Excel it is sometimes necessary to quickly find cells with som ...

In Excel 2013, you can compare numeric data geographically on a three-dimensional globe, u ...

Using a version of Microsoft Office 2013 and create a new file, you lack the ability to lo ...

Excel 2013 comes with addin PowerPivot and PowerView. PowerPivot is used to prepare the da ...

This is a video on demand for Jakub, who searched for a solution of the problem with numbe ...

Two or more documents in Word with small or larger differences can be compared by integrat ...

Sorry, this entry is only available in Czech. ...

Maybe the article title does not say anything, but if you are often importing txt or csv f ...

I received the question about how to insert new blank row in the table below each row. Sur ...

When you copy cells in Excel, the user can choose how the copy inserts. I often encounter ...

It is also strange to you that the column names in the table sometimes omitted some letter ...

Making a presentation can be faster than you think. Especially if you have already text ou ...

One of the basic functions, yet many people are not using. If they know it they could save ...

Did you get the foreign language version of Microsoft Office, and not familiar with it? So ...

Are you working with spreadsheets, where multiple users make changes? Then maybe I will ag ...

  ...

It happened to you that you were used to save incoming messages or attachments in Outlook ...

I often encounter questions as how to insert a video from YouTube to the new PowerPoint 20 ...

You need to have calculation in Excel always with current value of foreign currency or sto ...

When completing tables we may offer some items to be selected from the list of options usi ...

To automate the calculation and display values depending on the fulfillment of conditions  ...

The conditional formatting in Excel automatically help color the cells with numbers, text ...

Going on a vacation for longer time and you want your e-mail box automatically inform the ...

Making a presentation is not only about to insert text and images, it should also look nic ...

Sorry, this entry is only available in Czech. ...

In large tables it is not easy to navigate and quickly find what you need. This tool will ...

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. ...

Are you also unpleasantly surprised to find that Outlook 2013 no longer show the task bar ...

One of the new features introduced by the developers of Microsoft Excel version 2013 is th ...

It happens to everyone in life, that suddenly you do not see the Excel cell gridlines and ...

Excel is an effective tool for managing data in tables. The easiest way to learn to work i ...

In a Word document, PowerPoint presentation, or Excel spreadsheet you can have values that ...

Creating a chart may not take minutes or hours. Using simple trick you'll have it in a few ...

In Outlook we can set automatic signature to new messages, the replies or forwarded messag ...

It also happens that you have to repeatedly change the color, font type or cell borders? E ...

To make a table of content in Word is not a complicated thing, but what if you want to gen ...

I often hear about how to change the language grammar checker in a presentation on all sli ...

For larger tables in Excel often happens that when you scroll down or right mouse it will ...

The eighth videotutorial will focus on PowerPoint 2013, namely new feature allowing for pe ...

Plenty of websites want to be with their visitors in prolonged contact and one of the ways ...

How to work with calculations with square roots and powers in formulas Excel? It serves ma ...

Check out the new video for free about Flash Fill tool in Excel 2013 that helps you to div ...

I have prepared another video; and this time we are back to Excel, which will introduce a ...

If you do not like going to the training, you can use the new service on the web ITlektor. ...

Sorry, this entry is only available in Czech. ...

Do not miss this video very helpful for those who would like to create a timeline in Word. ...

So you can easily decide which level of training is best for you, try the following tests. ...

Do you want to be for your clients easy to find? Let us create a web site to your needs! A ...

Microsoft Office 2013 brings a fresh look and a lot of interesting new features. Let yours ...

...

[gallery link="file" ids="1449,1451,1450"]

Besides standard icons in office applications users are using, there are a number of short ...

Are you interested in the limits of Excel and its comparison to the older and the new vers ...

How to quickly and easily select various parts of a document in Word? Even though you migh ...

In another free videotutorial, we will play with Excel again, this time looking at the opt ...

You do not know or you're not quite sure which day of the week you were born? U wanna date ...

  [gallery link="file"] [adinserter name="incontent"]

[gallery link="file"]   [adinserter name="incontent"]

Check out the first videotutorial, this time focusing on Slicer feature in PivotTables Exc ...

On my trainings I usually show the "smart table" as a bonus topic, the students are amazed ...

Excel 2010, among other innovations, comes with a tool called Sparklines. It is a tool tha ...

Presentations are designed for showing of information, data visualization, promote corpora ...

Training descriptionOn this training, students will learn techniques for practical use Mic ...

Training descriptionOn this training, students will learn techniques for practical use of ...

Training descriptionAre you only interested in a specific part of Excel? We offer the oppo ...

I still encounter problems when typing texts in Word and sometimes comes preposition or co ...

Many people ask how to work with a percentage in Excel. There's no science - read this sho ...

...

Are you upset when eg. Outlook or Word writes the first letter uppercase at a place where ...

Sorry, this entry is only available in Czech. ...

Microsoft Office Solution Need help with a problem in Microsoft Office products? Mic ...

VBA programming Some macros can be set by users, but complicated commands are necessary t ...

Microsoft Office 2010 comes in several versions, not only for companies but also for stude ...

In the version of PowerPoint 2007 and newer we will find a function that converts bulleted ...

Image inserted into a document can enrich it and may give him a whole new dimension. Word ...

Are you trying to gain unique values from a large or small list of repeating records? Elim ...

Did you use the ruler for aligning text and page margins in Word 2003? But in the 2007 ver ...

Do you find your presenation boring? Just add a few minor effects and it can now look bett ...

Functions in Excel 2007 themselves have not undergone much changes, but we now have a new ...

Are you using Microsoft Office 2007 or newer and you think about how to keep Quick Access ...

Training descriptionStudents will learn how to practically use Word to their work and crea ...

Training descriptionAt this training, students will learn techniques for orientation in Mi ...

Training descriptionOn this practical training, students will learn how to work effectivel ...

Training descriptionAt this training, students will learn techniques for orientation in Mi ...

On this training, students will learn the procedures for orientation and basic of Internet ...

Be prepared for successfully complete ECDL exams. A list of topics is provided below. Topi ...

On this training, students will learn the procedures for orientation and basic usage of fe ...

Training descriptionAre you interested in advanced tools of Excel? We offer the possibilit ...

Training descriptionThis is the most popular training of Excel. Students will learn how to ...

Training descriptionIn this workshop, students will learn the basics of Microsoft Excel. A ...

Sorry, this entry is only available in Czech. ...

I can help you learn how to work in the following applications:Microsoft ExcelMicrosoft Wo ...

Sorry, this entry is only available in Czech. ...

Shark illusion ...

It happened to you that you got to foreign language web and you had problems with a transl ...

Srdce ...

Stereogram bábovka ...

Pokroucená šachovnice ...

Another master-optical illusion. Look at the picture and move eyes by frame. What do you s ...

An interesting optical illusion with two circles. Follow the middle and pinch the screen. ...