On my trainings I usually show the “smart table” as a bonus topic, the students are amazed by the options of this tool and collectively agree that they do not want to work with another table anymore. Indeed it makes easier both formatting and filtering, subtotals, and more. Let’s see at least some of the tweaks, others I will […]
Excel 2010, among other innovations, comes with a tool called Sparklines. It is a tool that can create a small chart in a worksheet cell showing the trend of selected numbers, eg. the income gains over time. How this instrument is inserted into the worksheet and what can be set inside, you will learn in this article. If this […]
I still encounter problems when typing texts in Word and sometimes comes preposition or conjunctions at the end of the line. If you care about that it should not be at the end of the line, it must moved to the next line, but not with several spaces or by Enter! How to do it correctly, […]
Many people ask how to work with a percentage in Excel. There’s no science – read this short tutorial, which I have prepared for you. Learn how to work with percentages calculations, how to change the number format to percentage, and add a % symbol directly using your keyboard. If this guide has helped you, become a fan on Facebook […]
Are you upset when eg. Outlook or Word writes the first letter uppercase at a place where you just do not want to? Programs are set so that once you press Enter, it will create a new paragraph and that shall be considered logical that the beginning of the paragraph or sentence should be capitalized. Or when […]
In the version of PowerPoint 2007 and newer we will find a function that converts bulleted text to a diagram so-called SmartArt. SmartArt diagram allowing us to look at the points of the text – list – from a graphical point of view. Individual points are then engaging presentations and one tends to remember them better than […]
Image inserted into a document can enrich it and may give him a whole new dimension. Word 2007 allows you to add different effects to images, and I do not mean just a shade or color of the edge, but also crop according to the desired shape, reflections, 3D rotating, and more. In this article you can […]
