Archive by Author
VLOOKUP Excel
VLOOKUP Tutorial The explanation for how VLOOKUP works in Excel is far more complicated than actually using it. The best thing to do is to get a rough idea of the arguments that VLOOKUP requires, and what it returns to you, and then quickly go on to look at a few VLOOKUP examples. Imagine you [...]
Full StoryRemove Duplicates From Excel
The ability to remove duplicate entries from a list is a useful one, and one that can be used in a variety of every day situations. Imagine, for example, that you are writing a shopping list and are copying and pasting ingredients from several recipes into an excel spreadsheet. Some ingredients will be repeated. Garlic [...]
Full StoryCount The Number Of Cells With Text In Excel
If you ever need to count the number of cells that contain text in Excel, there is a very easy way to do it. You will need two basic functions:
Full StoryExcel Resources
There are a great many Microsoft Excel resources on the internet, and some are of a really high quality. Some even cater to Excel 2010 – the most recent version of Excel. To help you get to grips with this ubiquitous spreadsheet program, we’ve listed some of the better Excel resources here.
Full StoryMake A 2011 Calendar In Excel
Making a 2011 calendar in Excel 2010 is probably easier than you think. You don’t have to spend time getting the cell formatting right and you don’t have to figure out what Excel formulas to use. All you need to do is use an Excel Template.
Full StoryExcel Drop Down Lists
A drop down list in Excel presents a number of options for the user to select from. The advantages of eliciting a response from the user in this way are that:
Full StoryThe Quick Access Toolbar In Excel 2010
The quick access toolbar in Excel provides a selection of the more commonly used commands in one convenient place – the top left corner of the workspace (above the file tab).
Full StoryNumber Formatting In Excel
Number formatting in Excel is the process of controlling the appearance of numbers in your spreadsheets. Formatting numbers appropriately will help your readers to read and understand them better. Questions you need to ask yourself when dealing with numbers in Excel include:
Full StoryMicrosoft Excel Training
Lynda.com offer a range of high quality and professionaly produced Microsoft Excel Training videos. You can sign up in a matter of minutes and take advantage of the following benefits:
Full StoryExcel Save As PDF
Many people prefer the way that an Adobe PDF (Portable Document Format) document presents information to the way that a standard spreadsheet looks. Whereas in the past you needed to download and install a special add in to save a spreadsheet as a PDF (for example, the Microsoft Office 2007 Save as PDF Add-in), Excel 2010 comes with this facility by default.
Full Story
