Chris Le Roy
Chris's latest writings
How To Use Labels In Microsoft Excel 2003 To Sum Cells
Microsoft Excel is a fantastic tool but one of its downfalls is the use of cell addresses especially when you are trying to sum a series of numbers however Microsoft has a really cool tool that allows you to add up a series of cells simply using the labels around your data. In this article we will investigate the steps you need to follow to be able to use Labels to Sum... (posted by Chris 5 years 198 days ago.)
2
Microsoft Excel is a fantastic tool but one of its downfalls is the use of cell addresses especially when you are trying to sum a series of numbers however Microsoft has a really cool tool that allows you to add up a series of cells simply using the labels around your data. In this article we will investigate the steps you need to follow to be able to use Labels to Sum... (posted by Chris 5 years 198 days ago.)
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. Let us review … A database in... (posted by Chris 5 years 203 days ago.)
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. Let us review … A database in... (posted by Chris 5 years 203 days ago.)
How To Control What Data Can Be Entered Into A Microsoft Excel Cell?
Microsoft Excel by default allows you to enter any type of data into a cell however sometimes when you are developing a spreadsheet for use by your staff or external people you will want to control what data can be entered into a specific cell. Why?? Well in certain situations like in Business Models or spreadsheets that calculate, having invalid data in one cell can cause your whole... (posted by Chris 5 years 204 days ago.)
Microsoft Excel by default allows you to enter any type of data into a cell however sometimes when you are developing a spreadsheet for use by your staff or external people you will want to control what data can be entered into a specific cell. Why?? Well in certain situations like in Business Models or spreadsheets that calculate, having invalid data in one cell can cause your whole... (posted by Chris 5 years 204 days ago.)
How To Export A Microsoft Access Report as a PDF
Microsoft Access is one of the most awesome prototyping tools anyone in software development could ever use, however there are also some really serious downsides as well. I know the software purists will be rolling over in their graves with my comments but after 20 plus years of commercial software development for some of the worlds largest companies I stand by my comments. Microsoft Access makes it very... (posted by Chris 5 years 204 days ago.)
Microsoft Access is one of the most awesome prototyping tools anyone in software development could ever use, however there are also some really serious downsides as well. I know the software purists will be rolling over in their graves with my comments but after 20 plus years of commercial software development for some of the worlds largest companies I stand by my comments. Microsoft Access makes it very... (posted by Chris 5 years 204 days ago.)
Copyright 2012 IcoLogic, Inc.
Generated live.