WHAT YOU WILL LEARN
Learn how Excel works, its formulas, spreadsheets and macros.
Since MS-Office programs have the same architecture its all connected. You can control everything out of your excel-sheet.
Through Visual Basic Application you can extend your capabilities and create your own functions
Learn how to connect your mighty spreadsheets and let them update each other and do the work for you.
RECENT BLOG POSTS
Recording a Macro allows you to teach excel certain steps and repeat them as often as you need with just 1 click. This can be useful if you are doing repetitive work in the same or similar workbook. Lets check out this example: Click on Record Macro Write a name for...
What is a VBA-Editor? Once you have activated the developer bar, you will find the "Visual Baisic" sign as the first symbol in the row. You can click on it to open it, or alternatively press Alt + F11 on your keyboard. Don't be scared! It looks intimidating but when...
First step to start writing the VBA Code or record Macros, you need to add the developer task to your excel toolbar. The developer has some extra functions which are not displayed in the standard task bar. Depending on your Excel-Version (I use here 2010), you will...
Hail you dear friend! My name is Vitali and I welcome to to my blog. If you have not checked the about page yet, you should do, to learn something about me, since I will be your instructor in future. In few days I will upload the first post about Starting with Excel,...