Welcome to Microsoft Office Applications.

Welcome. Microsoft Office includes a wide range of Applications that can be used for a wide range of activities required in your daily life or at work. There are many office tools available to an user – few that are free and lots that are not; however, MS Office has grown and maintained their usage and popularity among users all over the world.

Well, this blog is not an agency to promote MS Office in any way, but to re-iterate, we will be talking about codes and scripting which would find their extensive use in these office applications. So, why not start with a small introduction to the same. This is where the codes we discuss in the blog will find their use. Most of the readers of The Code Point would know about MS Office and its basic applications. We can assume it correctly as because if the user have not used it earlier, he would not find the need of searching for codes that are required in these applications. Anyways!

Microsoft Office comes with an online resource of free training which talks about basics of these Office Apps and shows a way to the reader where he can walk on. I have myself used these tutorials many a times, while using MS Word 2003 and MS Excel 2003 and more now, when we are working on MS Office 2007. Feel free to visit the following web link and go through the various free training courses. These courses are self paced and talks about almost all necessary amendments and dissimilarities of an old and new version of MS Office App.

The link: Microsoft Office Training – Microsoft Office Online

Note: If you want something more in those training courses apart from what is listed in the front page, please use the ‘Search Training’ tool at the top of the page.

Well, I was going through a lesson sometime ago and I really loved the way they told about ‘Nested Loops’ used in VBA. Check the following:

Do While (Earth Revolves around the Sun)

    Do While (Earth Rotates around its axis)

        If (Facing Sun) Then

            Day

        Else

            Night

        End If

    Loop

Loop

Quote: OK, so the code above wouldn't actually run in Excel, but it illustrates that for each big loop (around the sun) there are 365 smaller loops (around Earth's axis).

How easy to understand and simple is that? I just loved it. Teaching has to be thus. Simple, easy and to the point! This is the reason I would recommend the reader to go through the material there in free time (even if you consider yourself to be advanced and have no time) and I am sure you will see things that might have missed your eyes!

Best of Luck!