If you use Microsoft Office Word 2010 in your small business to create and edit complex documents that contain tables, you might need to number the columns in your tables. Use Word 2010's Numbering ...

Microsoft Excel 2010 can convert a worksheet to a data table to help you quickly analyze your related data in formatted rows and columns. When you need to expand the table layout, apply the Home tab ...

Whole-column references in Excel are silent performance killers, often forcing the program to manage a range of over a ...

An icon in the shape of a lightning bolt. Impact Link Excel is a great program with hundreds of helpful functions. Unfortunately, one function it's lacking is a simple way to merge two or more columns ...

In line with IGN's "3 Tier" system of organization in the table of contents, there are three tiers of coloring in tables, to be placed into each cell of a header row (use inline HTML ...

Pivot tables let you parse raw spreadsheet data to display specific information in a concise, easy-to-digest format. Here’s how to use them in Google Sheets. One of the best ways to master Google ...

What’s the difference between a table and a range of columns and rows on an Excel spreadsheet? How do I create and populate tables? And, once a table is created, how do we custom filter, format, and ...

Comparing two columns in Excel doesn’t have to be a difficult task, and to get the job done, we suggest using VLOOKUP. You see, not always; the columns you want to compare are in the same workbook or ...

Read this SQL tutorial to learn when to use SELECT, JOIN, subselects and UNION to access multiple tables with a single statement. It’s sometimes difficult to know which SQL syntax to use when ...