Are you interested in the limits of Excel and its comparison to the older and the new version? Then, just for you I have prepared a table of selected specifications and comparisons between versions 2003 and 2010. At the end of the table are cross-referenced to the complete official specs from the Microsoft website. If this guide […]
In another free videotutorial, we will play with Excel again, this time looking at the option called wrap text within a cell. If the text is too long in the cell, it is not necessary to make fotn smaller, or change the column width, but just set the text to wrap over multiple lines. How to do […]
You do not know or you’re not quite sure which day of the week you were born? U wanna dates in your Excel tables to show the name days? Have a look at this video, in which I will show you a simple procedure to do this by setting the date format. If this guide has […]
Check out the first videotutorial, this time focusing on Slicer feature in PivotTables Excel 2010 and newer. In six minutes you’ll see how to create a Slicer, and how to set it up so that you can filter the data more interactive and more fun than ever before and also learn how to connect it with a […]
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 […]
