Search Article Database:

Chris Le Roy's Articles in Computer

  • 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.
  • 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.
  • 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.
  • 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.

Powered by Article Dashboard