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 […]
Training description Are you only interested in a specific part of Excel? We offer the opportunity for consultation of specialized methods and tools in Excel in any combination. A list of possible topics is given below. Choose topics that you want to learn during the training. Topics are presented by the trainer, then he answers […]
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 trying to gain unique values from a large or small list of repeating records? Elimination of duplicates is common question on training, so I put here how to do it in Excel 2007 and newer. Earlier this was possible only by using advanced filter, which allowed the filtering records without duplicates. In Excel 2007 version it easier for us by […]
Functions in Excel 2007 themselves have not undergone much changes, but we now have a new option for their creation. Also there were added a few new functions (eg. SumIFS etc.). Previously we used a Function Wizard for its creation , the more capable users wrote it directly into the address bar. The address bar is also in this version […]
Are you using Microsoft Office 2007 or newer and you think about how to keep Quick Access Toolbar settings for other computers or as a backup of frequently used buttons? Previously in the 2003 version, it was enough for the backup of the toolbar to save the file as a template, or move the settings through Organizer […]
Training description Are you interested in advanced tools of Excel? We offer the possibility of learning advanced methods and tools in Excel with the following suggested outline. Topics are presented by the trainer, then he answers any questions from the audience about the topic and then students do exercises on their computer to use their […]
