*
 
Articles, content for websites, ezines and newsletters
Search for articles:

Chris Le Roy's Articles in Software

  • How to Create A Microsoft Excel Database
    The term Microsoft Excel Database has never really sat very well with me since my primary role in the IT world has been in developing database and what is used by the spreadsheeting fraternity is what I consider an over glorified list. However, for the sake of peace, I want to outline some of the principles you must follow in building what is known as the Microsoft Excel Database.
  • The Secret Microsoft Excel Steps That Allows You To Select 50 Columns with just 5 Mouse Clicks
    One of the great challenges that we have when working with Microsoft Excel is selecting large volumes of columns or rows as quickly as possible. The core reason we usually need to select such large numbers of columns is usually to hide them. For example if you are building a template for users to use, you would generally try to ensure that the only cells that they see is just the ones that you want them to use or put data into.
  • Why and How to Use Protection in Microsoft Excel?
    One of the unsung hero's in the Microsoft Office suite of applications is in fact Microsoft Excel. It is one of the most widely used applications in business but yet it hardly gets a mention due to its lack of sex appeal compared to other Microsoft Office applications like Microsoft PowerPoint and Microsoft Project.
  • Mastering the IF Function in Microsoft Excel
    The IF function in Microsoft Excel seems to really cause many people a lot of heartache and grief, but all in all it is actually really not that difficult of a tool to use.
  • Excel: Five Issues to Consider When Developing an Excel Template
    Microsoft Excel Templates are fantastic tools that allow you to get your team to put in their data for your business quickly and easily whilst still allowing for the consolidation of the data with very little work. There is however five key issues you need to consider when developing the Excel Template.

Unlimited
Autoresponders by AWeber
Copyright 2008, A1-Optimization

Powered by Article Dashboard