(Čeština) Získána certifikace MOS 2010
Sorry, this entry is only available in Czech.
Optimization consultancy
We will analyze your needs of MS Office and advise you or create a best possible solution.
Create a database or template
VBA programming Some macros can be set by users, but complicated commands are necessary to be programmed in VBA. Automation of operations for several sheets or files at once – no problem. Data conversion, creation of forms and applications in Excel or Access is a job for professionals. If you have a requirement to create macros or […]
Office 2010 training
Microsoft Office 2010 comes in several versions, not only for companies but also for students and households. Complete sets of comparisons can be viewed here. Difference between 2010 and 2007 is smaller than if we compare 2007 and 2003. There were added a few graphical effects, features, a new “Backstage” view replacing the previous Office button. Under the File […]
Convert text to SmartArt
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 […]
Picture in a Word and crop
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 […]
Remove duplicates in Excel
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 […]