Drop-down lists in Excel let you create a list of valid choices that you can select for a given field. We'll show you how to use tables, named ranges, formulas, data validation, and table styles.

First, select an application that can create and edit spreadsheet files. Microsoft Excel has long been a core component of the Microsoft Office suite for Mac and Windows ($70 a year). If you don ...

While Excel is a powerful tool for organizing data and performing complex calculations, it’s easy to get lost in a sea of numbers and bland cells. At times, when you deal with large databases ...

How to Create Excel Spreadsheets With MySQL. When you use MySQL to query a database, you have the ability to view results from that query on your screen or send them to a text file. If you insert ...

Here’s how to make a Gantt chart in Excel to accommodate complex agile project management within the familiar tool.

Microsoft Excel lets you swiftly create a variety of useful records to log sales calls, service calls and other kinds of call information you need to run your business.

Graphs in Excel help break down your data into an easily digestible format. Here’s how to make a graph in Microsoft Excel.

Don EdringtonNorth County TimesWhen I first got into desktop computers in the late 1970s we hadto write our own programs, because none had yet been created forthese new, mysterious devices. The fir… ...