How-To Geek on MSN

How to Format a Whole Row When a Checkbox Is Checked in Excel

Checkboxes in Microsoft Excel are a great tool for tracking progress, improving data organization, and adding an extra layer ...
PC World

10 Secrets for Creating Awesome Excel Tables

Much of the data that you use Excel to analyze comes in a list form. You might need to sort the data, filter it, sum it, and perhaps even chart it. Excel tables provide superior tools for working with ...
Marketing Dive

A Guide for Marketers: Table Formatting In Excel

Detailed article outlines how to use Microsoft Excel to make data more useful, giving step by step instructions on using table formatting. Article uses sample data (which the user can download), and ...
TechRepublic

How to add conditional formatting a Microsoft Excel PivotTable without expressions

How to add conditional formatting a Microsoft Excel PivotTable without expressions Your email has been sent Microsoft Excel PivotTables range from easy to complex, and data and reporting requirements ...
TechRepublic

How to force a consistent phone number format in Microsoft Excel

How to force a consistent phone number format in Microsoft Excel Your email has been sent Combine an Excel custom format with data validation and remove the pressure ...
Redmond Magazine

Office 365 Excel Users Can Now Import Table Data from PDF Files

Microsoft announced this week that's it's now possible for Office 365 users to import table data from Adobe Portable Document Format (PDF) files into the Microsoft Excel spreadsheet program. The ...
Ars Technica

VBA: Connection string results in "External table is not in the expected format"

I'm attempting to connect to an excel file using an ADO recordset. There is a column in this that I need the sum of for a report. I'm familiar with ADO connections, so I assumed this would be the most ...