MVP Bill Jelen has created this VLOOKUP tutorial for those of you who have a basic working knowledge of Excel but want to improve your skills. This tutorial assumes you’ve heard about the VLOOKUP ...

How to add color to a drop-down list in Excel Your email has been sent Color can be a powerful element in an Excel drop-down list, and it’s easier to add than you might think. Perhaps you want to use ...

If you use simple copy and paste methods to duplicate an Excel drop-down list, you may discover a problem; when you copy a cell that has a drop-down list and press "Ctrl-V" to paste it into a new cell ...

Excel allows you quite a lot of freedom to customize your user experience via the use of macros. This tutorial will show you how to create and name worksheets using an existing list via a macro. You ...

Maintaining an Excel spreadsheet of computer files can help you keep track of important business documents or images. Unfortunately, Microsoft Excel doesn't include a one-step method for importing a ...

Who doesn’t love spreadsheets? Probably a lot of people, actually, but even if the thought of filling rows and columns with various data points doesn’t get your pulse rising, there are a number of ...

If you are looking forward to learning and understanding the basics of Microsoft Excel, then this tutorial will guide beginners through all the features you need to know. Excel is the premiere ...