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
If you realize you do every day/week/month repetitive work, stop it! You can automate it now. Recording a Macro allows you to teach excel do certain steps and repeat them as often as you need with just 1 click. Lets check out this example: In the developer tab Click...
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,...