The Pivot Table is a tool that Excel uses to create custom reports from your spreadsheet databases. All you need is one common, unique field. Here's how to set it up with multiple spreadsheets.
Excel filters help you find exactly what you want, no matter how big your spreadsheet database is. Here's how to set number, text and data filters.
In Excel, custom input or error messages explain the rules for each field to prevent data-entry errors. Here's how to set them up in a spreadsheet.
Excel's conditional formatting lets you customize how your data displays, from changing colors and shading to adding icons and more. Here's how it works.
Photoshop Text Effects, also called Styles, are an essential skill for adding splashes of color, texture and more to fonts on a page. Here's how to do it.
Excel percentage formulas can get you through problems large and small every day. We'll walk through several examples, including turning fractions to percentages, and calculating percentage of total, increase, or decrease.
The pivot table is a collection of tools that Excel uses to create reports from complex, multi-file spreadsheet data. Here's how to generate reports for single tables
How to replace words; extract first and last words, matched or a specific words in a string of text
Use Microsoft Word to design your holiday cards or other graphic projects for your celebrations. We'll show you how Shapes, Fonts, and
An Excel macro is a sequence of commands (or directives) that you record to perform a series of tasks. We'll show you how to create custom macros for your spreadsheet.
Excel possesses formidable database powers. Creating a relational database starts with a Master table that links to subordinates called (awkwardly) Slave, Child, or Detail tables.
Excel's chart features can turn your spreadsheets into compelling visual ideas. This guide covers the basics and the best tips.
We'll dive deep into Excel workbooks in this guide, starting with the basics and diving straight into powerful three-dimensional workbooks.
Excel spreadsheets do so much. This guide starts with the basics and will add more Excel tips over time, so you'll always be in the know.
When Microsoft Excel complains it "cannot complete this task with available resources," or it's "Out of memory," here's what to do.
Articles by JD SartainOlder stories