Besides standard icons in office applications users are using, there are a number of shortcuts that will speed up your work. I picked several most common, which I also frequently mention on training, for many tricks in Excel, and also here is an useful special symbol list. The list of these shortcuts can be downloaded for free in […]
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 […]
