|
|
 SIGN
UP FOR FREE |
|
|
|
Sign Up for a free account or
learn more. |
|
|
 |
|
|
|
|
|
|
|
|
|
|
|
Most Recent Articles
|
- How To Disable Short Cut In Excel?
Over the last few days I have been running basic and advanced Excel courses and one of the common questions that people are asking me is "What is a simple way to Disable a Short cut in Excel?" I have spent lots of time thinking about a non-programmatic way to do this and there is a very simply solution. - How To Build A Mortgage Calculator For Free In Microsoft Excel
One of the really cool parts aspects of Microsoft Excel is the functions Microsoft has created for you to use. This means that rather than have to develop a function from scratch you can use pre-built ones to do a plethora of tasks like Building your own Mortgage Calculator. The Mortgage Calculator or PMT function is just one of many Financial Functions available. - 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 Secrets To Customising Your Microsoft Powerpoint Design Template
Microsoft Powerpoint is what I consider the most powerful presentation tool available on the market and whilst there are competitors, it is pretty obvious that Microsoft Powerpoint ranks as the number one presentation tool in the world. Just look at the number of seminars, lectures or presentations you go to and how many people are using Microsoft PowerPoint, in my experience, about 95% of them. Let me ask you a question though. How many times have you seen the same template, presentation after presentation? - 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 cells in Microsoft Excel. - Absolute References Vs Relative References In Microsoft Excel
Microsoft Excel is built on a regime of Columns and Rows with the intersection of these two elements giving us our cells. The cells in Microsoft Excel are always named Columns and then Rows, so a typical cell address would look something like - AB256. This particular cell is found on column AB and in row 256. The reference I wrote there is very important as it tells me something significant, that is, it tells me the cell address is a relative cell address. So what does this mean? Well there are two types of references used in Microsoft Excel which is an Absolute Reference and a Relative Reference. On a day-to-day basis, the relative and absolute reference doesn't really affect the operations of your spreadsheet. Where it does become a noticeable issue is when you start copying formulas from one cell to another. - 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.
|
|
|
