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 […]
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 […]
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 […]
It happens to everyone in life, that suddenly you do not see the Excel cell gridlines and no matter what you do, you can not show it back? The solution is not difficult, only to find it. How to do it, you will learn just in this video. Hiding the grid does not have to be on your […]
In a Word document, PowerPoint presentation, or Excel spreadsheet you can have values that you want to replace with something else. To avoid having to manually scroll through text one by one, use the tool to mass replacement of one value by another. It can be used eg. to replace two single spaces, moving one-letter prepositions […]
Creating a chart may not take minutes or hours. Using simple trick you’ll have it in a few seconds. In the video you can find a way to create a chart, but it is not the only way. Remember that the key to success is to have properly created source table and the data correctly selected. Wrong data […]
