Tell Your Friends About ArticleMap.com

Sign-Up Free  |Member Login

Chris Le Roy's Articles in Software Show All|Display Category|Title|Newest|Oldest Microsoft Word Basics: How to Select Text Effectively Using Microsoft Word allows you to create highly effective documents that are professional and pristine. However many users of this powerful application still find the simple task of selecting text challenging, especially in long documents. Microsoft Excel Basics: How to Embed a Chart Microsoft Excel is a powerful tool that allows you to take data from your worksheet and position the chart within the worksheet. This type of chart is known as an Embedded Chart. Basic Excel: Developing Your First Spreadsheet Developing your first worksheet can be an exciting time but there are a few things you need to be aware of. When entering data into a cell, the data is normally going to be text, numbers or a formula. Microsoft Excel: What Is Spreadsheeting? The concept of spreadsheeting has been around for hundreds of years. The process can be described as the ability to arrange numbers, characters and other objects into rows and columns. It is most common that spreadsheets only contain numbers and text. Microsoft Excel 2003: 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. Microsoft Excel 2003: How to Join Multiple Cells Together Using Text Concatenation One of the issues you maybe faced in Microsoft Excel 2003 is having to combine various cells together into one single cell. For example, you may have three columns named, Title, First name and Last name and you maybe asked to combine those three values together. To achieve this capability we use the Text Concatenation Function. This article will look at the process of combining these cells together. Microsoft Excel 2003 Shortcuts: How to Create a Drop Down Box in a Microsoft Excel Cell Have you ever been in a situation where you were building a template in Microsoft Excel 2003 and it would have been really useful to actually have a drop down box so that your users could choose from a preset list, rather than them simply typing in their own values? Well the cool part is that Microsoft Excel 2003 allows you to build your own drop down boxes in the application and in this article we will show you exactly how to do this. Microsoft Excel Shortcuts: How To Setup A Shared Workbook Microsoft Excel 2003 has become the spreadsheet of choice for over 80% of corporate businesses around the world. One of the clear advantages of using Microsoft Excel 2003 over other spreadsheeting programs is the ability to have multiple people entering information into the same spreadsheet. This function in Microsoft Excel is called Shared Workbooks and we will go through how to setup this capability in this article. Microsoft Excel 2003 Shortcuts: How to Use Labels in Formulas Microsoft Excel 2003 is one of the most diverse tools in the Microsoft Office 2003 arsenal. It allows you to manage numbers and data by creating formulas that automatically calculate but in many cases users build inefficient formulas. These formulas can in fact cause problems in the future if people add in rows to your field. To resolve this problem we can in fact use labels to add up your fields. 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. How Autocorrect in Microsoft Word Can Help You With Acronyms The world today has gone literally gone acronym crazy. Every industry has its own plethora of acronyms to bamboozle the uninitiated. Acronyms are also often a source of great pain for those people who have to create procedure documents for their industry. There is a way to survive this turmoil through the power of Autocorrect and it will definitely save you time. 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. 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.

Sign Up Free | Learn More Submit Articles Member Login Top Authors Most Popular Articles Submission Guidelines Ezine Notifications Article RSS Feeds Press Release About Us Link To Us Contact Us Privacy Policy Terms of Service Sponsored Ads: Recommended Hosting Related Sister Site: Submit Health Articles Now

Copyright © and All Rights Reserved.
Use of Our Service is subject to Terms of Service and Privacy Policy.